Also do not indent lines of data.  Do yourself a favor and remember to also not indent the DATALINES; (aka CARDS;) statement that starts the block of data lines because the editor has a nasty habit of automatically indenting the next line to match the indent of the line before it. ... View more

Very nice and fun! ... View more

Thank you all for the responses. Keshan and Reeze's responses are brainstorming. Keshan's code works well when there is no liternal names in the sheet names. When there is $ in the sheet name, PROC COPY (or COPY statement in PROC DATASETS) generate error message. I ended up using proc sql to create a series of macro variables using where statement to select the sheet name contains "F". It works well so far. Thanks! ... View more