topic Re: Proc means in SAS Programming

Proc means

souji — Sat, 11 Jan 2020 19:33:13 GMT

Please correct me if I wrong coded in the below:

/*Scenario:

1. Subset the data into two data sets, work.young and work.mid based on Age variable.

2. work.young should contain observations with Age less than 40 years old.

3. work.mid should contain observations with Age between 40 and 65 years old, inclusively.

4. How many observations are in the mid data set?

5. What is the CustomerId for observation 14 in the young data set?

6. What is the average Age of the customer in the young data set? */

data work.young work.mid;

set Souj.Input41;

if Age<40 then output work.young;

else if 40<= Age <=65 then output work.mid;

run;

proc means data=work.young;/*I think,#6*/

var Age;

run;

Re: Proc means

ed_sas_member — Sat, 11 Jan 2020 19:43:25 GMT

Hi @souji
It seems to be fine 👍

Re: Proc means

souji — Sat, 11 Jan 2020 20:06:39 GMT

Thank You to @ed_sas_member

Re: Proc means

PaigeMiller — Sat, 11 Jan 2020 23:09:54 GMT

As I discussed earlier, there is no need to split the data into two data sets to do these analyses. If some instructor is requesting that you do this, they are teaching you a rather weak and ineffective technique in SAS. This can all be done without creating one or two new datasets using PROC MEANS. While this may not make the slightest difference in a small problem, it could make a difference using huge real world data sets, and splitting data sets up like this is also not a good way to program.

proc format;
    value agef. low-<40='0-40' 40-65='40-65';
run;

proc means data=souj.input41;
var age;
format age agef.;
run;

or #6 can be programmed like this:

proc means data=souj.input41(where=(40<=age<=65));
var Age;
run;

Re: Proc means

Reeza — Sun, 12 Jan 2020 01:21:30 GMT

What are you trying to do here? Get through a course or learn SAS. If it's the first, please continue as is. If you're actually trying to learn SAS, these questions are good but they will not teach you to be an effective SAS programmer at all.