Hello SAS community,   I have a dataset with a variable number_images with values 1 or 2 which indicate whether an image was read for a bunch of variable (n=110) at T0 or/and T2 this is what I get from proc freq number_images nmissT0 nmissT2 1 0 110 1 1 110 1 2 110 1 3 110 1 4 110 1 5 110 1 6 110 1 7 110 1 8 110 1 9 110 1 10 110 1 12 110 1 14 110 1 15 110 1 18 110 1 31 110 1 93 110 1 110 0 1 110 1 1 110 2 1 110 6 1 110 10 1 110 12 1 110 13 1 110 14 2 0 0 If number_images=1, the image could have been read at either of the timepoints. I want to keep number_images =1 but be able to distinguish those with readings at T1 or T2 only if nmissT0=110 then the images was only read at T2 if nmissT2=110 then the images was only read at T0 if nmiss is <110, then the image was read at least for some features at one timepoint- not concerned with that part for this question   I would like to update number_images to have something like this but I know this won't work proc format; value n_imagf 1="1: V0 readings only" 1="1: V2 readings only" 2="2: V0, V2 readings" What can I do instead so number of images still shows 1 and is numeric? if number_images=1 and nmissT0=110 then number_images=1??   Can anyone help? Thanks, Maggie   ... View more

Hello SAS community, I have variables with the following original format proc format; value s 0 ="Never/almost Never" 1 ="Once in a while" 2 ="Some days" 3 ="Most days" 4 ="Everyday" 5 ="Many times/day" . ="Unknown"; I'm now being asked to do reverse formatting for a bunch of variables /*1 = many times a day, 2 = every day, 3 = most days, 4 = some days, 5 = once in a while, 6 = never*/ data have; input id strngth peace beauty prscnc union love; cards; 1  0 1 2 3 4 5 2  4 0 0 1 3 4 3  4 2 3 2 5 0 4  2 4 4 0 2 3 5  0 3 5 0 0 1 6  3 5 1 4 3 4 7  5 2 3 2 1 0 8  3 2 2 5 2 1 9  5 1 3 2 1 0 10 4 0 0 1 3 4 11 0 2 3 2 5 0 12 2 4 4 0 2 3 ; run;   data have2; set have; format strngth peace beauty prscnc union love s.; run;    proc freq data=have2; title 'orig'; tables strngth / list missing; run; proc format; value sr 6 ="Never/almost Never" 5 ="Once in a while" 4 ="Some days" 3 ="Most days" 2 ="Everyday" 1 ="Many times/day" . ="Unknown"; run; data want; set have2; if strngth = 5 then strngth2 = 1; else if strngth = 4 then strngth2 = 2; else if strngth = 3 then strngth2 = 3; else if strngth = 2 then strngth2 = 4; else if strngth = 1 then strngth2 = 5; else if strngth = 0 then strngth2 = 6; else strngth2 = .;   format strngth2  sr.; run; but I'm getting the following for recoded - unable to copy in both tables: original strngth Frequency Percent Cumulative Frequency Cumulative Percent Never/almost Never 3 25.00 3 25.00 Some days 2 16.67 5 41.67 Most days 2 16.67 7 58.33 Everyday 3 25.00 10 83.33 Many times/day 2 16.67 12 100.00 recoded strngth2 Frequency Percent Cumulative Frequency Cumulative Percent Many times/day 2 16.67 2 16.67 Everyday 3 25.00 5 41.67 Most days 2 16.67 7 58.33 Some days 2 16.67 9 75.00 Never/almost Never 3 25.00 12 100.00   I would like to be able to-  correctly apply the correct format to the recoded variable - I also need to keep the original format do this efficiently for a bunch of variables  Thanks, Maggie   ... View more

Hello SAS community,   I’m attempting to use a macro to add 2 new variables with content for some ids to a dataset. Below is the code and the error message from the log.   Appreciate any help, Maggie   %macro add_units_notes               (in=, out=,                list=);   data &out;               set &in;               length units $20. notes $200.;               select (lowcase(variable));                            %let list_n = %eval(%sysfunc(countw(&list,'@')));                             %do i = 1 %to &list_n %by 3;                                          %let name = %scan (&list,&i,'@');                                          %let units = %scan (&List,%eval(&i+1),'@');                                          %let notes = %scan (&List,%eval(&i+2),'@');                                 when (lowcase("&name"))                                                        units = "&units"                                                        notes = "&notes";                            %end;                            otherwise                                          units = ""                                          notes = "";               end; run;   %mend add_units_notes;   %add_units_notes               (in=have, out=want,               list=time@minutes@@               diabp@mmHg@to the nearest 2 mmHg@               abcd@@collected on females only@);   desired output   units notes time minutes   diabp mm Hg to the nearest 2 mmHg abcd   collected on females only   SAS Log 501  %add_units_notes 502      (inDsn=s1, outDsn=s2, 503      list=time@minutes@@ 504           diabp@mmHg@to the nearest 2 mmHg@ 505           abcd@@collected on females only@); NOTE: Line generated by the invoked macro "ADD_UNITS_NOTES". 3                 when (lowcase("&name"))                 units = "&units"                 notes =                                                                                            -----                                                                                            22 3  !  "&notes"; NOTE: Line generated by the invoked macro "ADD_UNITS_NOTES". 5                 when (lowcase("&name"))                 units = "&units"                 notes =                                                                                            -----                                                                                            22 5  !  "&notes"; NOTE: Line generated by the invoked macro "ADD_UNITS_NOTES". 7                 when (lowcase("&name"))                 units = "&units"                 notes =                                                                                            -----                                                                                            22 7  !  "&notes"; NOTE: Line generated by the invoked macro "ADD_UNITS_NOTES". 9             otherwise             units = ""             notes = "";     end; run;                                                            -----                                                            22   ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=,               <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=,               |, ||, ~=.   NOTE: Character values have been converted to numeric values at the places given by: ... View more