DATA Step, Macro, Functions and more

Deleting all but one record.

Reply
N/A
Posts: 0

Deleting all but one record.

My table have 2 variables; Var1 and Var2.

Every value for Var1 is unique. Var2 can be any real number.

I want to delete every record but the last one.

Since the Var1 values are unique both last.Var1 and first.Var1 always have the value 1, so I have no use for them.

The number of records can vary for each day.

How can I succeed with the deletion?

Susan
Respected Advisor
Posts: 3,799

Re: Deleting all but one record.

Posted in reply to deleted_user
To put it another way you want to KEEP the last record.;

[pre]
data table;
do var1=1 to 10;
var2 = ranuni(1);
output;
end;
run;
data last;
do point=nobs;
set table point=point nobs=nobs;
output;
end;
stop;
run;
proc print;
run;
[/pre]
Ask a Question
Discussion stats
  • 1 reply
  • 103 views
  • 0 likes
  • 2 in conversation