topic Re: ISO8601 format in New SAS User

ISO8601 format

chinna0369 — Wed, 14 Aug 2019 22:41:48 GMT

Hi all,

I have below data:

And attributes are as below:

I would like to convert it to iso8601 character format. Could you please give me some idea how to convert this type of data into ISO 8601 character?

Thanks,

Adi

Re: ISO8601 format

ballardw — Wed, 14 Aug 2019 23:06:21 GMT

@chinna0369 wrote:

Hi all,

I have below data:

And attributes are as below:

I would like to convert it to iso8601 character format. Could you please give me some idea how to convert this type of data into ISO 8601 character?

Thanks,

Adi

Which specific ISO format? SAS has about 20 different ISO format that could be used. Look in the documentation for B8601 and E8601 formats.

Since your current value is CHARACTER likely the first step would be to get a SAS date time value using the input function and then PUT the result into a character value using the appropriate format. Or create a datetime variable and just associate the desired format. Then if you want to display the value as something else you may only need to change a format and not modify the data set.

Re: ISO8601 format

chinna0369 — Wed, 14 Aug 2019 23:17:27 GMT

Thank you for your reply!

Can you give me some example code by using b8601.

Thanks,

Adi

Re: ISO8601 format

Cynthia_sas — Wed, 14 Aug 2019 23:52:04 GMT

Here's an example. As you can see, a numeric variable formatted with the ISO format and a character variable created using the same format both look the same. I consider it a best practice to always store dates as numeric variables and control the display with a FORMAT statement. Dates stored as character strings are rarely useful.

Hope this helps,

Cynthia

Re: ISO8601 format

chinna0369 — Thu, 15 Aug 2019 00:11:52 GMT

Thank you so much Cynthia_sas

Re: ISO8601 format

chinna0369 — Thu, 15 Aug 2019 00:22:12 GMT

Hi Cynthia,

Right now we are getting date as below:

what do I need to use if want to get as below?

Thanks,

Adi

Re: ISO8601 format

Cynthia_sas — Thu, 15 Aug 2019 03:42:12 GMT

Hi:

I'm not on a machine where I can do documentation right now. You can look in the list of formats for the right format to get the date the way you want.

cynthia

Re: ISO8601 format

ballardw — Thu, 15 Aug 2019 15:33:13 GMT

That looks like you may want the E8601DTw.d format but the shortest version of that is 19 characters and will show seconds.

If that is unacceptable you will have to create a custom format.

Re: ISO8601 format

chinna0369 — Thu, 15 Aug 2019 18:23:28 GMT

Hi all,

Thanks, I got it. I changed it to " E8601DTw.d" it looks fine to me.

Thanks,

Adithya