Update statement

[Queryman]

I can't get this to work because the name is over 30 characters, any suggestions.

execute (update CLAIMS set MAINTENANCE_DRUG_CDE = IW_DEFLT_PRODDB_V.MEDICAL_PRODUCT_CURRENT.MAINTENANCE_DRUG_CDE
where CLAIMS.BIL_PRODUCT_SERVICE_ID = IW_DEFLT_PRODDB_V.MEDICAL_PRODUCT_CURRENT.PRODUCT_SERVICE_ID) by odbc;

I didn't want to do a join since the claims table is huge
Thanks!

QueryMan

 

[jymm]

Did you get a response to this before???

Am a bit new to the SAS part of Tek-tips, but am a long time SAS user and a long time tek-tips user.

I am running SAS 8.02 and sometimes have resorted to doing updates like this.

--- it is a bit cumbersome at times, but not too bad ---
libname DrugDB odbc
dsn=sqlserver datasrc="ODBCDrugDBName" BCP=Yes;

Data Updates;
Set DrugDB.MEDICAL_PRODUCT_CURRENT;
New_maintenance_drug_cde = Maintenance_drug_cde;
Keep Product_Service_id New_maintenance_drug_cde;

Data DrugDB.CLAIMS;
Modify DrugDB.CLAIMS Updates;
by PRODUCT_SERVICE_ID;
MAINTENANCE_DRUG_CDE =New_maintenance_drug_cde;

Run;

 

[Queryman]

Thanks

Michael