topic Create two datasets from one dataset in SAS Health and Life Sciences

Create two datasets from one dataset

deleted_user — Tue, 01 Jul 2008 14:28:23 GMT

I am trying to split a dataset into two datasets. My dataset consists of three variables, patient, note_date, note. For example, the dataset has many patients and each patient has many records. I am trying to determine what is the first visit date for each patient and then seperate the dataset into one dataset containg all patients with their first visits only and a dataset with all patients with all visits except the first one. For clarity the patient can have more than one first visit date. I tried using first. but can't seem to work out the logic. Any help is appreciated.

Re: Create two datasets from one dataset

deleted_user — Tue, 01 Jul 2008 15:19:31 GMT

Well I figured this one out.

My code is below.

proc sort data=progressnotes;
by pat_name note_date;
run;

data temp;
set progressnotes;
format n_date mmddyy10.;
n_date=DATEPART(note_date);
run;

data temp;
set temp;
retain first_visit;
format first_visit mmddyy10.;
by pat_name note_date;
if first.pat_name then do;
first_visit=n_date;
end;
run;

Re: Create two datasets from one dataset

Cynthia_sas — Tue, 01 Jul 2008 18:05:41 GMT

Hi:
In order to streamline your code, this construction:

[pre]
data temp;
set temp;
[/pre]

is not needed. Since progressnotes is sorted and you are creating n_date only for the purpose of creating first_visit for every obs in a patient group, you can do everything you need in one data step program. You might, instead, consider code like this:
[pre]
proc sort data=progressnotes;
by pat_name note_date;
run;

data temp;
retain first_visit;
format first_visit mmddyy10.
n_date mmddyy10.;

set progressnotes;
by pat_name note_date;

n_date=DATEPART(note_date);

if first.pat_name then do;
first_visit=n_date;
end;
run;
[/pre]

If you don't want a separate n_date on every obs, then you could just have
[pre]
first_visit=datepart(note_date);
[/pre]

But you must have wanted a separate n_date on every obs, since you put it there in a separate data step program. At any rate, you can create n_date and first_visit in the same program.

cynthia

Re: Create two datasets from one dataset

deleted_user — Tue, 01 Jul 2008 18:29:38 GMT

Thanks Cynthia,

I don't mind shortening my code.