topic Re: Proc Tabulate/Report in SAS Procedures

Proc Tabulate/Report

GPatel — Tue, 14 Aug 2012 23:44:29 GMT

Help with Proc Tabulate/Report formatting output.

Data one;
input reason : $ year $ cas pct ;
cards;
XYZ 2010 68 51.9084
Others 2010 63 48.0916
XYZ 2011 169 62.3616
Others 2011 102 37.63
XYZ 2012 88 56.0510
Others 2012 69 43.9494
;
run;

How one create table like shown below with grid lines and exact column name either with proc report or proc tabulate?

                                2010       2011        2012
                               --------------------------------
XYZ_Cnt                68        169            88
XYZ_Pct                51.9       62.4         56.0
Others_Cnt            63         102           69
Others_PCt           48.0       37.6         43.9

My code shown below generates the output shown below, however, I would like to retain column name as shown above.

Proc tabulate data=one order=data ;

Class reason year;

classlev reason /style=<parent>[foreground=black];

Var cas pct;

table reason=' '*(cas='Xyz Count'*f=comma5. pct='Other Pct'*f=8.1), year=' ' / row=float;

Key Label sum=' ' ;

run;

Output from above code:

XYZ	Xyz Count	68	169	88
XYZ	Other Pct	51.9	62.4	56.1
Others	Xyz Count	63	102	69
Others	Other Pct	48.1	37.6	43.9

Re: Proc Tabulate/Report

Ksharp — Wed, 15 Aug 2012 03:10:25 GMT

I think you should firstly change the data structure . after that it would be easy.

Data one;
input reason : $ year $ cas pct ;
cards;
XYZ 2010 68 51.9084
Others 2010 63 48.0916
XYZ 2011 169 62.3616
Others 2011 102 37.63
XYZ 2012 88 56.0510
Others 2012 69 43.9494
;
run;
data two;
 set one;
 length rea $ 50;
 rea=catx('_',reason,'cas');value=cas;output;
 rea=catx('_',reason,'pct');value=pct;output;
 keep rea year value;
run;
proc tabulate data=two order=data;
class rea year;
var value;
table rea=' ' , year=' '*value=' '*sum=' ' ;
run;

Ksharp

Re: Proc Tabulate/Report

Cynthia_sas — Wed, 15 Aug 2012 04:35:40 GMT

Hi:

You say you want gridlines and you are using some ODS style= overrides in your syntax, but I do not see any ODS statements in your posted code. What is your destination of interest? HTML, RTF, PDF, SASReport (inside Enterprise Guide), CSV or ????

That would be good information to know.

cynthia

Re: Proc Tabulate/Report

LHV — Wed, 15 Aug 2012 10:22:24 GMT

Hi,

I got it worked somehow , but not sure....let me know your openion plz.

data one;

input reason : $ year $ cas pct;

cards;

XYZ 2010 68 51.9084

Others 2010 63 48.0916

XYZ 2011 169 62.3616

Others 2011 102 37.63

XYZ 2012 88 56.0510

Others 2012 69 43.9494

;

run;

data two;

set one;

rea=catx('_',reason,'cas');value=cas;output;

rea=catx('_',reason,'pct');value=pct;output;

keep rea year value;

run;

proc sort data=two;

by rea year;

run;

proc tanspose data=two out=three(drop=_Name_);

id year;

by rea;

var value;

run;

result:

Thanks,

Re: Proc Tabulate/Report

GPatel — Wed, 15 Aug 2012 13:06:37 GMT

Dear Cynthia, Ksharp, and LHV

Your prompt and proposed soultion worked great. Appreciate your time and interest. I will use ODS style statements to display grids.

Regards,

Girish Patel