topic Re: Timestamp Manipulation in SAS Programming

Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 05:21:45 GMT

I have a date in the following format

date1 = "05JAN2017:09:58:57.822"dt

I need to Subs tract 10 seconds from it. How to go about it ?

Please Help.

Thanks in Advance.

Re: Timestamp Manipulation

Shmuel — Thu, 05 Jan 2017 05:33:57 GMT

Use

date2 = intnx('seconds',date1,10);

Re: Timestamp Manipulation

Patrick — Thu, 05 Jan 2017 06:09:58 GMT

What @Shmuel proposes is the "clean" way of doing things.

But just for your understanding:

date1 = "05JAN2017:09:58:57.822"dt creates a SAS DateTime value which is numerical variable containing the number of seconds since 1/1/1960 - and as it's already in seconds and the variable is numerical you could also simply substract 10 seconds from it.

date2=date1-10;

Re: Timestamp Manipulation

shubhayog — Thu, 05 Jan 2017 06:38:39 GMT

I will also suggest the same thing, you can direct substract 10 seconds from your date, because your date is already saved in datetime format.

Re: Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 07:06:14 GMT

Didn't work

It is Returning Null Value.

%Let date1= "05JAN2017:09:58:57.822"dt;
%Let date2=;
data _null_;
date2 = intnx('seconds',&date1,10);
run;
%Put &date2;

date2 returns NULL.

Re: Timestamp Manipulation

mnjtrana — Thu, 05 Jan 2017 07:08:04 GMT

Same solution as @Patrick

Manjeet

Re: Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 07:10:05 GMT

It is not working

Accoring to log it is returning NULL value.

LOG:

24 %Let date1= "05JAN2017:09:58:57.822"dt;
25 %Let date2=;
26 data _null_;
27 date2 = &date1 -10;
28 run;

NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

29 %Put &date2;

30

Re: Timestamp Manipulation

mnjtrana — Thu, 05 Jan 2017 07:14:30 GMT

using @Shmuel way, you will also get the result.

You just missed the call symput statement in your program, date2 macro variable is still assigned to null. Please note Date2 will be in SASDATE.

try this.


%Let date1= "05JAN2017:09:58:57.822"dt;
data _null_;
date2 = intnx('seconds',&date1,10);
Call symputx('date2',date2);
run;
%Put &date1 ;
%put &date2;

Manjeet

Re: Timestamp Manipulation

mnjtrana — Thu, 05 Jan 2017 07:16:46 GMT

@ankit___gupta

You again missed the call symput. try this:

%Let date1= "05JAN2017:09:58:57.822"dt;
%Let date2=;
data _null_;
date2 = &date1 -10;
call symput ('date2',date2);
run;
%put &date2;

Re: Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 08:41:56 GMT

Got this as the output
29 %put &date2;
1799229527.8

Converting to sasdate results in null.

Re: Timestamp Manipulation

Shmuel — Thu, 05 Jan 2017 09:29:19 GMT

To subrtact 10 seceonds from a timestamp, i.e. a datetime sas variable, you can do

either by date2 = date1 - 10;

or by date2 = intnx('seconds',date1, -10,'same');

After calculating date2, if you want it as a macro variable you can do:

either by call symput('date2', date2); or by call symput('date2', put(date2,best18.1));

or by call syput('date2', '"' || put(date2, datetime18.1) ||'"dt');

In order to check &date2, you can use %put &date2; but you shall get differen view each time.

You can check by:

data _NULL_;

date2 = &date2;

put date2= datetime18.1;

run;

and check your log - you shall get same output, doesn't matter how you created that macro variable.

Re: Timestamp Manipulation

Patrick — Thu, 05 Jan 2017 09:18:12 GMT

@ankit___gupta

I'm a bit under the impression that you're probably asking for something that wouldn't be necessary to do and if you would give us the bigger picture and why you want to create such a second macro variable then we could eventually suggest other more direct ways to achieve the same end result.

Based on the code you've posted and what you're asking for below should work.

%let date1= "05JAN2017:09:58:57.822"dt;
data _null_;
  call symputx('date2',cats('"',put(&date1-10,datetime26.3),'"dt'));
run;
%put &=date1;
%put &=date2;

Re: Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 09:42:16 GMT

@Shmuel Thank You for your solution, it worked.

Re: Timestamp Manipulation

ankit___gupta — Thu, 05 Jan 2017 09:45:30 GMT

@Patrick Requirement was to read the timestamp and reduce 10 sec from each. So i was unable to provide a broder picture.

anyways Thanks a LOT !!