Hi. This message ... NOTE: Argument to function VVALUEX is not a valid variable name: . NOTE: Invalid argument to function VVALUEX at line 23 column 8. Weeks= Prices= desc=Insurance Track state=GA Chevy=1200 GMC=4300 Honda=3000 miles=High Mileage Cars _p= _ERROR_=1 _N_=1 occurs since for one of the observations in TABLE2, the value of the variable variable PRICES (renamed _P and used as the argument in the VVALUEX function) is MISSING. You could modify the code (not sure what the RETAIN was for) ... data want; if _n_=1 then set table1; set table2(rename=prices=_p); if ^missing(_p) then prices=vvaluex(_p); keep Weeks Prices desc; run;
... View more
