topic Re: Need help with variable frequency by group and year in SAS Programming

Need help with variable frequency by group and year

jgreenberg321 — Wed, 17 Jun 2020 18:55:15 GMT

Hello,

I am currently working with a large surgical healthcare dataset with many individual observations (patients) that are clustered within hospitals. Right now, one observation corresponds to an individual patient, (i.e. a surgical admission), and I have variables identifying hospital ID, gender, year of surgery, etc. My goal is to create a new dataset where each observation represents an individual hospital. I would like the variables in that dataset to reflect hospital proportions (means) of dichotomous variables for that year (e.g. proportion female patients per hospital per year). I tried using the following code to calculate means of all variables at once for each year, hoping to do this across 6 years and then merge all the datasets together. However, the output dataset only includes the mean for variable 1, not all 6 variables.

proc means data=have mean nway;

class hospid;

var var1 var2 var3 var4 var5 var6;

output out=test mean=prop;

where year=2011;

run;

I cannot figure out how to create an output dataset that lists the mean (proportion) for all variables, classified by hospital ID. Does anyone have any suggestions?

Thank you!

Re: Need help with variable frequency by group and year

PaigeMiller — Wed, 17 Jun 2020 18:58:58 GMT

proc summary data=have nway;
class hospid year;
var var1 var2 var3 var4 var5 var6;
output out=test mean=prop1-prop6;
run;

No need to create data sets by year and then combine them — that's just extra and unnecessary work. The code above gives you one data set with all of your results.

Re: Need help with variable frequency by group and year

novinosrin — Wed, 17 Jun 2020 19:00:33 GMT

You could use

proc means data=have mean nway;

class hospid year;

var var1 var2 var3 var4 var5 var6;

output out=test mean=/autoname;


run;

Re: Need help with variable frequency by group and year

ballardw — Wed, 17 Jun 2020 19:11:55 GMT

Is this data set used for further analysis, such as input to a model or to show a report summary for people to read?

If it is a report then perhaps either Proc Report or Tabulate would be in order.

Re: Need help with variable frequency by group and year

jgreenberg321 — Wed, 17 Jun 2020 19:26:19 GMT

This looks like it should be perfect. Thank you!

I do intend to perform additional models on this new dataset. Is there any reason that would necessitate that I use proc report or proc tabulate?

Thank you all!

Re: Need help with variable frequency by group and year

jgreenberg321 — Wed, 17 Jun 2020 21:08:18 GMT

Quick follow-up question: I also have a character variable for state in the dataset. Is there an efficient way in the same data step to keep that variable in the output ("test") dataset? If not, I can always merge it back in as a separate step; that just seemed less efficient. Thank you again!

Re: Need help with variable frequency by group and year

PaigeMiller — Wed, 17 Jun 2020 21:18:26 GMT

proc summary data=have nway;
class hospid year;
var var1 var2 var3 var4 var5 var6;
id charactervariablename;
output out=test mean=prop1-prop6;
run;

Re: Need help with variable frequency by group and year

jgreenberg321 — Wed, 17 Jun 2020 21:27:11 GMT

That’s perfect! Thank you!