Ah yes adding the $ does make it 32. if you are happy with using VBA, then you could simplfy your process by using VBA to create a CSV file of all the data, do loop over sheets in workbook, then for each dump out the data to a text file separated by commas, and have another column for sheet name. I.e. you then get one CSV file with all the data and sheetname as a column. Avoids fidlly programming in SAS and simplfies your import code to only be one datastep read CSV.
... View more