Hi dfanella, The easy way to do this is to use multiple output statements to create multiple datasets. Let me give you a really simple example. Using a Data statement you can: Data USA Australia Other; Creates three data sets that you will fill with data set Kathy.AllSavings; from the AllSavings data set select(upcase(Country)); This just capitalizes the Country code If Country="US" then output USA; This looks for the variable I chose to define the dataset USA else if Country="AU" then output Austrialia; This looks for the variable I chose to define the dataset Austrialia else output other; This is the dataset that data goes to if it does not land in any other dataset. run; You should always have an "Other" dataset, and you can break it out to as many datasets as you like.
... View more