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
Nevermind, i got it. nodupkey worked. In pretty much any order
Nevermind, i got it. nodupkey worked. In pretty much any order
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.