topic Re: A quick question: Does the foramt of the numerical key variables matter in sql merge? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111240#M30827 <HTML><HEAD></HEAD><BODY><P>Never mind. It still not work after I changed format.</P></BODY></HTML> Fri, 15 Feb 2013 22:34:41 GMT Anna_Guo 2013-02-15T22:34:41Z A quick question: Does the foramt of the numerical key variables matter in sql merge? https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111239#M30826 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to merge two data base based on two key variables, both are numerical variables. I used sql to merge the two database and got zero observation. I don't know if it is because&nbsp; they&nbsp; have differnt format ( digits).&nbsp; One shows <SPAN style="font-size: 12pt;"><STRONG>F6.,</STRONG></SPAN> two show&nbsp; <SPAN style="font-size: 12pt;"><STRONG>Best12., </STRONG></SPAN> and the last show <STRONG>nothing</STRONG> when I view the column format.</P><P></P><P>Any suggestion?</P><P>Thanks in advance.</P></BODY></HTML> Fri, 15 Feb 2013 22:00:36 GMT https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111239#M30826 Anna_Guo 2013-02-15T22:00:36Z Re: A quick question: Does the foramt of the numerical key variables matter in sql merge? https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111240#M30827 <HTML><HEAD></HEAD><BODY><P>Never mind. It still not work after I changed format.</P></BODY></HTML> Fri, 15 Feb 2013 22:34:41 GMT https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111240#M30827 Anna_Guo 2013-02-15T22:34:41Z Re: A quick question: Does the foramt of the numerical key variables matter in sql merge? https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111241#M30828 <HTML><HEAD></HEAD><BODY><P>Thanks. I just figured out.</P></BODY></HTML> Fri, 15 Feb 2013 22:53:19 GMT https://communities.sas.com/t5/SAS-Procedures/A-quick-question-Does-the-foramt-of-the-numerical-key-variables/m-p/111241#M30828 Anna_Guo 2013-02-15T22:53:19Z