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

[Citrine10]

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;

[LinusH]

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

[Citrine10]

Removed it but get the same erro

[Kurt_Bremser]

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

[Ksharp]

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