BookmarkSubscribeRSS Feed
Amine_Khemiri
Obsidian | Level 7

Hello,

 

Could anyone help me to convert SAS UTC datetime to EST datetime?

 

Thanks for your help.

 

kind regards,

Amine

 

Example: 

2011/01/03 01:03:00 
2011/01/03 01:04:00 

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

1. Like this?

data _null_;
  X='2011/01/03 01:03:00';
  format UTC EST datetime.;
  UTC=input(X,anydtdtm.);
  EST=intnx('hour',UTC,-5,'s');
  put UTC= EST=;
run;

UTC=03JAN11:01:03:00 EST=02JAN11:20:03:00

2. Maybe you don't need to transform anything at all. Look at the TIMEZONE option.

 

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 3443 views
  • 1 like
  • 2 in conversation