topic Re: creating a list of values in SAS Programming

creating a list of values

jhh197 — Sat, 22 Sep 2018 18:46:49 GMT

I have couple of macro variables which has values and I want to create a list of those values for each variable into one and the final list should be

%let xp1 = 2;

%let xp2 = 3;

%let xp3 = 1;

%do i=1 %to 3;
   %if &i=1 %then %do;
%let y = &&xp&i._crs;
      %end;
%else %do;
      %let y =%sysfunc(catx(|,&y,&&xp&i._crs));
%end;

%end;

%put &y;

so value of y should be 2|3|1 after the loop is completed

Can anyone please help

Re: creating a list of values

Cynthia_sas — Sat, 22 Sep 2018 19:11:44 GMT

Hi, where does the "_crs" fit -- when you show the value of &Y, you do NOT show the string _crs.

I would expect you to get messages of the form:
WARNING: Apparent symbolic reference XP1_CRS not resolved.
and I would expect you'd see those messages for each of your XP1, XP2 and XP3 macro variables.

What is the purpose of the _crs???

Cynthia

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 19:12:50 GMT


%let xp1 =2;

%let xp2 =3;

%let xp3 =1;


%macro l;
%let list=%str();
%do i=1 %to 3;
%put &&xp&i;
%let list=&list|&&xp&i;
%end;
%mend l;
%l

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 19:15:54 GMT

And i am baffled why this is troubling me



%let xp1 =2;

%let xp2 =3;

%let xp3 =1;
/*works fine*/
%let list=%sysfunc(catx(|,&xp1,&xp2,&xp3));

%put &list;
/*does not work*/
%macro l;
%let list=%str();
%do i=1 %to 3;
%put &&xp&i;
%let list=%sysfunc(catx(|,&list,&&xp&i));
%end;
%mend l;
%l
%put &list;

Re: creating a list of values

jhh197 — Sat, 22 Sep 2018 19:19:05 GMT

oh the % let statements should be like below

%let xp1_crs = 2;

%let xp2_crs = 3;

%let xp3_crs = 1;

Re: creating a list of values

jhh197 — Sat, 22 Sep 2018 19:26:22 GMT

Yes . the first code would work and can be used when we have three variables . But I wanted to do this in a do loop since I don't want to mention &x1 , &x2 , &x3 as I have 250 variables from x1 to x250

Thank you

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 19:46:00 GMT

did you try the previous post of mine

here again

%let xp1 =2;

%let xp2 =3;

%let xp3 =1;


%macro l;
%let list=%str();
%do i=1 %to 3;
%put &&xp&i;
%let list=&list|&&xp&i;
%end;
%mend l;
%l

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 19:51:34 GMT

that works for your many variables as the below test confirms


%macro c;
%do i=1 %to 250;
%let xp&i=&i;
%end;
%let list=%str();
%do i=1 %to 250;
%put &&xp&i;
%let list=&list|&&xp&i;
%end;
%mend c;
%c

%put &list;

Re: creating a list of values

Cynthia_sas — Sat, 22 Sep 2018 19:59:36 GMT

Hi:
I'm confused. Are you trying to use a MACRO %DO loop to concatenate 250 -macro- variables or 250 dataset variables???

Cynthia

Re: creating a list of values

jhh197 — Sat, 22 Sep 2018 20:10:24 GMT

xp1_crs , xp2_crs and xp3_crs are already getting resolved in the macro and now I am using these values to prepare a list

like 2|3|1 so the values 2 is the value of xp1_crs and value 3 is the value of macro variable xp2_crs and the value of 1 is the value of xp3_crs

i am trying to concatenate macro variable values

Thank you

Re: creating a list of values

jhh197 — Sat, 22 Sep 2018 20:16:45 GMT

I have tried this but I am getting like below it started with a pipe

|2|3|1

thought it should be like this

2|3|1

Thank you

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 20:17:57 GMT

i assumed you would have done this simple adjustment

%put %substr(&list,2);

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 21:05:10 GMT

or you could even try extracting from macro dictionary


%let xp1 =2;

%let xp2 =3;

%let xp3 =1;
/*filter macro dictionary if name=:'XP'*/

data _null_;
do until(l);
set sashelp.vmacro(keep=name) end=l;
length temp $20;
if name=:'XP' then temp=catx('|',temp,cats('&',name));
if l then call symputx('list',temp);
end;
run;

%put list=&list;

LOG:

978
979 %put list=&list;
list=2|3|1

Re: creating a list of values

Astounding — Sat, 22 Sep 2018 21:17:50 GMT

A simple change gets rid of the extra pipe:

%macro c;
%global list;
%local i;
%let list = &xp1;
%do i=2 %to 250;
%let list=&list|&&xp&i;
%end;
%mend c;
%c

%put &list;

Re: creating a list of values

novinosrin — Sat, 22 Sep 2018 21:29:03 GMT

wouldn't that miss xp1 value?

Edit: Sorry let me run and understand. My apologies

Re: creating a list of values

Astounding — Sat, 22 Sep 2018 21:29:20 GMT

I hate this editor.

No, the XP1 value is captured by the first %LET statement.

Re: creating a list of values

Cynthia_sas — Sat, 22 Sep 2018 22:11:23 GMT

But, did you originally create the macro variable values from data that was in a dataset?

Re: creating a list of values

jhh197 — Sun, 23 Sep 2018 01:14:08 GMT

Hi Cynthia ,

Yes I have created it

Thank you

Re: creating a list of values

jhh197 — Sun, 23 Sep 2018 01:38:52 GMT

I am so confused why below code doesn't work and y doesn't resolve to 2|3|1

%let xp1 = 2;

%let xp2 = 3;

%let xp3 = 1;

%do i=1 %to 3;
   %if &i=1 %then %do;
%let y = &&xp&i._crs;
      %end;
%else %do;
      %let y =%sysfunc(catx(|,&y,&&xp&i._crs));
%end;

%end;

%put &y;

Re: creating a list of values

Reeza — Sun, 23 Sep 2018 02:02:53 GMT

What Cynthia is trying to mention, is that this would drastically easier in a data set. In fact it's trivial.

XP = catx('|', of xp1-xp250);