topic Re: working with timestamps in SAS Programming

working with timestamps

GreggB — Tue, 21 Jul 2020 22:45:29 GMT

my data is of the form:

2020/07/13 8:27:15 PM AST

I want to read it in as numeric so I can sort it. I want to format it to read as it is in the Google sheet.

I need help with

informat timestamp ?;

format timestamp ? ;

Re: working with timestamps

Shmuel — Tue, 21 Jul 2020 23:58:38 GMT

Have a look at next links for date-time informats:

https://documentation.sas.com/?docsetId=etsug&docsetTarget=etsug_intervals_sect009.htm&docsetVersion=15.1&locale=en

Dealing with time zone:

https://support.sas.com/kb/44/074.html

Re: working with timestamps

ChrisNZ — Wed, 22 Jul 2020 00:09:28 GMT

1. Not using a 24h clock for time should be harshly punished

2. This reads your string:

proc format; 
  invalue weird_dtm 's/(\d*)\/([^ ]*)(.*)/$2\/$1$3/' (regexpe)=[anydtdtm32.];
data T;
  A = '2020/07/13 8:27:15 PM AST';
  B = input(a,weird_dtm.); 
  putlog B= datetime20.;
run;

B=13JUL2020:20:27:15

3. I am unsure what you want to do with the time zone. You might be interested in Overview of SAS Time Zones

Re: working with timestamps

GreggB — Sun, 26 Jul 2020 11:06:50 GMT

The SAS System 


Obs A                       B 
1 2020/07/13 8:27:15 PM AST .

Re: working with timestamps

Tom — Sun, 26 Jul 2020 22:15:58 GMT

@GreggB wrote:

my data is of the form:

2020/07/13 8:27:15 PM AST

I want to read it in as numeric so I can sort it. I want to format it to read as it is in the Google sheet.

I need help with

informat timestamp ?;

format timestamp ? ;

There a lot of unanswered questions for this. What is the actual source of this data? Sounds like you have SAS dataset with a character variable. But then you mentioned Google sheet. Do you have an XLSX compatible file? Do you want to create an XLSX compatible file?

Do you care about the timezone or not? That is do you just want to convert the value into a datetime value or do you want the result adjust so that values from different timezones can be compared? So AST is 4 hours before GMT. Note AST is the same offset from GMT as EDT (at least now).

What do you mean about formatting in the Google sheet? Are you going to write a report and publish it as a Google worksheet? Do you need the value stored in the Google sheet as datetime value with its offset from GMT?