topic Re: base sas in SAS Programming

base sas

shivamarrora0 — Thu, 20 Jul 2017 10:30:30 GMT

Hi all i have data in vertical format i want it in horizontal format without using proc transpose with simple approch

Re: base sas

WarrenKuhfeld — Thu, 20 Jul 2017 11:02:38 GMT

Why not proc transpose? It is the right tool for the job. You could easily use a data step that will be something like this. If you provided the data in a form I could copy, I could test the code, but since you didn't I'll leave it to you to fill in the details

data;

set;

by notsorted cust;

retain checking mortage saving credit_card;

if account = 'checking' then checking = balance;

... three more obvious if then assignments to make the other variables ...

if last.cust then output;

drop account balance;

run;

There are other ways, of course, to do this.

Re: base sas

Kurt_Bremser — Thu, 20 Jul 2017 11:04:42 GMT

You do that with proc transpose, period. Use the right tool for the task.

Anything else would involve a lot of meta-programming to make it flexible vis the values in account, and therefore be stupid.

Re: base sas

shivamarrora0 — Thu, 20 Jul 2017 11:36:18 GMT

I agree with you, but this is my institute question , that is why i posted .

Re: base sas

Kurt_Bremser — Thu, 20 Jul 2017 11:42:16 GMT

You already got a blueprint from @WarrenKuhfeld, adapt it to your needs, but you will have to expand that code everytime a new value in account appears.