J********J
发帖数: 571 | 1 请问SAS9.2如何导入xlsx的excel文件? |
B******y
发帖数: 9065 | 2 http://support.sas.com/kb/32/455.html
You must have the newest SAS 9.2 Phase 2 (TS2M0). |
J********J
发帖数: 571 | 3 I have tried it already. But it didn't work. |
p***r
发帖数: 920 | 4 proc import
libname
or change xlsx to csv
...
【在 J********J 的大作中提到】
: I have tried it already. But it didn't work.
|
J********J
发帖数: 571 | 5 Thanks for the reply.
Is there anyway that I can change XLSX to CSV in the program? I think I
would have to import the XLSX file first, then I can change it to CSV.
LIBNAME won't work for XLSX, as far as the info I can google. |
a****g
发帖数: 8131 | 6 just save as xls format, i.e. 1997-2003 excel format
【在 J********J 的大作中提到】
: 请问SAS9.2如何导入xlsx的excel文件?
|
p***r
发帖数: 920 | 7 So far as I know and practice, libname works well with .xlsx
LIBNAME LIBIN1 excel "xxxxxxx.xlsx" ;RUN;
【在 J********J 的大作中提到】
: Thanks for the reply.
: Is there anyway that I can change XLSX to CSV in the program? I think I
: would have to import the XLSX file first, then I can change it to CSV.
: LIBNAME won't work for XLSX, as far as the info I can google.
|
