I want to build up a space-delimited from macro variables.  Something like this:   %macro doesntwork; %let first = thing1; %let second=thing2: %let result=%SYSFUNC(CATX(" ",&first.,&second.)); %mend;   What I want is: thing1 thing2   The above doesn't work because it gives me thing1" "thing2.  Putting a naked space character as the delimiter causes an error.  Using %str( ) also causes an error.   How do I do this? ... View more

I have my local Excel set to default to Arial 10 for new workbooks.  My preferred style for ODS EXCEL output is JOURNAL2.  Whenever I send procedure output to a spreadsheet, the cells with content in them are Arial 10 with a reasonable alignment for the type of content.  However, all of the empty cells in the spreadsheet are set to Courier 8, left alignment.  This is irritating if I need to modify the spreadsheet after SAS is done with it.   Is SAS causing this?  Excel?  Is there something I can do on the SAS end to make sure that the entire worksheet is set to Arial 10 with general alignment?    I am using SAS 9.4.TS Level 1M4 Windows version 1.0.17763.   Dav Vandenbroucke ... View more

Is there a complete list of SAS procedures that support multilabel formats?  Today I'm interested in SURVEYMEANS, but tomorrow it could be another one. ... View more

I am trying to take a list of text items associated with key values and concatenate them into semicolon-delimited lists.  Instead, I'm getting lists of semicolons only.  I can't figure out what is going wrong.  This is SAS 9.4 for Windows.     ODS HTML; DATA HAVE; INPUT Key $ 1 Text $ 3-20; CARDS; A Alpha One A alpha two A Alpha 3 B bee one C See me C See you ;;; RUN; PROC SORT DATA=Have; by Key; run; PROC PRINT; TITLE Have; RUN; DATA NotWhatIWant (KEEP=Key List); SET HAVE; BY Key; LENGTH List $50; RETAIN LIST; IF first.key THEN LIST = ' '; LIST = CATX(List,';',Text); IF LAST.KEY THEN OUTPUT NotWhatIWant; RUN; PROC PRINT DATA=NotWhatIWant; TITLE Not What I Want; RUN; ODS CLOSE;                                         ... View more