hi everyone,
im trying to use a macro variable in a name literal to reference an excel sheet but it is not working for me. i can get the libname statement to work but not the data step. is there anyway to evaluate a macro variable inside the name literal? here is my code and error:
%let prot=132;
libname stabdata "C:\Desktop\p&prot..xlsx";
data p&prot.data; set stabdata.'p&prot.data$'n; run;
libname stabdata clear;
i would like the data step to evaluate as data p132data; set stabdata.'p132data$'n; run; but i get the following error
data p&prot.data; set stabdata.'p&prot.data$'n; run;
ERROR: File STABDATA.'p&prot.data$'n.DATA does not exist.
Macro variables do not expand within single quotes. Convert to using double quotes.
stabdata."p&prot.data$"n;
In your SAS explorer or open the excel sheet, get the sheet name you need. I suspect that you don't have a sheet name called p123data.
Haikuo
Haikuo-
i checked SAS explorer and the excel sheet is listed. I believe the problem is that the macro variable is not being resolved.
if i manually change the stabdata.'p&prot.data$'n to stabdata.'p132data$'n then everything works ok
Macro variables do not expand within single quotes. Convert to using double quotes.
stabdata."p&prot.data$"n;
Excellent!! I didn't know that SAS literals worked with double quotes...I was always under the impression that name, time, date, etc literals needed single quotes.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.