I'm working in a User Written transformation in DI Studio. It has a DATA &_output step with the following statement: report_date = intnx('weekday', today(), -1);
The output work table has a column called report_date, which the value for the variable report_date appears in (as 03DEC2012).
If I want the User Written transformation to output TWO values to the report_date column, how do I do it? I basically need it to output both report_date = intnx('weekday', today(), -1); AND report_date_saturday = report_date +1; to the report_date work table column if run on a Monday (so that it outputs the date of Friday and Saturday).
If the job is run on 10DEC2012, the output work table should look like this:
report_date
30NOV2012
01DEC2012
Thanks for your time.
You need an output statement after each assignment.
You need an output statement after each assignment.
Whenever I try using the output statement, I get an error saying "ERROR 455-185: Data set was not specified on the DATA statement". The data step is data &_output;
Is it forbidden to use output inside an &_output data step, and if so, is there an alternative?
UPDATE: Nevermind, figured it out, thanks.
what is the solution for this? I'm having the same issue. What did you figure out?
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 25. 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.