Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

is there a way to update mutiiple rows in SAS

Posted on 2011-10-28
3
Medium Priority
?
372 Views
Last Modified: 2013-11-16
I have a SAS dataset  DATA1 that has mbr_id repeated because of different data.  The dataset has a column "AH", that I would like to update with a value from another SAS dataset (DATA2).

The update statement only updates the first occurence.

Is there a way to update all of the records with a matching id?
0
Comment
Question by:morinia
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Aloysius Low
ID: 37045300
could you post the code you are using?  is it a data step?

using proc sql with a typical should do the  trick
0
 

Author Comment

by:morinia
ID: 37046736
Data Day_Care;
      Update Day_care PH;
      by mbr_id;
run;

The problem is the file Day_Care has multiples of mbr_id.  
0
 
LVL 14

Accepted Solution

by:
Aloysius Low earned 2000 total points
ID: 37049016
like i said in my previous post, do a proc sql code instead... there are differences in behaviour between a data step and proc sql...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question