topic Re: Tabulate Weight in Graphics Programming

Tabulate Weight

DavidPhillips2 — Mon, 17 Aug 2015 20:21:32 GMT

I'm following the example in Weight the Results II in the book:

https://books.google.com/books?id=6lpACQAAQBAJ&pg=PT230&lpg=PT230&dq=tabulate+sumwgt&source=bl&ots=mgWIRaUbhx&sig=ODJ_x3EFQnSBeWDCNrsFKwJeE34&hl=en&sa=X&ved=0CFAQ6AEwCGoVChMIpcKr7O-wxwIVhIsNCh2r0QD9#v=onepage&q=tabulate%20sumwgt&f=true

and I’m running into the error

ERROR: Variable GENDER in list does not match type prescribed for this list.

when I uncomment the comment below. Does the line not work in SAS 9.2? Am I missing something simple?

I’m trying to multiply gender by the number of admissions.

proc tabulate data=enrollment out=barGraphDataTEST;

/*var gender / weight=admissions;*/

class academic_period_desc gender;

table academic_period_desc, gender*rowpctn gender*colpctn;

run;

Re: Tabulate Weight

Reeza — Mon, 17 Aug 2015 20:36:27 GMT

It works as both char and numeric for me in SAS9.3

proc tabulate data=sashelp.class out=barGraphDataTEST;

/*var gender / weight=admissions;*/

class age sex;

table age, sex*rowpctn sex*colpctn;

run;

data class;

set sashelp.class;

gender=ifn(sex='F', 1, 0);

run;

proc tabulate data=class out=barGraphDataTEST;

/*var gender / weight=admissions;*/

class age gender;

table age, gender*rowpctn gender*colpctn;

run;

Re: Tabulate Weight

DavidPhillips2 — Mon, 17 Aug 2015 20:43:36 GMT

In 9.2 this breaks

proc tabulate data=sashelp.class out=barGraphDataTEST;

var sex / weight=age;

class age;

table age, sex*rowpctn sex*colpctn;

run;

Re: Tabulate Weight

Reeza — Mon, 17 Aug 2015 21:16:05 GMT

It does in 9.3 as well.

Sex should be a class variable as it's a grouping variable not an analysis variable.

Re: Tabulate Weight

DavidPhillips2 — Tue, 18 Aug 2015 13:05:46 GMT

How can I multiply a grouping variable by a weight column? E.g. Sex by age and still use the rowpctn with it? The idea is if there are 15 instances of gender and the column age = 100. The value should be 1500.

Re: Tabulate Weight

DavidPhillips2 — Tue, 18 Aug 2015 13:25:47 GMT

What I am trying to create is like this multiplied by the column admissions.

Re: Tabulate Weight

DavidPhillips2 — Tue, 18 Aug 2015 13:43:35 GMT

This produces the same structure but oddly does not multiply by admissions. It simply adds the grouping admissions above gender.

proc tabulate data=enrollment out=barGraphDataTEST;

var admissions;

class academic_period_desc gender;

table academic_period_desc, gender*(admissions*rowpctn) gender*(admissions*colpctn);

run;

This produces the same thing. It doesn't actually weight.

proc tabulate data=enrollment out=barGraphDataTEST;

weight admissions;

class academic_period_desc gender;

table academic_period_desc, (gender*admissions)*rowpctn (gender*admissions)*colpctn;

run;

Re: Tabulate Weight

Reeza — Tue, 18 Aug 2015 14:31:56 GMT

Can you post sample input data?

Re: Tabulate Weight

DavidPhillips2 — Tue, 18 Aug 2015 14:37:30 GMT

data genderData;

input gender $ 1-12 year admissions;

datalines;

Not Reported 2010 3

Not Reported 2011 5

Not Reported 2012 7

Not Reported 2013 6

Not Reported 2014 4

Male 2010 5

Male 2011 1

Male 2012 1

Male 2013 3

Male 2014 4

Female 2010 2

Female 2011 1

Female 2012 1

Female 2013 2

Female 2014 1

;

Re: Tabulate Weight

Reeza — Tue, 18 Aug 2015 14:48:06 GMT

Try the FREQ option instead of Weight.

Re: Tabulate Weight

DavidPhillips2 — Tue, 18 Aug 2015 14:57:17 GMT

thanks

This worked.

data genderData;

input gender $ 1-12 year admissions;

datalines;

Not Reported 2010 3

Not Reported 2011 5

Not Reported 2012 7

Not Reported 2013 6

Not Reported 2014 4

Male 2010 5

Male 2011 1

Male 2012 1

Male 2013 3

Male 2014 4

Female 2010 2

Female 2011 1

Female 2012 1

Female 2013 2

Female 2014 1

;

proc tabulate data=genderData out=barGraphDataTEST;

freq admissions;

class year gender;

table year, (gender)*rowpctn (gender)*colpctn;

run;