PROC import

[Bhargav_Movva]

Please post any example code for impoting XLSX type of file using Proc import syntax.

[Reeza]

proc import out=want datafile='/folders/myfolders/myfile.xlsx' dbms=xlsx replace; run;

[Bhargav_Movva]

Thanks for your reply...

Code i submitted--->

proc import
datafile="E:\SAS\SAS_Total\practice programs\proc_import.xlsx"
out=importingxl dbms=xlsx replace;
run;

log---->

proc import
 datafile="E:\SAS\SAS_Total\practice programs\proc_import.xlsx"

out=importingxl dbms=xlsx replace;
ERROR: DBMS type XLSX not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Can you please spot what's wrong

[Reeza · Accepted solution]

What version of SAS do you have?

You may not have a license to import/export SAS files either, it requires SAS ACCESS to PCFILES I believe.

Try running the following to see if it lists SAS Access in the listing. If you post the output to here, make sure to remove your Site number.

proc setinit; run;

proc product_status; run;

[Bhargav_Movva]

Thanks!!!!

[manish_1]

Hi,

I want to know that if i have data in excel file and i want to get only selected data out of it to make a dataset so can we use where statement in proc import. ?

if not then how can i import selected data out of excel file ?