10-27-2016 04:05 AM
There are various fixes you can try. @Reeza has provided one above by adding titles in for the four blank lines. If you want variable names on the first line and data four after that then add blank rows to the dataset.
Generally if I need to do anything in Excel - it being nothing like any proper data capture/manipulation software - I would use Excel to do it. Export data from SAS as CSV - very simple. Then in Excel write some VBA which opens the CSV and puts/processes the data exactly as needed in that file (note the VBA does not need to reside in the same file). Although I would generally avoid Excel unless it was absolutely necessary. Why do you need it to start there? Do you have a template file or something (more reason to use VBA)? If not then starting at A1 would seem like the most sensible method.