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

I think you are missing DEFINE statement usage options (eg. DISPLAY); Do you have a clean log?  See the modification below and try it.  define date_asof / "As of Date" f=weekdate17. width = 10 display; define ATM_results / "ATM Results" f=comma10. width = 10 display; ... View more