topic Re: How Do I Cross Tabulate in New SAS User

How Do I Cross Tabulate

Abz_17 — Mon, 17 Oct 2022 10:14:24 GMT

Hi I have a data set which i would like to cross tabulate. My data currently looks like this

aborh day conversion

Unknown 1 219

A+ 1 445

A- 1 137

AB+ 1 30

AB- 1 14

B+ 1 133

B- 1 61

O+ 1 602

O- 1 236

Unknown 2 522

A+ 2 1411

A- 2 426

AB+ 2 78

AB- 2 27

B+ 2 356

B- 2 135

O+ 2 1955

O- 2 863

and I want it to look like this

1 2

Unknown 219 522

A+ 445 1411

A- 137 426

AB+ 30 78

AB- 14 27

B+ 133 356

B- 61 135

O+ 602 1955

O- 236 863

Can someone please advise me as to how to get the cross tab above?

Thanks

Re: How Do I Cross Tabulate

PaigeMiller — Mon, 17 Oct 2022 10:28:56 GMT

PROC FREQ

See the example here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/procstat/procstat_freq_examples01.htm Your problem is essentially the same as the one shown for Eye Color and Hair Color

Re: How Do I Cross Tabulate

PeterClemmensen — Mon, 17 Oct 2022 10:55:31 GMT

Do you want a SAS data set or a report?

Re: How Do I Cross Tabulate

Abz_17 — Mon, 17 Oct 2022 11:00:31 GMT

Wanted to avoid proc freq. Is there a way to do this via proc tabulate?

Re: How Do I Cross Tabulate

Abz_17 — Mon, 17 Oct 2022 11:00:58 GMT

Sas data set

Re: How Do I Cross Tabulate

PeterClemmensen — Mon, 17 Oct 2022 11:10:08 GMT

Is this a summation thing? Seems like a simple transpose?

Re: How Do I Cross Tabulate

PeterClemmensen — Mon, 17 Oct 2022 11:13:49 GMT

data have;
input aborh $ day conversion;
datalines;
Unknown 1 219  
A+      1 445  
A-      1 137  
AB+     1 30   
AB-     1 14   
B+      1 133  
B-      1 61   
O+      1 602  
O-      1 236  
Unknown 2 522  
A+      2 1411 
A-      2 426  
AB+     2 78   
AB-     2 27   
B+      2 356  
B-      2 135  
O+      2 1955 
O-      2 863  
;

proc sort data = have;
   by aborh;
run;

proc transpose data=have out=want(drop=_name_) prefix=_;
    by aborh;
    id day;
    var conversion;
run;

Re: How Do I Cross Tabulate

PaigeMiller — Mon, 17 Oct 2022 11:31:56 GMT

@Abz_17 wrote:

Wanted to avoid proc freq.

Since you didn't give a reason, all I can say is that this is not a good position to take. PROC FREQ gives you exactly what you asked for.

Re: How Do I Cross Tabulate

D_Dunlap — Mon, 17 Oct 2022 14:38:13 GMT

Hello,

If you want a report, you can try PROC TABULATE:

proc tabulate data=work.have format=8.0;
var conversion;
class aborh day ;

/* The TABLE statement defines the structure of your report */
/* TABLE PAGE,ROW,COLUMN; */

TABLE aborh,day={label=""}*conversion={label=""}*Sum={label=""} ;

/* Page Dimension - The above TABLE statement does not have */
/* a PAGE dimension */

/* Row Dimension -BELOW*/
/* aborh*/

/* Column Dimension - BELOW */
/* day={label=""}*conversion={label=""}*Sum={label=""} */

run;

Re: How Do I Cross Tabulate

Reeza — Mon, 17 Oct 2022 14:46:06 GMT

Your requirements are contradictory, if you want a data set proc tabulate is not the right approach, proc transpose is (solution shown by @PeterClemmensen).

Wanted to avoid proc freq. Is there a way to do this via proc tabulate?

Sas data set