topic Re: Error when merging data sets in SAS Programming https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124460#M25469 <HTML><HEAD></HEAD><BODY><P>I am sure you will get better answers than this, but I think that keep=count statement has the result of only the variable 'count' being available for the merge.</P><P>Steve Denham</P></BODY></HTML> Tue, 13 Nov 2012 13:50:07 GMT SteveDenham 2012-11-13T13:50:07Z Error when merging data sets https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124459#M25468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>When I run the below data step to merge two data sets, I am getting the below errors for missing columns. However, both columns exist on both data sets. Is there something syntax-wise wrong? I have also sorted both data sets prior to running the merge.</P><P></P><P>Paul</P><P></P><P>ERROR: BY variable cnty_name is not on input data set WORK.S1AGESHORTYEARFREQSORT.</P><P>ERROR: BY variable startyear is not on input data set WORK.S1AGESHORTYEARFREQSORT.</P><P></P><P></P><P>data s1ageyear1;</P><P>merge work.s1ageshortyearfreqsort (keep=count rename=(count=cohortyearcount)) work.s1ageshorttestsort;</P><P>by cnty_name startyear;</P><P>run;</P></BODY></HTML> Tue, 13 Nov 2012 13:45:43 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124459#M25468 Paul_NYS 2012-11-13T13:45:43Z Re: Error when merging data sets https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124460#M25469 <HTML><HEAD></HEAD><BODY><P>I am sure you will get better answers than this, but I think that keep=count statement has the result of only the variable 'count' being available for the merge.</P><P>Steve Denham</P></BODY></HTML> Tue, 13 Nov 2012 13:50:07 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124460#M25469 SteveDenham 2012-11-13T13:50:07Z Re: Error when merging data sets https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124461#M25470 <HTML><HEAD></HEAD><BODY><P><A __default_attr="455729" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A>: I don't think he'll get a better answer than the one you provided!</P></BODY></HTML> Tue, 13 Nov 2012 13:56:13 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124461#M25470 art297 2012-11-13T13:56:13Z Re: Error when merging data sets https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124462#M25471 <HTML><HEAD></HEAD><BODY><P>That was it, thanks.</P><P></P><P>Paul</P></BODY></HTML> Tue, 13 Nov 2012 14:30:41 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-merging-data-sets/m-p/124462#M25471 Paul_NYS 2012-11-13T14:30:41Z