Deleting all but one record.

[deleted_user]

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

[data_null__]

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]