I frequently have layouts of text files or lists of variable values I need formatted in an Excel spreadsheet. I find that simply using the Excel CONCATENATE function that allows me to to write out the SAS code in Excel and then drag that formula down throughout the entire workbook is a very fast way to generate the SAS code I need. I just click on the Excel column in which I generated the SAS code and paste it into SAS.

This works for much more than format statements.