topic Re: Scan macro variable list with names like "this is the first variable"n in SAS Programming

Scan macro variable list with names like "this is the first variable"n

alejandrogrrl — Mon, 13 Jul 2020 19:09:26 GMT

I want to run the following code. My problem is that I dont know how to put the delimiter in the scan function so that it identifies the three variables inside vars. I've tried multiple times without success (I just put "?" inside the code because that is were my question lies). I hope you can help me. Thanks in advance.

%let vars="TIIE 28 días (%)"n "TIIE 91 días (%)"n "Cetes 28 días (%)"n;

%macro serie;

%do i=1 %to 3;

%let parameter=%scan(&vars.,&i.,"?");

proc sgplot data=base;

series x=date y=&parameter./ markers;

run;

%end;

%mend;

Re: Scan macro variable list with names like "this is the first variable"n

Tom — Mon, 13 Jul 2020 19:14:36 GMT

Use the Q modifier on the %SCAN() call.

128  %let vars="TIIE 28 días (%)"n "TIIE 91 días (%)"n "Cetes 28 días (%)"n;
129  %put %scan(&vars,1,%str( ),q);
"TIIE 28 días (%)"n
130  %put %scan(&vars,2,%str( ),q);
"TIIE 91 días (%)"n
131  %put %scan(&vars,3,%str( ),q);
"Cetes 28 días (%)"n

Re: Scan macro variable list with names like "this is the first variable"n

ballardw — Mon, 13 Jul 2020 19:21:20 GMT

Since your values have default delimiters like spaces then you need to construct the variable list with a known character like a pipe character | or some other character that you will absolutely never ever use in a variable name.

%let vars="TIIE 28 días (%)"n|"TIIE 91 días (%)"n|"Cetes 28 días (%)"n;

%let v1 = %scan(&vars,1,|);
%let v2 = %scan(&vars,2,|);
%let v3 = %scan(&vars,3,|);

%put &v1.;
%put &v2.;
%put &v3.;

Please note that since the macro language uses % for functions and such you may have other issues further on. Also, inclusion of characters like comma or & in your variable names is extremely likely to be problematic.

In the long run you would be much better off using standard variable names and use a variable LABEL to provide "nicer" text for output.

Re: Scan macro variable list with names like "this is the first variable"n

alejandrogrrl — Mon, 13 Jul 2020 19:24:48 GMT

Thanks a lot! This is exactly what I needed. I'm really really grateful.

Re: Scan macro variable list with names like "this is the first variable"n

alejandrogrrl — Mon, 13 Jul 2020 19:29:57 GMT

Thanks for the solution.

I know using commas and symbols in variable names is extremely uncovenient. However, since these variables are from a public source (my central bank) I was asked not to change the names of the variables.

Thanks again for the solution and for the tips!

Re: Scan macro variable list with names like "this is the first variable"n

Kurt_Bremser — Mon, 13 Jul 2020 20:49:47 GMT

@alejandrogrrl wrote:

I was asked not to change the names of the variables.

You will curse the day on which you accepted this stupidity.