topic Array Question? in SAS Procedures

Array Question?

robertrao — Mon, 16 Sep 2013 17:05:50 GMT

hi team,

in the past i had a similar question and Tom &others helped me .

That time it was transposing the below "have" dataset into a single record. But now i want the below data to transposed into WANT dataset having the 5 records like shown!!!

Thanks

/*aFTER SORTING MY DATASET BY :iD AND TIME I GET THE BELOW

"have"*/

ID      flag                        time
101      TIMEIN     04SEP89:07:30:00
101      TIMEIN     04SEP89:13:45:00
101      TIMEOUT    05SEP89:07:15:00
101      TIMEIN     21SEP89:17:55:00
101      TIMEOUT    22SEP89:06:00:00
101      TIMEOUT    23SEP89:06:00:00
101      TIMEIN     24SEP89:06:00:00

/*WANT*/

ID                 timein                       timeout
101           04SEP89:07:30:00          .
101           04SEP89:13:45:00    05SEP89:07:15:00
101           21SEP89:17:55:00    22SEP89:06:00:00
101                 .                           23SEP89:06:00:00
101           24SEP89:06:00:00           .

Re: Array Question?

data_null__ — Mon, 16 Sep 2013 17:34:30 GMT

Seems like the main issue is how to group the in/out so that you can transpose. This is what I came up with but it may not work for anything but your test data.

data stay;
   input ID $  flag $ time :datetime.; 
   format time datetime.; 
   cards; 
101      TIMEIN     04SEP89:07:30:00    
101      TIMEIN     04SEP89:13:45:00   
101      TIMEOUT    05SEP89:07:15:00     
101      TIMEIN     21SEP89:17:55:00  
101      TIMEOUT    22SEP89:06:00:00
101      TIMEOUT    23SEP89:06:00:00
101      TIMEIN     24SEP89:06:00:00
;;;;
  run; 
proc print; 
  run; 
data stay2;
   set stay;
   by id flag notsorted; 
   if flag eq 'TIMEIN' then stay+1; 
   if not first.flag and flag eq 'TIMEOUT' then stay+1; 
   run; 
proc print; 
   run; 
proc transpose out=stay3;
   by id stay;
   id flag;
   var time;
   run; 
proc print; 
   run; 

Re: Array Question?

robertrao — Mon, 16 Sep 2013 17:41:28 GMT

Thanks for the reply data_null_.

But why would it not work out of my test data?

Thanks

Re: Array Question?

data_null__ — Mon, 16 Sep 2013 18:12:59 GMT

I said it MAY not.