topic Re: Can you use a class statement to calculate statistics for two datasets all in one proc means? in New SAS User

Can you use a class statement to calculate statistics for two datasets all in one proc means?

cheenaChuks — Sat, 30 Mar 2019 21:56:01 GMT

Hi everyone,

I am trying to solve the following question but I am lost as to how to do this. There are two datasets involved but they can be linked by patient id which is present in both datasets. However I am trying to calculate statistics of three variables as described in my code below: Any thoughts or queries. Sorry, I can't post the dataset but I'd appreciate some help.

/*8
Using the SAS datasets demogdemo and visitdemo and PROC MEANS with the CLASS statement, 
compute the mean, median, 25th percentile, 75th percentile, and the number of non-missing
values for the variables CD4, Weight, and Age for each value of civil status 
including missing.  Report the statistics to three decimal places.  In the same PROC MEANS,
create a summary dataset with the OUTPUT statement containing the median and mean of CD4, 
Weight, and Age.  Using _TYPE_, print only the overall (i.e. all civil 
status categories combined) mean and median from this summary dataset. 
*/
title "Using a CLASS Statement with PROC MEANS";
proc means data=lb.visitdemo n mean median Q1 Q3 maxdec=3; *what about demogdemo?;
   class civilstatus;
   var CD4 Weight Age ;
run;

Re: Can you use a class statement to calculate statistics for two datasets all in one proc means?

Kurt_Bremser — Sun, 31 Mar 2019 05:53:35 GMT

proc means accepts one dataset as input, so you will have to do the join first.

Re: Can you use a class statement to calculate statistics for two datasets all in one proc means?

Flexluthorella — Wed, 30 Oct 2019 11:46:51 GMT

How would you join these datasets?

Re: Can you use a class statement to calculate statistics for two datasets all in one proc means?

Kurt_Bremser — Wed, 30 Oct 2019 12:05:23 GMT

@Flexluthorella wrote:

How would you join these datasets?

With SQL or with a data step merge.

Re: Can you use a class statement to calculate statistics for two datasets all in one proc means?

Flexluthorella — Wed, 30 Oct 2019 12:12:33 GMT

Does it matter if you use proc sql or merge if you want to use the proc means by class statement?

Re: Can you use a class statement to calculate statistics for two datasets all in one proc means?

Kurt_Bremser — Wed, 30 Oct 2019 12:15:23 GMT

No. You only need to put all necessary data into one dataset to feed into proc means. How you created that dataset is of no interest to the procedure.