topic Proc transpose? in SAS Procedures

Proc transpose?

abrunton — Wed, 15 Oct 2014 19:37:44 GMT

Hello.

Does anyone have any suggestions on how to manipulate my dataset from this:

Site Total Zip

ABC 2 85004

DEF 4 85003

GHI 5 85002

To this:

Site Zip

ABC 85004

DEF 85003

GHI 85002

Thank you.

Re: Proc transpose?

CTorres — Wed, 15 Oct 2014 19:45:06 GMT

data have;

input Site $ Total Zip;

cards;

ABC 2 85004

DEF 4 85003

GHI 5 85002

;

run;

data want(drop=i total);

set have;

do i=1 to total;

output;

end;

run;

Re: Proc transpose?

ballardw — Wed, 15 Oct 2014 19:53:20 GMT

Without knowing HOW you will use the result you might be interested to know that many of the analysis procedures could use the value of TOTAL as a FREQ variable and give appropriate results without creating additional records.