topic Re: Create carriage return and preserve when export to Excel in SAS Programming

Create carriage return and preserve when export to Excel

Miracle — Thu, 25 Jun 2020 16:53:00 GMT

Dear SAS users,

I would like to have only one observation row for every distinct format reading from a format dataset by inserting a carriage return for every value of the format.
Thereafter, export to Excel with carriage return preserved.
I tried 'OD'x in the datastep but it is not working.
Can anyone please guide me on this?
Thanking you in advance and have a nice day.

Re: Create carriage return and preserve when export to Excel

ballardw — Thu, 25 Jun 2020 16:57:58 GMT

Please show the code you used.

You may have to provide a small example of the data used as well.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

Re: Create carriage return and preserve when export to Excel

Reeza — Thu, 25 Jun 2020 17:00:08 GMT

What are you trying to do here overall?