topic Re: Proc Freq help please-sas9.2 in Statistical Procedures

Proc Freq help please-sas9.2

robertrao — Fri, 14 Sep 2012 20:09:32 GMT

I have two variables:

Age

Charecteristic

Charecteristic (variable)

Tiny(value)

Age(formatted) Huge (value)

21-30

31-40

41-50

51-60

61-70

71-high

i want to make a 3 contingency tables like this(to see the relation and find chisq):

Age \Charecteristic Y N

Tiny

Age\Charecteristic Y N

Huge

Age\Charecteristic Y N

Any

Concerns:

How can we get a table with one value(for exTiny) when it has Tiny and Huge under that variable name

How can we get Y and N (There is no variable holding these values).Do i need to create a format???

Could anybody help me out please???

Thanks

Re: Proc Freq help please-sas9.2

robby_beum — Fri, 14 Sep 2012 20:40:17 GMT

Maybe I'm not understanding the question but this might help get you closer (not understanding the Y/N part):

proc freq data=your.indata;

tables age*characteristic / list missing

out=your.outdata;

where characteristic='Tiny';

run;

Re: Proc Freq help please-sas9.2

robertrao — Fri, 14 Sep 2012 20:51:24 GMT

Hi Robby,

Thanks so much for the reply.

I am guessing.

Suppose 21-30 age group has 50 people............but in that 50 ........12 are Tiny and 20 are Huge

so when it is tiny it is

Y N

12 20

when it is Huge it is:

Y N

20 12

when it is Any it is:

Y N

32 12

I think this gives a clear picture......

But Do we have to create the Y and N .if so how to do that too?//

Thanks for ur time

Re: Proc Freq help please-sas9.2

robertrao — Fri, 14 Sep 2012 20:58:22 GMT

Sorry it would be like this

When Tiny

Y N

12 38

When Huge

Y N

20 30

When Any

Y N

32 18