topic Re: macro variable in a DATA Step in SAS Programming

macro variable in a DATA Step

yus03590 — Mon, 11 Jun 2018 22:58:58 GMT

Hi!  Been a long time since I've used sas.  I apologize if there is a simple solution I am missing.

I'm trying to use macro variables in the set statement of a data step in the following manner:

%let source = "T4_R283";
%let sink = "T3_R230";

data solution_distance_data_single;
set "solution_&source._to_&sink."
source = &source;
sink = &sink;
/*distance = sum(edge);*/
/*drop i, j, flow, edge; */
run;

I'm trying to get the set name to be "solution_T4_R283_to_T3_R230" but I get the following error lines in the log:

254 set "solution_&source._to_&sink."
NOTE: Line generated by the macro variable "SINK".
254 "solution_"T4_R283"_to_"T3_R230"
____________
22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS,
NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 76-322: Syntax error, statement will be ignored.

I use periods to delineate the macro variables from the string, what else do I need to do?

Thanks!

Re: macro variable in a DATA Step

Reeza — Mon, 11 Jun 2018 23:01:08 GMT

Are you using named literals?
Is there a specific reason you have the data set name in quotes, it usually isn't unless you're using name literals which would need an N at the end.

Can you show working code - without any macros? Then it's much easier to convert it to a macro.

@yus03590 wrote:
Hi!  Been a long time since I've used sas.  I apologize if there is a simple solution I am missing.

I'm trying to use macro variables in the set statement of a data step in the following manner:

%let source = "T4_R283";
%let sink = "T3_R230";

data solution_distance_data_single;
set "solution_&source._to_&sink."
source = &source;
sink = &sink;
/*distance = sum(edge);*/
/*drop i, j, flow, edge; */
run;
I'm trying to get the set name to be "solution_T4_R283_to_T3_R230" but I get the following error lines in the log:

254 set "solution_&source._to_&sink."
NOTE: Line generated by the macro variable "SINK".
254 "solution_"T4_R283"_to_"T3_R230"
____________
22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS,
NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 76-322: Syntax error, statement will be ignored.

I use periods to delineate the macro variables from the string, what else do I need to do?

Thanks!

Re: macro variable in a DATA Step

Kurt_Bremser — Mon, 11 Jun 2018 23:01:48 GMT

Don't use quotes in the %let.

Re: macro variable in a DATA Step

novinosrin — Mon, 11 Jun 2018 23:04:18 GMT


%let sink = T3_R230;

data solution_distance_data_single;
set solution_&source._to_&sink.;
source = &source;
sink = "&sink";
/*distance = sum(edge);*/
/*drop i, j, flow, edge; */
run;

Re: macro variable in a DATA Step

ruchi11dec — Tue, 12 Jun 2018 06:33:44 GMT

when we use quotes for macro it resolves with the quotes i.e.

%let a = "sas";

%put &=a;

a="sas"

Hope I made it clear