topic Re: how to slove if dataset name have special character in SAS Programming

how to slove if dataset name have special character

thanikondharish — Mon, 13 Aug 2018 03:16:12 GMT

libname ex excel 'E:\sas\dime\xls\data3.xls' ;
data s;
set ex."Sheet1$"n;
run;

proc print data=ex.'sheet1$'n;
run;

the above program doesn't work .

how to solve?

Haikuo — Mon, 13 Aug 2018 03:28:44 GMT

put this line at the beginning of your code:

options validmemname=extend;

thanikondharish — Mon, 13 Aug 2018 03:30:22 GMT

Thanq

Reeza — Mon, 13 Aug 2018 15:27:06 GMT

@thanikondharish if the answer works please mark @Haikuo solution as the correct answer.