DATA Step, Macro, Functions and more

Reading the last record of a large table

Reply
Regular Learner
Posts: 1

Reading the last record of a large table

I would like to populate the last record of a variable as a new variable

 

Input

 

Sno Closing Price

1        10

2         10.5

3          10.2

4          10.4

5          10.6

 

Output:

 

Sno Closing Price   New_Closing Price

1        10                 10.6

2         10.5             10.6

3          10.2            10.6

4          10.4            10.6

5          10.6            10.6

 

 

I would like to obtain this output using both a datastep as well as a proc sql if possible.

 

 

Thank you much in advance.

Respected Advisor
Posts: 3,156

Re: Reading the last record of a large table

[ Edited ]
Posted in reply to sivakarthik

Here is one way,

 

 

data have;
	input Sno Closing_Price;
	cards;
1        10
2         10.5
3          10.2
4          10.4
5          10.6
;
run;

data want;
	if _n_=1 then
			set have (rename=closing_price=new_closing keep=Closing_Price) nobs=nobs point=nobs;
			
	set have;
run;
Super User
Posts: 5,424

Re: Reading the last record of a large table

Posted in reply to sivakarthik

Two "why's":

  1. why both SQL and data step?
  2. Why do you want to add this value to all rows (the requirement...)?
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 231 views
  • 0 likes
  • 3 in conversation