convert to ISO 8601 date

[Vijay77]

Hi There,

           i have a date variable in below format how to convert it to ISO 8601 date format

B_date

22AUG19:18:39:28
31AUG19:08:42:53
09SEP19:19:21:23

[ed_sas_member · Accepted solution]

Hi @Vijay77 

Something like this ?

data;
	input B_date:datetime16.;
	format B_date E8601DT.;
	datalines;
22AUG19:18:39:28
31AUG19:08:42:53
09SEP19:19:21:23
;
run;

Capture d’écran 2019-12-17 à 12.30.32.png

https://documentation.sas.com/?docsetId=leforinforref&docsetTarget=p0jd9jaqmxd2ezn1kncmpgfqcpiz.htm&...

[Vijay77]

need to create a new variable C_date and add B_date Values to C_date variable

[ed_sas_member]

Hi @Vijay77 

Could you please clarify your request by providing sample data and desired output?

Thank you!