topic Re: Handling missing time varaible in SAS Data Management

Handling missing time varaible

pavan1 — Sun, 15 Jul 2018 16:48:44 GMT

hello,

i have two variables in my data set date and time(HH:MM) in seperate columns, i need to combine those columns and sort the data by date and time per subject.

While doing so i came across the situation like, the time is missing for one of the subjects ,and when i sort the data ,the record with missing time sorted to the top which leads to incorrect sorted data.

Kindly help me with this and handle the situation

Thank you

Re: Handling missing time varaible

PaigeMiller — Sun, 15 Jul 2018 17:12:11 GMT

Here is one solution

UNTESTED CODE

data want;
    set have;
    if not missing(time) then datetime=dhms(date,hour(time),minute(time),0);
    else datetime=dhms(date,0,0,0);
run;
proc sort data=have;
    by datetime;
run;

Naturally, there are other solutions regarding what to do with the missing time variable, I'm sure you can think of other ways to handle this.

Re: Handling missing time varaible

pavan1 — Sun, 15 Jul 2018 18:06:32 GMT

thank you so much paige