is there a way to identify maximum variable in a list i have the below variables and i need to identify first and last i.e c_1 and c_5. is there a way to check it? idno value c_1 c_2 c_3 c_4 c_5 ... View more

I am using the below code and somehow it creates UUSUBJID_USE which is not available and gets unintialised variable. Not sure from where it is creating. can any one help me to debug it. %macro inhc; %let LstCols = %quote(USUBJID SEX AGE RACE WEIGHTBL); %let totval=%eval(%sysfunc(countc(&LstCols,%str( )))+1); %let LstCols_u=%sysfunc(tranwrd(&LstCols,SUBJID,USUBJID_USE)); %let LstCols_use=%sysfunc(tranwrd(&LstCols_u.,RACE,RACE_USE)); data inc; set adam.adsl; %do i=1 %to &totval; %if %upcase(%scan(&LstCols_use,&i)) eq %upcase(actarm) %then %do; patinf=catx("/",patinf,actarm); if _n_=1 then patlbl=catx("/",patlbl,"treatment"); %end; %else %do; patinf=catx("/",patinf,(%scan(&LstCols_use,&i))); if _n_=1 then patlbl=catx("/",patlbl,vlabel(%scan(&LstCols,&i))); %end; %end; run; %mend; %inhc; attaching test data. Log: UUSUBJID_USE=. patlbl=. RACE_USE=. _ERROR_=1 _N_=19 NOTE: Over 100 NOTES, additional NOTES suppressed. NOTE: Invalid numeric data, './.' , at line 3 column 25. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. ... View more

I am using the below code that is if suppvar_list has no observation than use the first condition and if it has then second one but it fails ERROR: There is no matching %IF statement for the %ELSE. ERROR: A dummy macro will be compiled. %let suppvar_list=; %if &suppvar_list. ne %then %do; %do j = 1 %to %sysfunc(countw(&suppvar_list.)); %end; %else %do; %do j = 1 %to %sysfunc(countw(&suppvar_list,%str())); %end; %let curr_var = %scan(&suppvar_list., &j.); if not missing(&curr_var.) then do; QNAM = upcase(vname(&curr_var.)); %end; .   AM i doing anything wrong  ... View more

 I have hash object datastep and in that need to create a variable like domain="SE" but it is not happening. any reason where i did something wrong. any guidance? data se; set startdates; by usubjid descending startdate descending taetord element; if _n_=0 then set enddates raw.ta; if _N_ = 1 then do; declare hash lastdate(dataset:"enddates"); lastdate.definekey("usubjid"); lastdate.definedata("dsendtc"); lastdate.definedone(); declare hash Tarm(dataset:"raw.TA"); Tarm.definekey("ETCD"); Tarm.definedata("EPOCH"); Tarm.definedone(); end; length oldstart $20; retain oldstart; SESTDTC=scan(DSSTDTC,1,'T'); rc1=Tarm.find(); if not first.usubjid then do; SEENDTC=scan(oldstart,1,'T'); end; else do; rc=lastdate.find(); if rc=0 then SEENDTC=scan(DSENDTC,1,'T'); end; if missing(sestdtc) and not missing(seendtc) then delete; if SEENDTC>SESTDTC or first.usubjid then output; oldstart=DSSTDTC; rename TAETORD=SESEQ; domain='SE'; drop rc rc1 dsstdtc startdate enddate domain tatrans tabranch oldstart dsendtc arm armcd TESTRL; run; ... View more

I have a dataset as below PT     N 102   25 103   34 Total   .   I need to replace the missing with the sum of the 2 counts in N. Can i do that in datastep?   ... View more