Proc transpose?

[abrunton]

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

ABC          85004

DEF          85003

DEF          85003

DEF          85003

DEF          85003

GHI           85002

GHI           85002

GHI          85002

GHI          85002

GHI          85002

Thank you.

[CTorres · Accepted solution]

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;

[ballardw]

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.