Multiple data sets needs to be created from Raw data based on a condition

[Hima]

MuI need to create 3 data sets from the below raw data.

COL1  COL2 COL3 COL4

111      111   DDD  EEE

222      111   RRR  TTT

BAT       23

124      158   FFF  FFF

444      454   MMM  MMM

BAT       26

555       121   LLL  TTT

122       158   JJJ  MMM

BAT       33

My first data set should be as follows

COL1  COL2 COL3 COL4

111      111   DDD  EEE

222      111   RRR  TTT

BAT       23

My second data set should be as follows

COL1  COL2 COL3 COL4

124      158   FFF  FFF

444      454   MMM  MMM

BAT       26

My third data set should be as follows

COL1  COL2 COL3 COL4

555       121   LLL  TTT

122       158   JJJ  MMM

BAT       33

So the data set seperator here is the word BAT. I need to create data set of such records that are above the word BAT.

[Haikuo · Accepted solution]

Hi,

Hash() seems to have an edge in term of dynamic outputting dataset:

data _null_;

length col1-col4 $8.;

  if _n_=1 then do;

  dcl hash h(ordered :'a');

h.definekey('n');

h.definedata('col1', 'col2', 'col3', 'col4');

h.definedone();

end;

do until (col1='BAT');

infile cards truncover;

input (COL1 COL2 COL3 COL4) (:$8.);

n+1;

h.add();

end;

flag+1;

h.output(dataset: 'w'||strip(put(flag,best.)));

h.clear();

cards;

111 111 DDD EEE

222 111 RRR TTT

BAT 23

124 158 FFF FFF

444 454 MMM MMM

BAT 26

555 121 LLL TTT

122 158 JJJ MMM

BAT 33

;

Regards,

Haikuo

Edit: you need to replace 'cards' with your physical file name or reference.