Is this being done in a single data step?
If so then make a simplified version so you are clear how to to read from TWO input files and write to TWO output files in a single step.
So you need FOUR files. You can define four DDNAMES in your JCL (or have four FILENAME statements in your SAS program). Two are DISP=OLD or DISP=CATLG since they already exist. Two are DISP=NEW since you are making them.
Personally if I was reading from two input files the code would look something like this:
* Get data from the first file;
data one;
infile in1;
input ....;
run;
* Get data from the second file;
data two;
infile in2;
input ....;
run;
* Some step(s) that combined ONE and TWO into THREE ;
* Write data from the resulting dataset back out;
data _null_;
set three;
if condition='normal' then do;
file out1;
put .... ;
end;
else do;
file out2;
put .... CONDITION ;
end;
run;
If that is not how your current SAS code works then explain your data flow in more detail. (Or perhaps just change this step to work that way for simplicity.)
Let's make a trivial example. So your current process is writing a TEXT file that has variables NAME, AGE, SEX, AGE, HEIGHT and WEIGHT (so it matches SASHELP.CLASS). Your process has changed and you now have data that includes a new variable named FLAG. You want to continue to write the same 6 variables to the same output file. But you want to skip the observations where FLAG=1. And instead you want to write those observations to some other new data file with a new structure.
Let's call the original target file OLD and the new file (for the skipped observations) NEW. So your original program might look like this. You make some dataset that you want to write. Then you write it.
1 * Original code;
2 data analysis;
3 set sashelp.class;
4 run;
NOTE: The data set WORK.ANALYSIS has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
5 data _null_;
6 set analysis;
7 file out;
8 put name $8 sex $1 age 3. Height 7.2 weight 7.2 ;
9 run;
NOTE: The file OUT is:
(system-specific pathname),
(system-specific file attributes)
NOTE: 19 records were written to the file (system-specific pathname).
The minimum record length was 18.
The maximum record length was 18.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The new process will look like this. The step that makes the analysis step has changed. It now adds a new variable. Let's call it flag. And the step that writes the file out now needs to write two files based on the value of FLAG.
11 * New code;
12 data analysis;
13 set sashelp.class;
14 flag = (sex='M');
15 run;
NOTE: The data set WORK.ANALYSIS has 19 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
16 data _null_;
17 set analysis;
18 if flag=1 then do;
19 file out;
20 put name $8 sex $1 age 3. Height 7.2 weight 7.2 ;
21 end;
22 else do;
23 file new;
24 put name $8 sex $1 age 3. Height 7.2 weight 7.2 flag 1. ;
25 end;
26 run;
NOTE: The file OUT is:
(system-specific pathname),
(system-specific file attributes)
NOTE: The file NEW is:
(system-specific pathname),
(system-specific file attributes)
NOTE: 10 records were written to the file (system-specific pathname).
The minimum record length was 18.
The maximum record length was 18.
NOTE: 9 records were written to the file (system-specific pathname).
The minimum record length was 19.
The maximum record length was 19.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
So you can check the NOTES that SAS generates to make sure that the right number of lines have been written to each file.
Click image to register for webinar
