Hello, Warning: I am a SAS Novice so advanced help will not help me, if that makes sense. I have spent hours googling trying to figure this out and would like to ask for help! Goal: I am trying to parse out a spreadsheet with data from many US states into separate spreadsheets, with a separate spreadsheet for each state. My data source spreadsheet has variables are Location, Cost, etc, etc. State. State is what I am dividing out by. I am not yet advanced enough to learn how to do macros/SQL, so I am okay with having 50 export statements (1 for each state). My goal here is to make it so SAS does not export/create a spreadsheet if a state does not appear in Testdata.xlsx. Right now my code creates a spreadsheet for states even if they do not appear under the variable name/column header 'State' in Testdata.xlsx. So if my spreadsheet has 10 rows/obs of data, each one for a different US state, I end up creating 50 total exports, of which 40 are useless. This is what I have so far: PROC IMPORT OUT = Work.Separate datafile="\\Test\Testdata.xlsx" dbms=xlsx replace; sheet="Sheet1"; getnames=yes; run; %let today=&sysdate; data AL; set Work.Separate; if State='AL'; proc export data=AL outfile="\\Test\AL &today..xlsx" dbms=xlsx replace; run; data AZ; set Work.Separate; if State='AK'; proc export data=AK outfile="\\Test\AK &today..xlsx" dbms=xlsx replace; run; Thank You!! Joseph
... View more