How to create data subset?

letsdoit — Thu, 14 Nov 2013 16:56:54 GMT

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!

Thanks!!!

Re: How to create data subset?

ballardw — Thu, 14 Nov 2013 17:07:03 GMT

Something like this may get you started:

data Notes

Taxable

NewMainData;

Set maindata;

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;

run;

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.

topic How to create data subset? in SAS Programming

How to create data subset?

Re: How to create data subset?