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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.