My current code is.
1. The "svcdate" variable in the "have" dataset starts with 2010 dates but for some reason in the "want" dataset output, I only get dates that are based on 1960s (resembles more like the patient's birthdates)
2. my enrolled_days_tot are showing up as "." in the output dataset 😞
Anybody know what is going on here? Thank you so much!
data want;
do until(last.enrolid);
set have;
where (dx1 in (&dx1_list.) or dx2 in (&dx1_list.) or dx3 in (&dx1_list.) or dx4 in (&dx1_list.))
and age >=&age_cutoff.;
by enrolid enroll_start_dt enroll_end_dt;
if first.enrolid then index_dt=svcdate and enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
format index_dt date11.;
output;
end;
keep enrolid enroll_start_dt enroll_end_dt index_dt enrolled_days_tot;
run;
This is erroneous:
if first.enrolid then index_dt=svcdate and enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
do you mean something like:
if first.enrolid and index_dt=svcdate then enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
or
if first.enrolid then do;
index_dt=svcdate;
enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
end;
I am only guessing.
This is erroneous:
if first.enrolid then index_dt=svcdate and enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
do you mean something like:
if first.enrolid and index_dt=svcdate then enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
or
if first.enrolid then do;
index_dt=svcdate;
enrolled_days_tot=intck('days', enroll_end_dt, enroll_start_dt);
end;
I am only guessing.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.