SAS Programming

DATA Step, Macro, Functions and more
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.

 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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
  • 2528 views
  • 1 like
  • 2 in conversation