11-14-2013 11:56 AM
Hi I have this big data set and I need to create few subsets:
1) if _market_ contains the word "notes' => then take all "notes" out to a new dataset and remove them from the main dataset
2)then if _taxable_ = "Y" => then take all taxable out to a new dataset and remove them from the main dataset
.......and so on with few more characteristics to be taken out and at the end I want to have one dataset that doesn't contain notes, taxable etc...(based on my other if statements) and then datasets where I keep separate all the once that I don't need (for example I will have a separate dataset wit "notes", another separate wit "taxable" etc...) ...so ideally I want to create 6 datasets from the main one.
Any and all help and suggestions will be great!
11-14-2013 12:07 PM
Something like this may get you started:
if indexw(upcase(_market_,'NOTES') > 0 then output Notes;
if _taxable_ = 'Y' then output Taxable;
if indexw(upcase(_market_,'NOTES') = 0 and _taxable_ ne 'Y' then output NewMainData;
I would really recommend NOT updating your original main data set until you are sure everything is working which is why I create a new Main data set.