Hi there,
I'm not sure how easy it is to do this but does anyone know how I can create new variables in a Do Loop, where the values being looped through will be part of the variable names.
So say I want to create 10 variables named a1 - a10. I was thinking I could do this in a do loop as below, but not sure how.
Note: I'm using 10 here as an example. In reality I'll swap the 10 with a macro variable.
DATA DESIGN;
SET DESIGN;
DO J = 1 TO 10;
/* Here I want to create the variables a1 - a10 */
END;
RUN;
Many thanks
Emre
May be arrays will help you
DATA DESIGN;
SET DESIGN;
array new(10) a1-a10;
DO J = 1 TO 10;
new(j)=values;
/* Here I want to create the variables a1 - a10 */
END;
RUN;
Thanks,
Jag
May be arrays will help you
DATA DESIGN;
SET DESIGN;
array new(10) a1-a10;
DO J = 1 TO 10;
new(j)=values;
/* Here I want to create the variables a1 - a10 */
END;
RUN;
Thanks,
Jag
You can "create" new variables by just referencing them.
%let nvars=10 ;
You could just give them a length;
length a1 - a&nvars 8 ;
Or you could define an array ;
array a(&nvars) ;
If you want to know how to assign them specific values then you will need to provide more information on what you want.
Thanks guys!
Much appreciated!
Emre
Code in the end:
DATA DESIGN;
SET DESIGN;
RETAIN I(0);
I = I + 1;
ARRAY A(&XVAR) a1 - a&XVAR;
DO J = 1 TO &XVAR;
IF I = J THEN A(J) = 1;
END;
ARRAY NUMS _NUMERIC_;
DO OVER NUMS;
IF NUMS= '.' THEN NUMS = 0;
END;
RUN;
Here is a way to create an identity matrix.
%let xvar=10 ;
%let base=A;
data identity&xvar ;
array &base(&xvar) (&xvar*0) ;
do _n_=1 to &xvar ;
&base(_n_) = 1;
output;
&base(_n_) = 0;
end;
run;
proc print; run;
Hi Tom,
Thanks for the tip.
I'm using PROC FCMP for the identity.
Now I need to create a diagonal from an array in PROC FCMP.
Let's see how that goes.
Thanks
Emre
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.