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

[jayakumarmm]

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;

[Haikuo]

options validvarname=any;

[jayakumarmm]

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. 

[Haikuo]

log please?

[jayakumarmm]

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

[Reeza]

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. 

[Reeza · Accepted solution]

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.