|
Hi
I have an audit trail table with 20 columns.
I need to create a record that only update 3 fields. May i know how
can i do that ?
I am trying to do something like (if the statement permits):
proc sql;
Insert into Trail
set Error_Msg = 'Missing Parameter',
(CUSTID,TestID) = (select Distinct CUSTID,TESTID from MISSING)
run;
instead of :
proc sql;
Insert into Trail
select '',''.....'', 'Missing Parameter',CUSTID,TestID
from MISSING;
run;
Reason being the Trail stucture keeps changing and i do not wish to
change the SQL statement everytime when there is a change.
Thanks
Boon Yiang
| 
