BookmarkSubscribeRSS Feed
letsdoit
Fluorite | Level 6

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!!!

1 REPLY 1
ballardw
Super User

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 286 views
  • 0 likes
  • 2 in conversation