DATA Step, Macro, Functions and more

update

Reply
Super Contributor
Posts: 673

update

When importing data, the some of zip and ndc numbers are imported as '0' instead of their values.This happened after many loads.
How do I update/replace the dataset where the zip ad ndc numbers are '0''s with their original values.I have a dataset where I have the actual values.
I tried update as follows:
data final;
update spdata(where=provider='MEDCO' and file_date='2009-04)) zip_ndc;
by patient_id;
run;

zip_ndc has three variablesSmiley Tongueatient_id zip and ndc.
When I use patient_id in the by statement , it fails saying that there are multiple values under the by group.
Super Contributor
Super Contributor
Posts: 3,174

Re: update

Possibly consider a MERGE or MODIFY. From the SAS support http://support.sas.com/ here is a technical document on the MODIFY statement in the DATA step processing. You must determine what SAS variables represent a sufficiently granular key (BY statement variable list) to perform the master file update.

Scott Barry
SBBWorks, Inc.

TS-250
DATA Step Programming Using the MODIFY Statement
http://support.sas.com/techsup/technote/ts250.html
Ask a Question
Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation