DATA Step, Macro, Functions and more

Proc transpose with count

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 78
Accepted Solution

Proc transpose with count

I have a data pull that looks

Date. Id. Issue
01/01/16. A1. Code A
01/02/16. B3. Code A
01/03/16. D2. Code D.
01/05/16. W3. Code T

I'm looking for telling proc transpose look like this

Code A. Code D Code T
O1/01/16. A1. 1
01/02/16. B3. 1
01/03/16. D2. 1
01/05/16. W3. 1

Accepted Solutions
Solution
‎12-06-2016 04:05 PM
Respected Advisor
Posts: 4,919

Re: Proc transpose with count

Proc tabulate or proc report will create this kind of report table :

 

data have;
input Date :ddmmyy. Id $ Issue $&;
format date yymmdd10.;
datalines;
01/01/16 A1 Code A
01/02/16 B3 Code A
01/03/16 D2 Code D
01/05/16 W3 Code T
;

proc tabulate data=have format=7.0;
class date id issue;
table date*id,Issue=""*n="";
run;

PG

View solution in original post


All Replies
Frequent Contributor
Posts: 78

Re: Proc transpose with count

Sorry it didn't save like i wanted to show i need issue to be on top like a pivot table with the count of occurrence. With id and date on left side going up and down ...
Super User
Posts: 19,768

Re: Proc transpose with count


Gil_ wrote:
Sorry it didn't save like i wanted to show i need issue to be on top like a pivot table with the count of occurrence. With id and date on left side going up and down ...

Yeah, I'm not seeing what you want. 

 

If you want a pivot table type report look at proc tabulate. If you want a dataset with indicators (?) look at creating indicator variables.

http://blogs.sas.com/content/iml/2016/02/22/create-dummy-variables-in-sas.html

Solution
‎12-06-2016 04:05 PM
Respected Advisor
Posts: 4,919

Re: Proc transpose with count

Proc tabulate or proc report will create this kind of report table :

 

data have;
input Date :ddmmyy. Id $ Issue $&;
format date yymmdd10.;
datalines;
01/01/16 A1 Code A
01/02/16 B3 Code A
01/03/16 D2 Code D
01/05/16 W3 Code T
;

proc tabulate data=have format=7.0;
class date id issue;
table date*id,Issue=""*n="";
run;

PG
Frequent Contributor
Posts: 78

Re: Proc transpose with count

Thanks PGStats
☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 316 views
  • 1 like
  • 3 in conversation