%let time= %sysfunc(compress(%str(%')%sysfunc(time(),time.)%str(%'t))); %put &time.;   Variable time will get the current time. May I know how to adjust the program wherein it will get the time 14 hours earlier. Example, if the current time id 20:00:00, I want to get the time 14 hours earlier which is 06:00:00. Thanks.   ... View more

Let's say I have a data below:   data have; infile cards truncover; input ID :$4.; cards; 0196 0196 0196 0395 0752 1277 1277 ; run;   What I want is to have a new table with a new column wherein it will count the number of times the ID appeared but not group it. To explain it clearer, I want to have an output like this: ID        Count_ID 0196          1 0196          2 0196          3 0395          1 0752          1 1277          1 1277          2   Could someone help me on this? A program that will work even if ID is not sort by order ... View more