BookmarkSubscribeRSS Feed
sas_
Fluorite | Level 6

Hi i am having main table the incre table append to the main table
but while appending to the Main table based on pid and dt it should remove the older one
ex in main table pid a1 is there again in incr table again pid with a1 came but with diff no
so it should append to main table and remove the older one based on date

Main Table

Pid no Dt
a1  1  12jan2011
a2  2  12jan2011
a3  3  12jan2011


Incre Table
Pid no Dt
a1  5  18jan2011
a4  6  18jan2011
a5  7  18jan2011


Output
Pid no Dt
a1  5  18jan2011
a2  2  12jan2011
a3  3  12jan2011
a4  6  18jan2011
a5  7  18jan2011

1 REPLY 1
art297
Opal | Level 21

If your data are already sorted by pid, then you could just use:

data Main;

  informat dt date9.;

  input Pid $ no Dt;

  cards;

a1  1  12jan2011

a2  2  12jan2011

a3  3  12jan2011

;

data Incre;

  informat dt date9.;

  input Pid $ no Dt;

  cards;

a1  5  18jan2011

a4  6  18jan2011

a5  7  18jan2011

;

data Output;

  format dt date9.;

  update main incre;

  by pid;

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 717 views
  • 0 likes
  • 2 in conversation