DATA Step, Macro, Functions and more

Reading last observation to get sequnce number

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

Reading last observation to get sequnce number

I have the following two datasets -

data filea1;
input id 4. desc $1.;
datalines;
100 A
101 B
102 C
;

data filea2;
input desc $1.;
datalines;
G
H
K
;

I want to read the last observation of 'filea1' and get last id from that dataset and increment it by 1 for each observation on 'filea2'. My final dataset should look like -

data output1;

input id 4. desc $1.;

datalines;

100 A

101 B

102 C

103 G

104 H

105 K

;

How can I achieve the same ?


Accepted Solutions
Solution
‎04-12-2015 09:04 PM
Respected Advisor
Posts: 4,926

Re: Reading last observation to get sequnce number

Posted in reply to rajat051984

Just append both datasets while following id :

data output1;

set filea1 filea2 (in=in2);

if in2 then i + 1; else i = id;

id = i;

drop i;

run;

PG

PG

View solution in original post


All Replies
Solution
‎04-12-2015 09:04 PM
Respected Advisor
Posts: 4,926

Re: Reading last observation to get sequnce number

Posted in reply to rajat051984

Just append both datasets while following id :

data output1;

set filea1 filea2 (in=in2);

if in2 then i + 1; else i = id;

id = i;

drop i;

run;

PG

PG
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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