Help using Base SAS procedures

Proc transpose?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Proc transpose?


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.


Accepted Solutions
Solution
‎10-15-2014 03:45 PM
Regular Contributor
Posts: 180

Re: Proc transpose?

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;

View solution in original post


All Replies
Solution
‎10-15-2014 03:45 PM
Regular Contributor
Posts: 180

Re: Proc transpose?

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;

Super User
Posts: 10,497

Re: Proc transpose?

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 225 views
  • 0 likes
  • 3 in conversation