topic Re: using a macro variable in a name literal in SAS Programming

using a macro variable in a name literal

spirto — Mon, 05 Aug 2013 20:17:02 GMT

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.

Re: using a macro variable in a name literal

Haikuo — Mon, 05 Aug 2013 20:24:08 GMT

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

Re: using a macro variable in a name literal

spirto — Mon, 05 Aug 2013 20:45:30 GMT

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

Re: using a macro variable in a name literal

Tom — Mon, 05 Aug 2013 21:00:45 GMT

Macro variables do not expand within single quotes. Convert to using double quotes.

stabdata."p&prot.data$"n;

Re: using a macro variable in a name literal

spirto — Mon, 05 Aug 2013 21:26:13 GMT

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.