Convert numeric value to date in VA Exploration 7.3

jcrittenden — Tue, 06 Jun 2017 22:02:41 GMT

I get the following results when trying to convert numeric to date using TreatAs in VA Exploration. Any suggestions?

Thanks, Jane

Re: Convert numeric value to date in VA Exploration 7.3

BrunoMueller — Wed, 07 Jun 2017 07:18:21 GMT

If possible, I would change the datasource, so that the value is already a proper date. If this is not possible, you can use the Format and Parse Operators to convert it like so

Parse(Format('someDate'n, 'BEST8.'), 'ANYDTDTE8.')

The TreatAs will convert a numeric value representing a SAS date to a date

topic Re: Convert numeric value to date in VA Exploration 7.3 in SAS Visual Analytics

Convert numeric value to date in VA Exploration 7.3

Re: Convert numeric value to date in VA Exploration 7.3