topic Re: use variable with variable value in ODS and Base Reporting

use variable with variable value

deleted_user — Fri, 02 Feb 2007 08:16:26 GMT

Hi,

I've got a dataset with variables var1 to var4.
And I want do normalize them.

I've tried this code:

data test;
set tst;

do i=1 to 4;
output_var1 = var+i;
output;
end;
run;

But it doesn't work...
Can anyone help me?

Re: use variable with variable value

Olivier — Mon, 05 Feb 2007 07:55:18 GMT

What do you exactly mean by "normalizing" ? Can we have a sample with data of what you have as an input, and what you want to create ?

Re: use variable with variable value

deleted_user — Mon, 05 Feb 2007 09:40:39 GMT

Source:
var1 var2 var3
one 1 11
two 2 12
three 3 13

The output should be:
var1 var
one 1
one 11
two 2
two 12
three 3
three 13

Re: use variable with variable value

Olivier — Mon, 05 Feb 2007 10:05:32 GMT

DATA newlyCreated ;
SET existing ;
ARRAY values
var2 var3 /* here you can list all the variables that contain values */ ;
DO OVER values ;
var = values ;
OUTPUT ;
END ;
RUN ;

Re: use variable with variable value

deleted_user — Mon, 05 Feb 2007 10:14:44 GMT

Oliver,

Thanks a lot!
That's exactly what I'm looking for!!