how to calculate time in and time out question

shiyiming

Hi all,

do any know how to calculate time in and time out question.
I would like to know how long abc and def
are using computer in rooms.

NetId  Logindata      room        time
abc        IN           KKK250H   46200
abc       OUT         KKK250H   48061
def         IN           RRR150A    43140
def        OUT         RRR150A   43148

thanks for helping. (^^)

shiyiming

我觉得可以先把In提取出来进一个file: timein，这里面把time改成timein；然后把out提取出来进另一个file: timeout，把这里的time改成timeout。
最后merge timein timeout，这样你就可以用timeout-timein得出duration了。

shiyiming

what if you have the missing value in logindata, such as abc is missing Login out information

NetId Logindata room time
abc IN KKK250H 46200
abc IN KKK243s  48756
abc OUT KKK250H 48061

Thanks a lot.
New SAS learner

shiyiming

[code:1qdgo50v]data raw;
        input NetId $ Logindata $ room $ time;
        format time time8.;
datalines;
abc IN KKK250H 46200
abc IN KKK243s 48756
abc OUT KKK250H 48061
;

proc sort data=raw;
        by netid room;
run;

data temp(drop=logindata time);
        do _n_=1 by 1 until(last.room);
                set raw;
                by netid room;
                if upcase(logindata)='IN' then in_time=time;
                else if upcase(logindata)='OUT' then out_time=time;
        end;
        dif_time=out_time-in_time;
        format dif_time in_time out_time time8.;
run;[/code:1qdgo50v]

shiyiming

Hi hopewell dengzi
thanks for your advise that giving me more understandable in SAS

Thanks again