topic Re: convert to ISO 8601 date in SAS Programming

convert to ISO 8601 date

Vijay77 — Tue, 17 Dec 2019 11:22:16 GMT

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 — Tue, 17 Dec 2019 11:32:47 GMT

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;

Vijay77 — Tue, 17 Dec 2019 12:07:23 GMT

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

ed_sas_member — Tue, 17 Dec 2019 12:09:27 GMT

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

Thank you!