topic Re: How to create a sas dataset using excel table name with space in SAS Programming

How to create a sas dataset using excel table name with space

jayakumarmm — Sun, 04 Sep 2016 14:53:21 GMT

I need to create a SAS dataset using excel table name with space. I have tried below which is not working.

libname xlsFile XLSX "/user/path/file.xlsm";
options validvarname=v7;


PROC SQL;
    create table work.excel_table as 
	(select * from xlsFile.'first Sheet$'n);
 quit;

Re: How to create a sas dataset using excel table name with space

Haikuo — Sun, 04 Sep 2016 16:32:11 GMT

options validvarname=any;

Re: How to create a sas dataset using excel table name with space

jayakumarmm — Sun, 04 Sep 2016 17:12:18 GMT

I am still getting error.i.e. not to identify the Sheet name due to space issue.

My actual issue with Excel sheet name with space.

Re: How to create a sas dataset using excel table name with space

Haikuo — Sun, 04 Sep 2016 17:28:12 GMT

log please?

Re: How to create a sas dataset using excel table name with space

Reeza — Sun, 04 Sep 2016 17:34:24 GMT

Using the N literal notation is the correct method. 'Sheet Name$'n

As mentions post your log. Note that it is case sensitive so needs to match Excel exactly.

Please post a pic of library with sheet names as well.

Re: How to create a sas dataset using excel table name with space

Reeza — Sun, 04 Sep 2016 17:34:24 GMT

Using the N literal notation is the correct method. 'Sheet Name$'n

As mentions post your log. Note that it is case sensitive so needs to match Excel exactly.

Please post a pic of library with sheet names as well.

Re: How to create a sas dataset using excel table name with space

jayakumarmm — Sun, 04 Sep 2016 17:35:21 GMT

Thank you so much for helping me. I have fixed this issue by adding single quotes to my sheet name. .i.e. 'first sheet'n