topic Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist in SAS Programming

ERROR: Unable to import, file c:\&expfile.XLS does not exist

LeeJenson — Wed, 03 Feb 2010 20:42:17 GMT

Hi,

I am trying to collect a file name from a field but the variable does
not seem to get translated. My source dataset only has one record in
so should pick it up ok.

proc sql;
select name into :expfile
from exportfilec;
quit;

proc import datafile = 'c:\&expfile.' out=work.fields_tmp1;
run;

99 proc import datafile = 'c:\&expfile.' out=work.fields_tmp1;
100 run;

ERROR: Unable to import, file c:\&expfile.XLS does not exist

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

Tim_SAS — Wed, 03 Feb 2010 21:00:37 GMT

Macro variables aren't expanded when they're within apostrophes. Use quotes instead:

[pre]
proc import datafile = "c:\&expfile." out=work.fields_tmp1;
[/pre]

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

LeeJenson — Wed, 03 Feb 2010 21:22:13 GMT

Thank you 🙂

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

LeeJenson — Thu, 04 Feb 2010 10:14:24 GMT

Tim,

If I replace the single quote with double quotes I get this error...

235 proc import datafile = "C:\&expfile." out=work.fields_tmp1;
ERROR: Unable to determine datasource type. Please use the DBMS= option.

What is the best method to output the content of a variable to the log just to see what's in it?

Lee

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

LinusH — Thu, 04 Feb 2010 12:03:46 GMT

options symbolgen; would help you.
/Linus

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

sbb — Thu, 04 Feb 2010 12:43:49 GMT

Suggest you use the options statement below:

OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MPRINT;

...and sometimes...

OPTIONS MLOGIC;

Scott Barry
SBBWorks, Inc.

Re: ERROR: Unable to import, file c:\&expfile.XLS does not exist

LeeJenson — Thu, 04 Feb 2010 17:18:15 GMT

Hi

These options allowed me to troubleshoot the problem and it was because I was not specifying DBMS=CSV.

Thanks again
:-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-)
Lee