topic Re: Data set import: File name has space in SAS Programming

Data set import: File name has space

jerrylshen — Thu, 15 Aug 2019 17:14:26 GMT

libname pre "C:folder name";

%let ds1="File Name Has Space(s)";  
/*File is .xlsx */

data old;
	set pre.&ds1.; 
        /*Error here with the file name */
run;

I did a quick google search, I saw several that mentions Pipe, which I assume it doesn't really apply to me.

Thanks

EDIT: turns out its a .CSV file.

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n02nz0e7cykqhun14hcppfmd0558.htm

this helped.

Re: Data set import: File name has space

PeterClemmensen — Thu, 15 Aug 2019 15:57:36 GMT

If your file is .xlsx then the data step is not the way to go. Use PROC IMPORT instead. Do a Google search, thousands of examples out there 🙂

Re: Data set import: File name has space

Reeza — Thu, 15 Aug 2019 16:01:31 GMT

Spaces in file names are not issues in SAS.

Your code is wrong (syntax is incorrect), which is the issue. Make sure it first works without macro variables and then add macro variables.

Re: Data set import: File name has space

Tom — Thu, 15 Aug 2019 17:02:15 GMT

@jerrylshen wrote:
libname pre "C:folder name";

%let ds1="File Name Has Space(s)";  
/*File is .xlsx */

data old;
	set pre.&ds1.; 
        /*Error here with the file name */
run;
I did a quick google search, I saw several that mentions Pipe, which I assume it doesn't really apply to me.

Thanks

Is the file a SAS dataset, like your last step is assuming. Or is it an XLSX file, like your comment says?

To use a dataset name that includes a space (why would you want to?) you need to set the VALIDMEMNAME option to extend and use a name literal.

options validmemname=extend ;
proc print data=pre."name with space"n ;
run;

To read from an XLSX file you can use PROC IMPORT or the XLSX libname engine.

libname pre xlsx 'name of the xlsx file';