Data step code to output two user-written values to the same work table column

[EinarRoed]

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.

[LinusH · Accepted solution]

You need an output statement after each assignment.

[EinarRoed]

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.

[christinagting0]

what is the solution for this? I'm having the same issue. What did you figure out?