topic Re: Variable values into variable names in SAS Programming

Variable values into variable names

TobbeArbMed — Tue, 15 May 2018 06:21:44 GMT

I have the following data:

lopnr Syss1995 Syss1996 Syss1997 Syss1998 Syss1999 Syss2000 invar

1 1 5 6 1 5 1 1996

2 3 1 6 5 1 6 1999

3 1 6 1 5 6 1 1995

and so on...

I want a new variable with following values

Syssinvar

and so on...

Thus I need to get the value from the right Syss-variables with the same year as in the invar variable

My guessing is that I need to use symputx in some way, but I don't get it right.

Re: Variable values into variable names

FredrikE — Tue, 15 May 2018 06:37:37 GMT

Hi!

VValueX will do it 🙂

data have;
 length lopnr syss1995 syss1996 syss1997 invar 8;
 input  lopnr syss1995 syss1996 syss1997 invar;
 datalines;
 1 1 5 6 1997
 2 3 1 6 1995
 3 1 6 1 1996
 ;
run;

data want;
 set have;
 length syssinvar 8;
 syssinvar = vvaluex(cats('syss',put(invar,best.)));
run;

Re: Variable values into variable names

TobbeArbMed — Tue, 15 May 2018 06:51:02 GMT

Great! Thank you!

Re: Variable values into variable names

Tom — Tue, 15 May 2018 12:54:18 GMT

Looks like an array problem.

data want ;
  set have ;
  array s syss1995-syss2000 ;
  sysinvar = s(invar - 1995 +1);
run;

Re: Variable values into variable names

TobbeArbMed — Wed, 16 May 2018 06:39:10 GMT

Works perfect!