Dear All - I have been trying to write a query in SAS EG in which I need to add the time difference of 30 minutes as per the following date and time format:
1141013222329
The above format means 13OCT2014 22:22:39
Now I want to extract processing done after 30 minutes of time difference.
and the desired result should be 13OCT2014 22:52
Can somebody help me to get this thing done.
thanks
Ather
Hi.
Your date time does not mean 13OCT2014 22:22:39, it means 13OCT2014 22:23:39.
The following, while far from elegant, will get the job done, as long as the curious leading "1" doesn't change.
data test;
dtinput=put(1141013222329,best13.);
dtstr1=substr(dtinput,2,6) ||" "|| substr(dtinput,8,2) ||":"|| substr(dtinput,10,2) || ":" || substr(dtinput,12,2);
dtnumeric=input(dtstr1(anydtdtm19.);
processInterval=intnx("dtminute",dtnumeric,30,"s");
format processInterval datetime;
run;
*Result processInterval = 13Oct14:22:53:29 ;
Good luck in your project.
-Joel.
First of all you need to provide a rule which digit positions in your original value correspond to day, month, year, hours, minutes and seconds.
If its a datetime value (and I am in meeting so cant check), then you can use intck on the time part to increment 30 minutes and then use that with the datepart.
Hi.
Your date time does not mean 13OCT2014 22:22:39, it means 13OCT2014 22:23:39.
The following, while far from elegant, will get the job done, as long as the curious leading "1" doesn't change.
data test;
dtinput=put(1141013222329,best13.);
dtstr1=substr(dtinput,2,6) ||" "|| substr(dtinput,8,2) ||":"|| substr(dtinput,10,2) || ":" || substr(dtinput,12,2);
dtnumeric=input(dtstr1(anydtdtm19.);
processInterval=intnx("dtminute",dtnumeric,30,"s");
format processInterval datetime;
run;
*Result processInterval = 13Oct14:22:53:29 ;
Good luck in your project.
-Joel.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.