DATA Step, Macro, Functions and more

alternate to TRANSPOSE usign ARRAYs

Reply
SAS Employee
Posts: 73

alternate to TRANSPOSE usign ARRAYs

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
Respected Advisor
Posts: 3,799

Re: alternate to TRANSPOSE usign ARRAYs

Posted in reply to Pavan_SAS
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_;
Respected Advisor
Posts: 4,173

Re: alternate to TRANSPOSE usign ARRAYs

Posted in reply to Pavan_SAS
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#
Ask a Question
Discussion stats
  • 2 replies
  • 133 views
  • 0 likes
  • 3 in conversation