I am working in SAS to manipulate a dataset that I will export into word.
Right now, my address variable is written as a single line; for example:
Address="123 Apple Way Anytown, NY 12345"
I would like to modify the format so that when it exports into excel, it will appear in the same cell, across two lines. In other words, I would like to force a carriage return so that the address appears as:
123 Apple Way
Anytown, NY 12345
Any thoughts are greatly appreciated! Thanks in advance.
This works for me (in SAS Studio, reading the spreadsheet back in via Apple's Numbers😞
libname xl xlsx "&_sasws_/test.xls";
data xl.test;
a = "123 Apple Way Anytown, NY 12345";
b = catx('0d0a'x, scan(a, 1, ','), scan(a, 2, ','));
output;
run;
libname xl clear;
Alternatively, and this seems to work too:
b = tranwrd(a, ',', '0d0a'x);
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.