topic Re: Splitting datasets using the records in datasets as condition? in SAS Procedures

Splitting datasets using the records in datasets as condition?

HariPrasad — Wed, 24 Apr 2013 14:30:33 GMT

Hi,

I am new to this forum and struggling with this query most of the SAS experts weren't able to provide me a solution yet. Any help will certainly be appreciated.

Ex: Assuming a dataset with only variable - Dummy_records which has data in chunks.

What i would like here is the datasets has to be split in to two and condition is the special observation in them - From the below table

Dataset 1 should have the records John, Joseph, Mark & Antony (pulling the records between CMSTART & CMEND)

Dataset 2 must have records between CISTART & CIEND (Mike, Amy & Abel)

Dummy_records
CMSTART
John
Joseph
Mark
Antony
CMEND
CISTART
Mike
Amy
Abel
CIEND

Probable approach i could think of -

1. A condtion such as between in SQL which could wokr for text strings (if exists)

2. Insert a flag to differeniate CM records and CI records.

Please let me know if anymore information is required.

Thanks,

Hari Prasad

Re: Splitting datasets using the records in datasets as condition?

DBailey — Wed, 24 Apr 2013 14:34:31 GMT

data DS1 DS2;

set have;

retain key;

if dummy_record = 'CMSTART' then key='CMSTART';

else if dummy_record='CMEND' then key='';

else if dummy_record='CISTART' the key='CISTART';

else if dummy_record='CIEND' then key='';

else do;

if key='CMSTART' then output ds1;

else if key='CISTART' then output ds2;

end;

run;

Re: Splitting datasets using the records in datasets as condition?

HariPrasad — Wed, 24 Apr 2013 18:53:24 GMT

Thanks a lot DBailey the code is working fine.

Much appreciated with the immediate solution