Great article! I have imported an excel spreadsheet via SAS EG but unfortunately the column names and formats do not match the existing SAS dataset that I would like to append it to. The spreadsheet has 50 columns. I know you can copy the name of columns and their formats to a clipboard. I was hoping there was a way in EG to paste the clip board into properties of a table in order to modify that tables columns and formats.