topic Re: SAS DI parameters to retrieve date9. in SAS Data Management

SAS DI parameters to retrieve date9.

R_Chung — Wed, 27 Sep 2017 13:27:53 GMT

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

Re: SAS DI parameters to retrieve date9.

LinusH — Wed, 27 Sep 2017 14:46:17 GMT

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?

Re: SAS DI parameters to retrieve date9.

Chines — Wed, 27 Sep 2017 19:20:19 GMT

I would recommend that, in a transformation before the Loop, you convert the numeric fields to character fields, and map those character fields to the parameters in the Loop.

e.g.

Name: date_from_char
Expression: put(date_from, date9.)
Format: $9.
Length: 9

Re: SAS DI parameters to retrieve date9.

R_Chung — Thu, 28 Sep 2017 00:31:59 GMT

It is the same date9.

Re: SAS DI parameters to retrieve date9.

R_Chung — Thu, 28 Sep 2017 02:55:09 GMT

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

Re: SAS DI parameters to retrieve date9.

R_Chung — Thu, 28 Sep 2017 03:57:01 GMT

I solve it by adding following code in the loop transformation:

data _null_;
call symputx('date_from', put(&date_from, date9.));
run;

reference:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000195834.htm