topic Re: Regading Proc Tabulate in SAS Procedures

Regading Proc Tabulate

anilgvdbm — Tue, 23 Sep 2014 05:19:28 GMT

Dear Friends,

Here i need results like village wise and year wise total and percentage. but i am trying with the below code but it not works. Please help me in this.

proc tabulate data=paper.Role_gender_in_;

class Village year Activity_Name men Women both;

tables (Village * year * Activity_Name), Women (n colpctn) /printmiss misstext=' ' ;

format Women AWM_.;

run; bula

Re: Regading Proc Tabulate

RW9 — Tue, 23 Sep 2014 09:22:14 GMT

Hi,

TBH I don't use proc tabulate, so maybe someone who does can help you there. For this type of thing I would just go directly to an output dataset of (and note you have not provided test data or required output so guessing):

proc sql;

create table WANT as

select AGE,

SEX,

COUNT(SEX) as TOT,

(COUNT(SEX) / (select COUNT(*) from SASHELP.CLASS)) * 100 as PCENT

from SASHELP.CLASS

group by AGE,

SEX;

quit;

Then use proc report to generate some nice output.

Re: Regading Proc Tabulate

Cynthia_sas — Tue, 23 Sep 2014 13:36:13 GMT

Hi, your TABULATE statement is missing a table operator. So, this specification: Women(n colpctn) is incorrect. Usually, one would expect to see Women*(n colpctn); Take a look at the output from this example, I added the ALL to show you the COLPCTN was working.

Cynthia

ods html file='c:\temp\example_tab.html';

proc tabulate data=sashelp.prdsale;

class product year region prodtype ;

tables (product * year * region) all,

prodtype *(n colpctn) /printmiss misstext=' ' ;

run;

ods html close;

Re: Regading Proc Tabulate

anilgvdbm — Wed, 24 Sep 2014 03:52:34 GMT

Dear Cynthia,

Suppose in your example i need subtotal and percentage for product wise how to go with that code?

can you explain to me please that is what exactly i was looking.

Thanks and Regards,

Anil