G'day, I've many MS Excel spreadsheets (all different names of course) which I need to append into one large file. They should have all the same column names (Do I need to visually check this for each file or is there a shortcut?) How do I get all of these files form one folder on my computer into SAS and append them into one large dataset? I only know how to use Proc Import using the Wizard. Any tips you can give will be most appreciated!!! ... View more

G'day.  Appreciate any help you can give! I'm trying to subset a dataset by county (i.e, create one table with just observations from Humboldt. Then, create another table with just observations from Fresno).Then export each county-specific dataset to a MS Access Database using a Macro. I've not gotten very far. %macro table(county=); DATA Elig13<want countyname here>;     set eligibles;     if coname=<countyname here>; run; %mend; %table (HUMBOLDT); %TABLE (FRESNO); %TABLE (ORANGE); %TABLE (KERN); ... View more

Appreciate any help you can give. I have one table with facility names and some county names named Facility I have another table with all county names and email addresses named Contacts Facility table has only some county names listed in the Contacts Table so I need ultimately the email addresses from the Contacts table for only the county names listed in the Facility Table. The Facility Table has the county names listed more than once since more than one Facility is listed per county. The Contacts Table has the county name listed more than once because there's more than one contact for some counties. How do I get the email addresses for only the counties listed in the Facility Table? Facility Table County            Facility Alameda         Happy Days Contra Costa  Sunshine Daycare Contra Costa   BusyBees Inyo                 Elmwood Montessori San Joaquin    Buzy Beez etc... Contacts Table County             Email Address                  Alameda           hamwood@alameda.gov Alameda          stern@alameda.gov Contra Costa    lily@cc.gov   Inyo                 sch@iy.com Inyo                   tom@iy.com San Joaquin      kj1@sq.gov ... View more