cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DanC
‎05-02-2017
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Keep Full Sample of One File After Merge

by Calcite | Level 5 in SAS Programming
‎05-02-2017 10:06 AM
‎05-02-2017 10:06 AM
Thank you Astounding.   I delete duplicate observations in the MFILE by STATEFIP and PROVIDER. But still get the same number of observations after merge the two datasets. Do you have any suggestion? ... View more

Keep Full Sample of One File After Merge

by Calcite | Level 5 in SAS Programming
‎05-01-2017 03:25 PM
‎05-01-2017 03:25 PM
Hi Everyone   I am trying to keep the full sample of one file after merge. However, I tried many times but still got higher number. Could anyone give me some suggestions? Here is my code:   DATA ANALYTIC (replace=yes); MERGE ADM_forHYBRID (in=x)  MFILE (in=y); BY STATEFIP PROVIDER ; if x=1 then output; RUN;   The log shows that the ADM file has 20804087 observations and the MFILE has 177125 observations. However, after merge, the file has 20804107 observations. I want the final file to be 20804087 observations but I cannot get that number. Could anyone help me solve the issue?  Thanks a lot! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-02-2017 10:58 AM
Quick links