Hi  Do you have procedure_name data to show here? There might be multiple reasons the function is not giving the expected results.  Your current code assumes that the searched word comes first in the string in procedure_name variable without preceding spaces.  If this assumption is true then try adding STRIP() function to your existing code.  if index(lowcase(strip(procedure_name)), "defibrillator")=1 then pro_icd=1; If the string doesn't start with the searched word you can use FIND function instead. It gives you 1 if true, and the condition works.   if find(lowcase(procedure_name), "defibrillator")=1 then pro_icd=1;   ... View more

data have; input id $ dt:yymmdd10. test $; format dt date11.; datalines; ABCDE 20100429 T1 ABCDE 20100429 T2 ABCDE 20090908 T1 ABCDE 20090908 T2 ABCDE 20210823 T1 ABCUK 20191008 T1 ABCUK 20191008 T2 ABCUK 20230723 T1 ; data want; set have ; by id dt notsorted; retain NEW_ID; if first.id and first.dt then NEW_ID=1; else if not first.id and first.dt then NEW_ID+1; if not (first.dt and last.dt) then doc_id= catx('-', id, new_id); drop new_id; run;   ... View more

Hi You are using RETAIN statement. When the condition is met ( nAtBat =321) b321 is set to 1 and RETAIN statement then retaining 1 as an initial value of b321 at each iteration of data step. Without RETAIN statement, b321 would be missing (.) where the condition is not met. If you need b321=1 only when  nAtBat =321, then just remove RETAIN statement.    data bb; set sashelp.baseball; if nAtBat=321 then b321=1; run;   ... View more

You probably get notes liek this : "NOTE: Invalid numeric data, 'NA' , at line 49 column 27".  You just missed to declare the datatype of the new variables. You need a character variables, so $x needs to be declared in front of the new variables created by array.  See the below: data want ; set df1; array _invars{3} a b c; array _invals{3} $8 _inval1 _inval2 _inval3; do i=1 to 3; if _invars{i} gt .z then _invals{i}=put( _invars{i},5.2) ; else _invals{i}= "NA" ; end; run ; ... View more

SQL, Group BY clause. proc sql; create table want as select*, max(count) as n_count from dataset_have group by id order by 1, 2; quit; ... View more

data _null_; thisdate=today(); rptdate = (today()+1); format rptdate date9.; if (thisdate<rptdate) then put "WARNING: future RPTDATE. rpdate=" rptdate; run; ... View more

You don't need %str macro function there, there is nothing to mask.  E.g. %let ren= (age=age_group sex=sex_group height=height_group); %put &=ren; data have; set sashelp.class (rename=&ren); run; 1 %let ren= (pbp_a_hnumber=H_Number pbp_a_plan_identifier=Plan_ID 1 ! segment_id=Segment_ID); 2 3 %put &=ren; REN=(pbp_a_hnumber=H_Number pbp_a_plan_identifier=Plan_ID segment_id=Segment_ID) 4 %let ren= (age=age_group sex=sex_group height=height_group); 5 6 %put &=ren; REN=(age=age_group sex=sex_group height=height_group) 7 data have; 8 set sashelp.class (rename=&ren); 9 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.HAVE has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds I would double check the syntax.  As you see in example above equal signs passes into macro var without issue.    ... View more