Thank you for your quick reply. I followed other solutions and waited a day for this!!! It was really simple as you said... Thank you so much again! ... View more

Agreed. Will start from the beginning again. Thank you for your thoughtful suggestion.  ... View more

@cphd wrote: Hi all,    I have a phone number variable that has '-' in the middle. I would like to take numbers only.    This is what I want.         Phone               num_phone (what I want) 111-222-3333       1112223333 111-222-4444       1112224444 111-2225555        1112225555     Thank you in advance. By any chance to you have international phone numbers in you data?   I worked with a process that did this to "clean" phone numbers and then found that certain international phone numbers with different number construction would fit in the US 10 digit dial string but were now considered to be in US because the first two digits were the country code and the remaining eight were the number within the country.   So if you do not know if you have international numbers you might check to see if you have any dialing strings with a dash in the third position. ... View more

The problem is not different formats! The problem is different data types.   If one is numeric and the other is character, you can't do the merge. You have to change variable zipcode to both numeric or both character and then the merge should work. ... View more

The problem is not different formats! The problem is different data types.   If one is numeric and the other is character, you can't do the merge. You have to change variable zipcode to both numeric or both character and then the merge should work. ... View more

1. SORT approach would require 2 sorts: data have; input County year Count; cards; 20001 2008 1 20001 2008 2 20001 2008 3 20001 2006 1 20002 2008 1 20002 2008 2 ; proc sort data=have out=temp; by county year descending count; run; proc sort data=temp out=want nodupkey; by county year; run; 2. data have; input County year Count; cards; 20001 2008 1 20001 2008 2 20001 2008 3 20001 2006 1 20002 2008 1 20002 2008 2 ; data want; set have; by county year notsorted; if last.year; run; Assuming your dataset order is what it is as shown in your sample, you would need a NOTSORTED option in the BY statement in your datastep   3. Proc SQL grouped filter using HAVING clause proc sql; create table want as select * from have group by county,year having count=max(count); quit;   ... View more

@cphd,  as @Astounding pointed out, just change first.year to first.zipcode data have; input name :$3. zipcode year; datalines; ABC 30010 2006 ABC 30010 2007 ABC 30011 2005 BCC 30010 2001 BCC 30010 2002 BCC 30010 2003 ; run; data desired; input name :$3. zipcode year maxyear; datalines; ABC 30010 2006 2007 ABC 30010 2007 2007 ABC 30011 2005 2005 BCC 30010 2001 2003 BCC 30010 2002 2003 BCC 30010 2003 2003 ; run; proc sort data=have; by name zipcode descending year; run; data want; set have; by name zipcode; if first.zipcode then maxyear=year; retain maxyear; run; *Checking that desired=want; proc sort data=desired; by name zipcode descending year; run; proc compare base=desired compare=want; run; ... View more

Thanks for sharing the code. I used the macro function to do it but you forgot to add %end at the end. Here is the code that I used for the reference for future users.  %macro all20; %do i=1 %to 20; data newfile&i; set file&i; age=2019-byear; run; %end %mend all20; %all20;     ... View more

Note that have the DOS End of File character in your text files has nothing to do with what might have been or not been in the top left cell of some spreadsheet.  But it might indicate some other error in the process that created the file. ... View more