Hi, I need Carriage Return help please.
I'm running a SAS program that puts data into an Excel Template. I query a SQL table, use RETAIN, and then LABEL the data. All of this works as intended and has for years. What I need now is to get this one particular LABEL to incorporate a Carriage Return so the words in parenthesis "(Display)" are put on the second line of the Excel Cell.
Section of Current Code:
LABEL HEDIS_COLON_GAP ='Colorectal Cancer Screening (Display)' ;
I tried this but it didn't work:
LABEL HEDIS_COLON_GAP ='Colorectal Cancer Screening' ||'0D'x || '(Display)' ;
Thanks,
Mike