topic percentage of male female in front row and male in front row in SAS Studio

proc freq help

pinkyloop — Tue, 08 Oct 2019 12:57:52 GMT

hi everyone,

i need help with these

1) how do i get the freq for just the front row.this is what i did

proc freq data=merged;
tables seat * sex/nocum ;

run;

2) how do i get the percentage of students that missed 0 classes,1-3 classes or more than 3 classes.

This is what i did;

*Created new data set called newset to recode the missclas variable as Mclass;
data newset;
set merged;
if 0<=missclass<=1 then mclass='Low';
else if 1<=missclass<=3 then mclass='Avg';
else if missclass>3 then mclass= 'High';
run;
proc print data=newset;

*Percent of students that missed class using the newset data;
proc freq data =mclass;
tables mclass/ norow nocol nocum;
title 'Percent of students based on gender and classes Missed';

b)i was also thinking of this;

proc format

value $mclass '0'=good

'1-3'=fair

'3+'=bad

proc freq data =merged;

table missclass;

format missclass $mclass.;

please help;

Thanks

percentage of male female in front row and male in front row

pinkyloop — Tue, 08 Oct 2019 12:55:20 GMT

hi everyone,

i need help with these

1) how do i get the freq for just the front row.this is what i did

proc freq data=merged;
tables seat * sex/nocum ;

run;

2) how do i get the percentage of students that missed 0 classes,1-3 classes or more than 3 classes.

This is what i did;

*Percent of students that missed class using the newset data;
proc freq data =mclass;
tables mclass/ norow nocol nocum;
title 'Percent of students based on gender and classes Missed';

b)i was also thinking of this;

proc format

value $mclass '0'=good

'1-3'=fair

'3+'=bad

proc freq data =merged;

table missclass;

format missclass $mclass.;

please help;

Thanks

Re: percentage of male female in front row and male in front row

PaigeMiller — Tue, 08 Oct 2019 13:02:05 GMT

There's no need to post the same question twice. All replies should go into your other thread.

https://communities.sas.com/t5/SAS-Studio/proc-freq-help/td-p/594726

Re: percentage of male female in front row and male in front row

pinkyloop — Tue, 08 Oct 2019 13:03:12 GMT

ok thanks!

Re: proc freq help

PaigeMiller — Tue, 08 Oct 2019 13:03:17 GMT

What do you mean by "just the front row"?

Please show us what you are getting, and in detail, explain why this isn't what you want and exactly what you do want. Please provide (a portion of) your data for us to see.

Re: proc freq help

pinkyloop — Tue, 08 Oct 2019 13:06:01 GMT

the question says

calculate the percentage of female students who sat in the front row and compare it to the male students who sat in the front row.

usint the proc freq for the table sex *sex.i get the freq for all the row of seat both male and females sat.

Re: proc freq help

PaigeMiller — Tue, 08 Oct 2019 13:19:50 GMT

We don't know how "front row" is identified in the data.

We need to see (a portion of) your data, with explanation.

Re: proc freq help

pinkyloop — Tue, 08 Oct 2019 13:26:08 GMT

please see attached part of the data i am working with

Thanks

Re: proc freq help

pinkyloop — Tue, 08 Oct 2019 13:27:23 GMT

'front' is identified in the data

Re: proc freq help

PaigeMiller — Tue, 08 Oct 2019 13:41:37 GMT

@pinkyloop wrote:

1) how do i get the freq for just the front row.this is what i did
proc freq data=merged;
tables seat * sex/nocum ;
run;

proc freq data=merged(where=(seat='Front'));
    tables sex;
run;

2) how do i get the percentage of students that missed 0 classes,1-3 classes or more than 3 classes.

proc format;
    value missf 0='0' 1-3='1-3' 4-high='>3';
run;
proc freq data=merged;
    tables missclass;
    format missclass missf.;
run;

Re: proc freq help

pinkyloop — Tue, 08 Oct 2019 13:46:42 GMT

Thank you so Much!

Re: proc freq help

ballardw — Tue, 08 Oct 2019 15:18:10 GMT

@pinkyloop wrote:
Thank you so Much!

@PaigeMiller's solution is one demonstration of an extremely powerful tool in SAS: Formats. Almost any grouping that needs to be done based on a single variable should at least consider the use of a format instead of adding a variable.

The groups created by formats are generally honored by most analysis, reporting and graphing procedures. So they can be extremely handy for examining data behavior. You can create multiple formats and see the results by just changing the format associated for use in a procedure.

Also if you have lists that change occasionally, think store, building name, teacher it can be easier to modify a format to use the current association then to modify data sets.

And the flip side of the format, the informat (invalue statement in Proc Format) can be used to read data into consistent forms or identify data entry errors or unexpected values.