topic what is main difference between Sas merge and Join? in SAS Programming https://communities.sas.com/t5/SAS-Programming/what-is-main-difference-between-Sas-merge-and-Join/m-p/86017#M256965 <HTML><HEAD></HEAD><BODY><P>what is main difference between Sas merge and Join?</P></BODY></HTML> Tue, 17 Apr 2012 10:04:56 GMT manojjenasas 2012-04-17T10:04:56Z what is main difference between Sas merge and Join? https://communities.sas.com/t5/SAS-Programming/what-is-main-difference-between-Sas-merge-and-Join/m-p/86017#M256965 <HTML><HEAD></HEAD><BODY><P>what is main difference between Sas merge and Join?</P></BODY></HTML> Tue, 17 Apr 2012 10:04:56 GMT https://communities.sas.com/t5/SAS-Programming/what-is-main-difference-between-Sas-merge-and-Join/m-p/86017#M256965 manojjenasas 2012-04-17T10:04:56Z Re: what is main difference between Sas merge and Join? https://communities.sas.com/t5/SAS-Programming/what-is-main-difference-between-Sas-merge-and-Join/m-p/86018#M256966 <HTML><HEAD></HEAD><BODY><P>PROC SQL is a procedure where as MERGE is a data step.</P><P>PROC SQL takes longer time to run than MERGE when performing joins on large data sets.</P><P></P><P align="left">PROC SQL provides other potential advantages for communicating outside the SAS as SQL query is the standard method for specifying data requests from one database to another.</P><P align="left">PROC SQL is particularly appealing because of its simplicity and readability.</P><P></P></BODY></HTML> Tue, 17 Apr 2012 12:18:58 GMT https://communities.sas.com/t5/SAS-Programming/what-is-main-difference-between-Sas-merge-and-Join/m-p/86018#M256966 Hima 2012-04-17T12:18:58Z