SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI parameters to retrieve date9.

Reply
Contributor
Posts: 48

SAS DI parameters to retrieve date9.

[ Edited ]

Hi everyone.

 

This time, I would like to use loop transformation to pass a date9. value to another job.

1.jpg

 

 

 

 

 

 

 

 

In the picture,1.jpg

 

 

 

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

Super User
Posts: 5,382

Re: SAS DI parameters to retrieve date9.

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?

Data never sleeps
Contributor
Posts: 48

Re: SAS DI parameters to retrieve date9.

It is the same date9.
New User
Posts: 1

Re: SAS DI parameters to retrieve date9.

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
Contributor
Posts: 48

Re: SAS DI parameters to retrieve date9.

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:

 

 

1.jpg

 If I change back to numeric type1.jpg

 

 

It becomes normal

1.jpg

 

 

 

 

Contributor
Posts: 48

Re: SAS DI parameters to retrieve date9.

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
Ask a Question
Discussion stats
  • 5 replies
  • 155 views
  • 0 likes
  • 3 in conversation