Transposing vars using array function

deleted_user — Fri, 01 Feb 2008 19:04:11 GMT

Hi folks!

I´m trying to perform a division using an array.
The information I have are in columns and I wanna change then to line at same divide them.

Example raw file:

Date - Var1 - Var2 - obs
Jan/06 - 200 - 1000 - 1
Jan/06 - 300 - 1000 - 2
Jan/06 - 400 - 1000 - 3
Jan/06 - 500 - 1000 - 4

after process the desirable result (Var1 / Var2) follow as show bellow

jan/06 - 0.2 - 0.3 - 0.4 - 0.5

Thanks Message was edited by: Carlos

Re: Transposing vars using array function

advoss — Tue, 05 Feb 2008 15:32:37 GMT

Try something like:
Data Step2;
set step1;
result = var1/var2;
run;
proc transpose data=step2 out=step3(drop=_:) prefix=Result;
by date;
var result;
id obs;
run;
proc print data=step3;
run;

topic Re: Transposing vars using array function in Mathematical Optimization, Discrete-Event Simulation, and OR

Transposing vars using array function

Re: Transposing vars using array function