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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.