Please post any example code for impoting XLSX type of file using Proc import syntax.
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;
proc import out=want datafile='/folders/myfolders/myfile.xlsx' dbms=xlsx replace; run;
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
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;
Thanks!!!!
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 ?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.