I have the following list of id numbers in a SAS dataset:
1000
1000
2000
3000
3000
3000
I want to write out the dataset and put a blank line in between each group of ids i.e.
1000
1000
2000
3000
3000
3000
Searching online I keep find the "blankline" option but this inserts a blank line every n rows - which doesn't work for me as the number of rows for each id varies. I have tried the "by" option but it creates a new worksheet for each id and I need to have all the ids in the same worksheet.
Thanks!