In SAS VA I was trying to create a certain date format, but I can't get it to work.
By creating a calculated field, I can change the date format into DDMMJJJJ, but it shows DD/MM/YYYY and not the Dutch format DD-MM-YYYY.
Is there anyone that can tell me if this can be fixed and if so, how it can be done?
Thanks in advance.
It might be a bit unorthodox, but this worked for me:
Hi xangadix,
It would be helpful to see the formula you use in the calculated item.
Some thoughts:
If this doesn't solve it, can you please post more info?
Thanks!
Lodewijk
Thanks Lodewijk, I'll give that REPLACE idea a try tomorrow.
If that doesn't work out, I'll post more info.
Also be sure to check out this article about using dates in parameters: Date parameters in SAS Visual Analytics
Since there's no option to have a true date in a parameter, you have to use tricks to use numeric and/or character parameters. The article is about these tricks, where the Format, Replace and Parse functions in conjunction with date formats solve the issue.
Best regards,
Lodewijk
It might be a bit unorthodox, but this worked for me:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.