Hi everyone.
This time, I would like to use loop transformation to pass a date9. value to another job.
In the picture,
date_from and date_to are date 9. format.
As I know, all date format are regarded as integer.
Therefore, when I set the parameter (date_from) in another job. it is also integer.
when I type %put &date_from, it gives me 20636, which is not 01JUL2016.
So what can I set to get back the value with date9. format.
i.e, %put &date_from --> 01JUL2016
Thanks
Well, 20636 is actually 01Jul 2016. It's just not formatted.
What does the logic look like that will act on this parameter?
A where-clause?
I have changed to character format but error obtained after entering the loop transformation
ERROR: Invalid date/time/datetime constant "20636"d.
Below is before entering the loop transformation:
If I change back to numeric type
It becomes normal
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.