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);
... View more
