topic Re: Count Age group Gender Wise in SAS Programming

Count Age group Gender Wise

BrahmanandaRao — Fri, 09 Oct 2020 13:40:11 GMT

proc sql;
select sex,age ,count(age) as age_wisecount from sashelp.class
group by  sex ,age;
quit;

Here I am trying below output datasetp

Sex	Age	age_wisecount
F	11	1
F	12	2
F	13	2
F	14	2
F	15	2
M	11	1
M	12	3
M	13	1
M	14	2
M	15	2
M	16	1

How count each age wise each gender wise

BrahmanandaRao — Fri, 09 Oct 2020 09:23:37 GMT

How to find how many people are there for age

11,12,13,14,15,16 for Sex M and F

using data step and proc sql

Re: How count each age wise each gender wise

BrahmanandaRao — Fri, 09 Oct 2020 11:25:00 GMT

any one can solve this

Re: Count Age group Gender Wise

ballardw — Fri, 09 Oct 2020 14:17:14 GMT

Since the code you show generates the shown output your question is not clear.

Are you asking how to get equivalent output with data step coding? If so, why?

Other methods such as Proc Means or Freq would be more appropriate.

Re: Count Age group Gender Wise

BrahmanandaRao — Fri, 09 Oct 2020 14:25:24 GMT

Yes equalent output with datastep

Re: Count Age group Gender Wise

ballardw — Fri, 09 Oct 2020 14:45:48 GMT

@BrahmanandaRao wrote:
Yes equalent output with datastep

Why?

What have you tried so far?

Re: Count Age group Gender Wise

BrahmanandaRao — Fri, 09 Oct 2020 14:51:42 GMT

we cannot do solve with datastep

Re: Count Age group Gender Wise

Reeza — Fri, 09 Oct 2020 15:40:06 GMT

@ballardw from previous threads it appears these are interview questions.

@BrahmanandaRao I've merged your two questions into one as they appear identical.

Re: How count each age wise each gender wise

mklangley — Fri, 09 Oct 2020 15:33:11 GMT

(It looks like this is posted twice: https://communities.sas.com/t5/SAS-Programming/Count-Age-group-Gender-Wise/m-p/690371 )

@BrahmanandaRao Is this what you're looking for?

data have;
    input sex $ age;
    datalines;
    F 11
    F 12
    F 12
    F 13
    F 14
    F 14
    F 14
    F 15
    F 16
    F 16
    M 11
    M 12
    M 12
    M 13
    M 13
    M 14
    M 15
    M 15
    M 16
    ;
run;

proc sql;
    create table want_proc_sql as
    select sex, age, count(*) as age_count
    from have
    group by sex, age;
quit;

/* Note: HAVE is assumed to be sorted by SEX then AGE */
data want_data_step;
    set have;
    by sex age;
    retain age_count 0;
    if first.age then age_count = 1;
    if age = lag(age) then age_count + 1;
    if last.age then output;
run;

Result for both WANT_PROC_SQL and WANT_DATA_STEP:

Re: Count Age group Gender Wise

Ksharp — Sat, 10 Oct 2020 12:58:03 GMT

/* Do you want Hash Table solution ? */


data have;
 set sashelp.class;
 keep sex age;
run;
proc sort data=have ;
by sex age;
run;
data want;
 do count=1 by 1 until(last.age);
  set have;
  by sex age;
 end;
run;