topic Pass file path in folder to bring in contents on excel file in SAS Programming

Pass file path in folder to bring in contents on excel file

Citrine10 — Tue, 01 Feb 2022 10:02:07 GMT

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;

Re: Pass file path in folder to bring in contents on excel file

LinusH — Tue, 01 Feb 2022 10:23:27 GMT

Why do you have a / in front of C: ?

Re: Pass file path in folder to bring in contents on excel file

Citrine10 — Tue, 01 Feb 2022 11:02:25 GMT

Removed it but get the same erro

Re: Pass file path in folder to bring in contents on excel file

Kurt_Bremser — Tue, 01 Feb 2022 11:05:20 GMT

Your log does not include the %LET statement, so it looks like it was never executed.

Re: Pass file path in folder to bring in contents on excel file

Ksharp — Wed, 02 Feb 2022 08:46:44 GMT

Excel does not support SVG image file I guess. Try other format of image file.