data one; input id par $ ady; datalines; 1 a 3 1 a 6 1 a 9 2 a 6 3 a 3 3 a 4 4 a 4 4 a 8 5 a 7 5 a 10 6 a 5 6 a 12 ; Dear    I need to create a variable 'want'  based on 'ady' variable values. If ady contains at least one of the values (3,6,9,12 or 15,18,21,24) in any record by id and par   then for the subject  want='Yes';  else want='No'   output needed; id    want 1     Yes 2     Yes 3      Yes 4      No 5      No 6      Yes     for id= 4 and 5    the subjects do not have records with values  (3,6,9,12 or 15). So want='No'.     Please suggest. Thank you   ... View more

Dear    I am getting a warning message when the the code. I am getting the output  i need .  I need to have param1 = SS-S1 SSS >= 1 1   and param2=SS-S1 SSS < 1.   Please suggest.   WARNING: The query as specified involves ordering by an item that doesn't appear in its SELECT clause. Since you are ordering the output of a SELECT DISTINCT it may appear that some duplicates have not been eliminated. Thank you data one; input a $1-14 b 16; datalines; SS-S1 SSS >= 1 1 SS-S1 SSS < 1 2 ; proc sql; select strip(put(count (distinct a), best.)) into: cntt from one; select distinct a into :param1 -:param&cntt. from one order by b ; quit; %put &param1; %put &param2; ... View more

Dear,   I need help in which function i can in this situation.   my data has values           SS-S1 SSS >= 1    and SS-S1 SSS < 1.    I need to create another variable with values                SSS >= 1 and  SSS < 1.   input data; SS-S1 SSS >= 1 SS-S2 SSS < 1     output needed SSS >= 1 SSS < 1   Please suggest. Thank you     ... View more

Dear,   I need help on how to get a variable label name in to macro variable.   data one; input age Ageu $; datalines; 12 Y ;   Suppose the age variable label is 'age in years'. I need to create a macro variable with label value.   %let want=;   output needed; want='age in years'.  Please suggest. Thank you   ... View more

Dear,   I need help in my proc sql code. When i run the sql code, the output i am getting for the macro variables is &treat1     Total &treat2;       a1 &treat3;       b1 .  The output I need is  &treat1     a1 &treat2;       b1 &treat3;       Total   For treat1   I need a1 value, for treat2   the  value b1, treat3 the value sould be total.  Please suggest. In the sql code i tried trtn variable in the order variable, but i got error. data sl; input trt $1-5 trtn 7; datalines; a1 1 b1 2 Total 3 ; proc sql noprint;**added for table header; select strip(put(count (distinct trt), best.)) into: cnt from sl; select distinct trt into :treat1 -:treat&cnt. from sl order by trt; quit; %put &treat1; %put &treat2; %put &treat3;   ... View more

Dear,   In a macro i am trying to resolve the following unicode value.   ods escapechar='^'; %let title_1=%str(subject have ^{unicode 2265}1); title=%sysfunc(tranwrd(%superq(title_1),|,%str(\par ))); the resolved value of title variable should be =subject have ≥1 but the resolved value of title is=subject have ^{unicode 2265}1.   The error i am getting is Literal contains unmatched quote.   Please suggest how to resolve this. Thank you   ... View more

Dear   I need to split a macro variable value into two macro variables. For this statement i am expecting aaaa+ for first obs . But i am getting "substrn(aaaa+bbbbb,1,find(aaaa+bbbbb,'+'))".   Please suggest. data one; input a $10.; datalines; aaaa+bbbbb cccc+ddddd ; %global treat1 treat2; proc sql noprint; select strip(put(count (distinct a), best.)) into: cnt from one; select distinct a into :treat1 -:treat&cnt. from one order by a; quit; %global treatt11; %let treatt11=%substrn(&treat1.,1,find(&treat1.,'+')); %put &treatt11.; ... View more

Dear,   Please suggest why the macro 'want' is not executing. I need to output data set 'two'.  Thank you data one; input a $10.; datalines; aaaa+bbbbb cccc+ddddd ; %global treat1 treat2; proc sql noprint; select strip(put(count (distinct a), best.)) into: cnt from one; select distinct a into :treat1 -:treat&cnt. from one order by a; quit; %put &treat1.; %macro want; %if %index(&treat1.,'+')>0 %then %do; data two; set one; run; %end; %mend; %want; data set ... View more

data one; input a $10.; datalines; aaaa+bbbbb cccc+ddddd ; data two; set one; b=scan(a,1,'+'); c=scan(a,2,'+'); run; Dear,   For the above data step, i need to output for b and c vaiables as below.  The delimiter should also be included in first word. Please suggest.    b                      c aaaa+            bbbbb cccc+             ddddd ... View more