Hi there
I would like to import the contents on my excel file using my path in a variable. I am getting an error:
WARNING: Unsupported device 'SVG' for EXCEL(EGXLSSX) destination. Using default device 'PNG'.
32
33 filename jobs "&_file./Jobs.xlsx";
WARNING: Apparent symbolic reference _FILE not resolved.
34 proc import out=Jobcount replace
35 datafile = "jobs";
ERROR: Unable to determine datasource type. Please use the DBMS= option.
%let _file= /C:/data; filename jobs "&_file./Jobs.xlsx"; proc import out=Jobcount replace datafile = "jobs"; dbms = xlsx; getnames=yes; run;
Why do you have a / in front of C: ?
Your log does not include the %LET statement, so it looks like it was never executed.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.