You do not need to look backwards. Just store the last time the person fell asleep (assuming your data is sorted by name and datetime, as shown): data want;
count=0;
do until(last.name);
set class;
by name sleep notsorted;
if first.sleep and sleep and fell_asleep<intnx('minute',datetime,-10) then do;
fell_asleep=datetime;
count=count+1;
end;
end;
format fell_asleep datetime20.;
run;
You may want to drop the fell_asleep variable, I did not in order to check it.
... View more
It looks like for the example data posted that the "date" value does include the time as a fraction of a day (like how Excel would store it). So adding the date with fraction of day and time caused the time to be doubled.
Here is test using the first two values in original question.
data have ;
input date :mmddyy. time :time. datetime :datetime. ;
date2 = date + (time/'24:00't);
datetime2 = dhms(date,0,0,time);
datetime3 = dhms(date2,0,0,time);
datetime4 = dhms(date2,0,0,0);
datetime5 = dhms(int(date2),0,0,time);
format date date2 date9. time time8. datetime: datetime20. ;
put (_n_ _all_) (=/);
cards;
01/10/2016 23:29:00 11JAN16:22:58:00
01/10/2016 23:30:00 11JAN16:23:00:00
;
_N_=1
date=10JAN2016
time=23:29:00
datetime=11JAN2016:22:58:00
date2=10JAN2016
datetime2=10JAN2016:23:29:00
datetime3=11JAN2016:22:58:00
datetime4=10JAN2016:23:29:00
datetime5=10JAN2016:23:29:00
_N_=2
date=10JAN2016
time=23:30:00
datetime=11JAN2016:23:00:00
date2=10JAN2016
datetime2=10JAN2016:23:30:00
datetime3=11JAN2016:23:00:00
datetime4=10JAN2016:23:30:00
datetime5=10JAN2016:23:30:00
... View more
Hi, something like this maybe? %macro cohort; %do i=1 %to 5; data cohort&i; infile or set statement here, and you can add &var to create variable different for each year; ..... run; %end; /*you can insert your second macro here that will run for each cohort separately*/ %mendcohort; %cohort;
... View more
This is great, thank you! Quick question: Is there a way to include a DO UNTIL loop that would stop processing (that day for that person) after we reach the first consecutive 3 minutes of disease? In other words, if later that night disease becomes 0 and then goes back to 1--I don't want to count them. data WORK.CLASS;
infile datalines truncover;
input Name:$8. moving disease datetime;
informat datetime datetime20.;
format datetime datetime20.;
datalines;
Alfred 0 0 04MAR14:23:55:00
Alfred 0 0 04MAR14:23:56:00
Alfred 1 0 04MAR14:23:57:00
Alfred 1 0 04MAR14:23:58:00
Alfred 1 0 04MAR14:23:59:00
Alfred 1 1 05MAR14:00:00:00
Alfred 1 1 05MAR14:00:01:00
Alfred 1 1 05MAR14:00:02:00
Alfred 1 0 05MAR14:00:03:00
Alfred 1 1 05MAR14:00:04:00
mary 0 0 04MAR14:23:55:00
mary 0 0 04MAR14:23:56:00
mary 0 0 04MAR14:23:57:00
mary 0 0 04MAR14:23:58:00
mary 0 0 04MAR14:23:59:00
mary 1 0 05MAR14:00:00:00
mary 1 1 05MAR14:00:01:00
mary 1 1 05MAR14:00:02:00
mary 1 1 05MAR14:00:03:00
mary 1 1 05MAR14:00:04:00
run;
... View more
data WORK.CLASS;
infile datalines truncover;
input Name:$8. disease datetime;
informat datetime datetime20.;
format datetime datetime20.;
datalines;
Alfred 0 04MAR14:23:55:00
Alfred 0 04MAR14:23:56:00
Alfred 1 04MAR14:23:57:00
Alfred 1 04MAR14:23:58:00
Alfred 0 04MAR14:23:59:00
Alfred 0 04MAR14:00:00:00
Alfred 1 04MAR14:01:01:00
Alfred 1 04MAR14:01:02:00
Alfred 1 04MAR14:01:03:00
Alfred 1 04MAR14:01:04:00
mary 0 04MAR14:23:55:00
mary 0 04MAR14:23:56:00
mary 0 04MAR14:23:57:00
mary 0 04MAR14:23:58:00
mary 0 04MAR14:23:59:00
mary 1 04MAR14:00:00:00
mary 0 04MAR14:01:01:00
mary 0 04MAR14:01:02:00
mary 1 04MAR14:01:03:00
mary 1 04MAR14:01:04:00
;
data want;
set class;
by name;
flag= (first.name=1 and disease=1) or (dif(disease)=1);
run;
The DIF function is defined as dif(x)=x-lag(x). So the condition "dif(disease)=1" picks up all instances of disease=1 that immediately follow a disease=0.
... View more
Hi @lalaktgrau,
Try this:
data want;
set have;
hours=timepart(datetime)/3600;
format hours z8.5;
run;
Note that your example ("01.00067") is incorrect.
... View more
@lalaktgrau wrote:
Do you know if there is a way to combine a date variable and a time variable to create a Datetime variable?
The dhms() function. Use the date as the first and the time as the fourth parameter; set the second and third parameter to zero.
... View more
On second thought, not sure it matters either. Try this:
data want;
set have;
if hour(timepart(datetime)) >= 19 or hour(timepart(datetime)) <= 12 then interval='Night';
else interval = 'Day';
run;
... View more
Request an output dataset with residuals.
OUTPUT OUT=MyRes R=resid;
Only obs used in the regression will have a non missing residual.
This is assuming you didn't use a WEIGHT statement in proc GLM.
... View more
@Specifies a 2 way interaction. If you had listed three variables separated by | with @2 it would do all two way interactions.
model ageAtStart = weight | height | diastolic @2;
Should be the same as (assuming I wrote it out correctly).
model ageAtStart = weight height diastolic weight*height weight*diastolic height*diastolic;
@lalaktgrau wrote:
@What does the @2 do?
... View more
