topic Re: Proc transpose with count in SAS Programming

Proc transpose with count

Gil_ — Thu, 01 Dec 2016 02:43:35 GMT

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

Re: Proc transpose with count

Gil_ — Thu, 01 Dec 2016 02:48:35 GMT

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

Re: Proc transpose with count

Reeza — Thu, 01 Dec 2016 03:30:46 GMT

@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

Re: Proc transpose with count

PGStats — Thu, 01 Dec 2016 05:00:17 GMT

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;

Re: Proc transpose with count

Gil_ — Tue, 06 Dec 2016 21:06:37 GMT

Thanks PGStats