topic Re: creating date timestamp data set in SAS Programming

creating date timestamp data set

imsenny — Wed, 10 Aug 2016 14:57:07 GMT

Hi I need to create a dataset with a variable "datetimestamp" from march 2011 to may 2011.

So the format I need is...

variable name= datetimestamp

timestamp format = 01MAR11:00:00:00 ~ 31MAY11:11:59:59

I think this should be pretty simple to do, but I'm stuck.,,,

Any help would be greatly appreciated!
Thanks SAS pros in advance!

Chloe

Astounding — Wed, 10 Aug 2016 15:07:41 GMT

SAS date-times represent a single second. Do you actually want a separate observation for every second between March and May 2011?

imsenny — Wed, 10 Aug 2016 15:10:19 GMT

Yes...!

imsenny — Wed, 10 Aug 2016 15:11:23 GMT

I'm trying to analyze some second level data

Astounding — Wed, 10 Aug 2016 15:26:34 GMT

OK, here goes ...

data want;

do datetimestamp = '01MAR2011 00:00:00'dt to '31MAY2011 23:59:59'dt;

output;

end;

format datetimestamp datetime23.;

run;

I'm assuming you want to continue the loop until midnight, not stop at noon. Thus using 23 as the final hour, not 11.

imsenny — Wed, 10 Aug 2016 16:16:58 GMT

THANK YOU!