creating a unintialised variable

mj5 — Mon, 04 Dec 2017 08:40:22 GMT

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.

Re: creating a unintialised variable

RW9 — Mon, 04 Dec 2017 09:22:53 GMT

Same old, same old. These types of questions get asked daily. First off, why are you doing this in macro at all? Macro does not do anything other some text replace function. That mass of unwieldy code resolves to one simply datastep;

data inc;
  set adam.adsl;
  array v{5} usubjid sex race age weightbl;
  do i=1 to 5;
    if vvname(v{i})="actarm" then do;
      ...;
    end;
    else do;
      ..;
    end;
  end;
run;

As for why the text generated is UUSUBJID_USE, well look at:

%let LstCols  = %quote(USUBJID SEX AGE RACE WEIGHTBL);

And:

%let LstCols_u=%sysfunc(tranwrd(&LstCols,SUBJID,USUBJID_USE));

So when you replace U<SUBJID> with USUBJID_USE, you get UUSUBJID_USE.

topic Re: creating a unintialised variable in SAS Programming

creating a unintialised variable

Re: creating a unintialised variable