Proc transpose with count

[Gil_]

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

[Gil_]

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 ...

[Reeza]

---

@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

[PGStats · Accepted solution]

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;

[Gil_]

Thanks PGStats