Solved: Re: create variable values from array variables

SAS_inquisitive · Posted 03-03-2017 11:51 AM

data want;
  array a_{*} a b c d;
  do i = 1 to dim(a_);
  	name = "a_{i}";
	output;
   end;
run;

data want;

name

a

b

c

d

mkeintz · Posted 03-03-2017 11:57 AM

Instead of

name="a_{I}";

try

name=vname(a_{I});

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

mkeintz · Posted 03-03-2017 11:57 AM

Instead of

name="a_{I}";

try

name=vname(a_{I});

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

SAS_inquisitive · Posted 03-03-2017 01:38 PM

Thank you, mkeintz.

create variable values from array variables