Deleting all but one record.

deleted_user — Thu, 05 Mar 2009 18:50:47 GMT

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

Re: Deleting all but one record.

data_null__ — Thu, 05 Mar 2009 19:49:02 GMT

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]

topic Re: Deleting all but one record. in SAS Programming

Deleting all but one record.

Re: Deleting all but one record.