topic Re: How do you keep variables in the new dataset you create using proc means (not manipulating them) in SAS Programming

How do you keep variables in the new dataset you create using proc means (not manipulating them)?

Flexluthorella — Mon, 11 Nov 2019 13:03:27 GMT

data Hivdata;
merge learn.demogdemo (keep=patient_id male death arvstart) learn.visitdemo (keep=patient_id weight apptdate);
by patient_id;
run;

*identify min weight prior to ARTstart by seperating records where appt date is less than or equal to arvstart to find min weight by id;

proc means data=work.Hivdata min noprint;
class patient_id;
var weight male death;
where apptdate le arvstart;
output out=minweight
min=minWt;
run;

This code is outputing the new var minWt but the other variables like male and death are not being keep. I also need to do this with max weight and compare difference.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

unison — Mon, 11 Nov 2019 13:11:35 GMT

If you want your other variables you need to add them into the class statement - be careful though as this can change the result of the minimum just based on patientid. What you can do is merge the result of proc means back to your original set.

-unison

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

PaigeMiller — Mon, 11 Nov 2019 13:13:18 GMT

@Flexluthorella wrote:
data Hivdata;
merge learn.demogdemo (keep=patient_id male death arvstart) learn.visitdemo (keep=patient_id weight apptdate);
by patient_id;
run;

*identify min weight prior to ARTstart by seperating records where appt date is less than or equal to arvstart to find min weight by id;

proc means data=work.Hivdata min noprint;
class patient_id;
var weight male death;
where apptdate le arvstart;
output out=minweight
min=minWt;
run; 
This code is outputing the new var minWt but the other variables like male and death are not being keep. I also need to do this with max weight and compare difference.

If I am understanding the question properly (which I may not be, can you clarify or explain in more detail what you want) you need ask for statistics for variables MALE and DEATH in the OUTPUT statement as well.

Example:

output out=minweight min(weight)=minweight mean(male death)=;

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

novinosrin — Mon, 11 Nov 2019 13:13:22 GMT

Hi @Flexluthorella Good morning, A sample of your input dataset and the expected output for the input will help determine what's the best approach i would think. Your description gives me leaning towards proc sql unless your variable male and death are actually analysis variables.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:13:40 GMT

How will it changes the results? I need the absolute min per patient ID

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Ksharp — Mon, 11 Nov 2019 13:13:48 GMT

output out=minweight min= / autoname ;

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:15:33 GMT

I need the min weight per patient_id. the var male and death are numeric. male is gender and values include 1 for male 0 for female. Death values include 1 for deceased 0 for not deceased. I do not need the min or any stats for these.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:17:22 GMT

I designated the name as minWt. If I did autoname, how would that help with carrying over the other variables.?

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:19:02 GMT

Male and death need to be in the final table but not analyzed. I am creating two datasets with minwt and maxwt then merging these two together. My final output should have the delta weight where delta is gt 10 lbs and the tables will have only the proportion of deceased (death=1 only) or males vs females. final table is most likely proc freq with cum percentage.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:22:51 GMT

when I ran the var in the class statement, there were missing data spots. What do you mean by adding proc means results to original data set? How would I do that

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

novinosrin — Mon, 11 Nov 2019 13:27:12 GMT

ok @Flexluthorella Thanks. May I/we(on behalf of othersw too) request you to post the values of what you have?

Is it something like the below?

Patientid Gender Death Weight

A01 M 0 40

A02 M 1 60

A03 F 0 65

A04 F 1 55

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:34:55 GMT

See attached for initial data set. there are several wt values for each patient_id. I need the min and the max for each pat ID. The original file was too large to upload.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

novinosrin — Mon, 11 Nov 2019 13:40:47 GMT

How about?

proc sql;
select patientid, male, deceased ,min(weight) as min_wt
from your_input
group by patientid
having weight= min_wt;
quit;

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:47:05 GMT

Can I do the same for maxweight? Can I do this in one proc sql?

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:51:20 GMT

the proc sql function did not work. error states that state is not valid or used out of proper order.

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

novinosrin — Mon, 11 Nov 2019 13:53:27 GMT

yes you can if you want something like the following this to get two records i.e 1 for min 2 for max in the having filter

proc sql;
select patientid, male, deceased ,min(weight) as min_wt,max(weight) as max_wt
from your_input
group by patientid
having weight= min_wt or weight=max_wt;
quit;

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 13:56:03 GMT

There is an error with this one as well. The query does not give me the output I need

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

novinosrin — Mon, 11 Nov 2019 14:03:34 GMT

Please pen down a small sample like i did with 5 or 6 records and post the output you want. Then using that you can test against the real dataset you have

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Flexluthorella — Mon, 11 Nov 2019 14:12:35 GMT

"Using the data sets Demodemo.sas7bdat and Visitdemo.sas7bdat, we want to create a cohort

containing patients whose minimum body weight prior to ART start is more than 10 pounds

less than their maximum body weight after ART start and compare the proportion of deceased men to deceased women in this cohort."

I will be honest, I may not full understand the question and my professor is not responding to me.

patient_Id Male death arvstart apptdate

1 1 1 12May2012 01june2012

12 0 1 05april2015 09aug2016

36 1 0 18jan2016 06feb2013

Re: How do you keep variables in the new dataset you create using proc means (not manipulating them)

Tom — Mon, 11 Nov 2019 14:14:42 GMT

@Flexluthorella wrote:
I need the min weight per patient_id. the var male and death are numeric. male is gender and values include 1 for male 0 for female. Death values include 1 for deceased 0 for not deceased. I do not need the min or any stats for these.

So it sounds like those will be constant values across all observations for a particular person.

You can either include them in the CLASS statement instead of the VAR statement. (make sure to add NWAY option to the PROC statement).

Or if you include them in the VAR statement then calculate a stat on them. Like MIN or MAX.