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!!!
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.