topic Re: alternate to TRANSPOSE usign ARRAYs in SAS Programming

alternate to TRANSPOSE usign ARRAYs

Pavan_SAS — Tue, 11 May 2010 06:29:42 GMT

Should achieve this without using proc transpose (using arrays only)

data source;

input sno name $ s1 s2 s3 s4;

cards;

1 A 120 114 230 500

2 B 140 130 250 600

3 C 110 115 260 700

4 D 110 115 260 700

;

run;

OUTPUT dataset:

A B C D

120 140 110 110

114 130 115 115

230 250 260 260

500 600 700 700

Re: alternate to TRANSPOSE usign ARRAYs

data_null__ — Tue, 11 May 2010 11:34:16 GMT

Why? Is this home work?

Why would you want to use Arrays when PROC TRANSPOSE is so perfectly suited?

[pre]
proc transpose;
id name;
var s1-s4;
run;
[/pre] Message was edited by: data _null_;

Re: alternate to TRANSPOSE usign ARRAYs

Patrick — Tue, 11 May 2010 12:20:05 GMT

Answer given here (in principal the same what data _null_ told you):
http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/fbc8b03b447ca319#