topic Re: Are there some query tools in IML in SAS/IML Software and Matrix Computations https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208866#M2174 <HTML><HEAD></HEAD><BODY><P>Not really. Most data preparation is done outside of IML by using the DATA step or SQL. There is nothing in SAS/IML that matches their power and convenience.</P><P></P><P>You can, of course, use the LOC function, in conjunction with subscripting and concatenation, to match and merge rows of matrices. The<A href="http://blogs.sas.com/content/iml/2011/11/01/the-unique-loc-trick-a-real-treat.html"> UNIQUE-LOC technique </A>is often used to combine data by matching categories.&nbsp; The <A href="http://support.sas.com/documentation/cdl/en/imlug/66845/HTML/default/viewer.htm#imlug_langref_sect124.htm">EXPANDGRID function</A> is a kind of joining operation, since it is a Cartesian product operation. </P></BODY></HTML> Mon, 04 May 2015 14:20:20 GMT Rick_SAS 2015-05-04T14:20:20Z Are there some query tools in IML https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208865#M2173 <HTML><HEAD></HEAD><BODY><P>I am wondering if there are some query tools in IML?</P><P>Like MERGE in data step. LEFT JOIN in SQL .</P><P></P><P></P><P></P><P>Xia Keshan</P></BODY></HTML> Mon, 04 May 2015 13:34:44 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208865#M2173 Ksharp 2015-05-04T13:34:44Z Re: Are there some query tools in IML https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208866#M2174 <HTML><HEAD></HEAD><BODY><P>Not really. Most data preparation is done outside of IML by using the DATA step or SQL. There is nothing in SAS/IML that matches their power and convenience.</P><P></P><P>You can, of course, use the LOC function, in conjunction with subscripting and concatenation, to match and merge rows of matrices. The<A href="http://blogs.sas.com/content/iml/2011/11/01/the-unique-loc-trick-a-real-treat.html"> UNIQUE-LOC technique </A>is often used to combine data by matching categories.&nbsp; The <A href="http://support.sas.com/documentation/cdl/en/imlug/66845/HTML/default/viewer.htm#imlug_langref_sect124.htm">EXPANDGRID function</A> is a kind of joining operation, since it is a Cartesian product operation. </P></BODY></HTML> Mon, 04 May 2015 14:20:20 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208866#M2174 Rick_SAS 2015-05-04T14:20:20Z Re: Are there some query tools in IML https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208867#M2175 <HTML><HEAD></HEAD><BODY><P>Thanks . Rick .</P></BODY></HTML> Tue, 05 May 2015 11:43:54 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Are-there-some-query-tools-in-IML/m-p/208867#M2175 Ksharp 2015-05-05T11:43:54Z