Proc sort nodup problem

MeganE — Sat, 02 Jul 2016 00:20:37 GMT

Hi guys,

I have a table with many records per id. I want one record just of each id variable. I have tried different combinations of this, and nothing is working. I end up with exactly the same number of records as the table going into the sort.

?!?!?

proc sort data=junk.new_costs_&yr._filtered nodup out=junk.npats (keep=usrds_id); by usrds_id; run;

proc sort data=junk.new_costs_&yr._filtered out=junk.npats (keep=usrds_id) nodup; by usrds_id; run;

proc sort data=junk.new_costs_&yr._filtered nodup (keep=usrds_id) out=junk.npats; by usrds_id; run;

15       ! proc sort data=junk.new_costs_&yr._filtered nodup out=junk.npats (keep=usrds_id); by usrds_id; run;

NOTE: There were 41013989 observations read from the data set JUNK.NEW_COSTS_2014_FILTERED.
NOTE: 0 duplicate observations were deleted.
NOTE: The data set JUNK.NPATS has 41013989 observations and 1 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           21:43.46
      cpu time            1:21.97

Thanks

Megan

Re: Proc sort nodup problem

MeganE — Sat, 02 Jul 2016 01:05:20 GMT

Nevermind, i got it. nodupkey worked. In pretty much any order

topic Re: Proc sort nodup problem in SAS Programming

Proc sort nodup problem

Re: Proc sort nodup problem