About sashelpwanted

sashelpwanted · ‎04-15-2014

So do you need the time field at all? If not then you can do this very simple by doing a nodupkey: proc sort data=yourfile nodupkey out=yourfile2; by pat_id sequence; run; If you need to keep that time then you could do something like this: proc sort data=yourfile; by sequence pat_id time; data yourfile2; set yourfile; by sequence pat_id time; if first.pat_id; run;

sashelpwanted · ‎04-15-2014

If I had a dataset that contained a Diabetes_Date and a Hypertension_date like the following: ID Diabetes_date Hypertension_date 111 4/5/05 7/10/06 222 3/4/14 9/6/10 I need a new variable date that would list the date at which they had both Diabetes and Hypertension. So for the above example it would be 7/10/06 for 111 and the 222 ID would be 3/4/14. I know I could do a few if statements to accomplish this, but wondering if there are other easy methods. Thanks so much!

sashelpwanted · ‎03-29-2014

Hello! I need help to flag where admission and discharge dates are within each other. For example: MHN ADMITDATE DISCHARGEDATE FLAG 111 1/5/2013 1/10/2013 111 1/7/2013 1/8/2013 1 111 2/3/2013 2/4/2013 222 2/10/2013 2/15/2013 222 2/10/2013 2/10/2013 1 222 2/14/2013 2/14/2013 1 444 5/10/2013 5/11/2013 So I would need a field called flag and I would need to flag the three that I have put a 1 by. Is this possible? Thank you so much in advance!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: multiple duplicate observations in a column of a char var.- want t...

Creating a new date when two diseases are first present

Need help to flag encounters inside other encountes

Re: multiple duplicate observations in a column of a char var.- want t...

Re: multiple duplicate observations in a column of a char var.- want t...

Creating a new date when two diseases are first present

Need help to flag encounters inside other encountes