creating date timestamp data set

[imsenny]

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]

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

[imsenny]

Yes...!

[imsenny]

I'm trying to analyze some second level data

[Astounding · Accepted solution]

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]

THANK YOU!