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
... View more