topic Re: Using an array to string out variables in SAS Programming

Using an array to string out variables

ChuksManuel — Tue, 06 Jul 2021 01:11:18 GMT

Hi guys,

I'm trying to use an array to string out variables in my dataset and create a manuscript table.

Can any help me review this code? I want the stringed variable to appear in the order as in the array. The code was not running well.

proc format;
value danfm
1= 'age'
2= 'gender'
3= 'obesity'
4= 'hlth'
5= 'smoke1'
6= 'smoke2'
7= 'smoke3'
;
data me; set you;
array her age gender obesity hlth smoke1 smoke2 smoke3;
do over her;
tc=_I_;
tn= put (tc,danfm.);
value=her;
output; end;
data me1; set me; if value ne .; run;

Re: Using an array to string out variables

SASKiwi — Tue, 06 Jul 2021 02:47:32 GMT

Reading the documentation on the ARRAY statement will help you get the syntax right.

I've no idea what you are trying to do in your program and you don't provide any data to test but this is the correct syntax:

array her (*) age gender obesity hlth smoke1 smoke2 smoke3;

Re: Using an array to string out variables

andreas_lds — Tue, 06 Jul 2021 05:35:12 GMT

@SASKiwi wrote:

Reading the documentation on the ARRAY statement will help you get the syntax right.

I've no idea what you are trying to do in your program and you don't provide any data to test but this is the correct syntax:
array her (*) age gender obesity hlth smoke1 smoke2 smoke3;

@ChuksManuel: The array statement will be of use only, if all variable have the same type. I doubt that "age" is alphanumeric

Re: Using an array to string out variables

Patrick — Tue, 06 Jul 2021 06:40:59 GMT

Here some code addressing what I'm guessing you're asking for.

data have;
  array her {*} 8 age gender obesity hlth smoke1 smoke2 smoke3 (6*1);
  output;
  smoke2=.;
  smoke3=99;
  output;
  stop;
run;

proc format;
  value danfm
    1= 'age'
    2= 'gender'
    3= 'obesity'
    4= 'hlth'
    5= 'smoke1'
    6= 'smoke2'
    7= 'smoke3'
  ;

data me;
  set have;
  array her {*} age gender obesity hlth smoke1 smoke2 smoke3;

  do tc=1 to dim(her);
    tn= put (tc,danfm.);
    value=her[tc];
    if not missing(value) then output;
  end;
  drop age gender obesity hlth smoke1 smoke2 smoke3;
run;

Re: Using an array to string out variables

ChuksManuel — Tue, 06 Jul 2021 07:12:39 GMT

Thank you. That's exactly what i wanted to do