https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444902#M111429 <P>Try cartesian product and do the subtraction</P> Mon, 12 Mar 2018 19:29:16 GMT novinosrin 2018-03-12T19:29:16Z https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444897#M111426 <P>Dataset one&nbsp;&nbsp;Dataset two&nbsp;&nbsp;&nbsp;<BR />lang1&nbsp;&nbsp;long1&nbsp; lang2&nbsp;long2&nbsp;<BR />221&nbsp;&nbsp;334&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 823&nbsp;567&nbsp;<BR />456&nbsp;&nbsp;832&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 732&nbsp;346&nbsp;<BR />563&nbsp;&nbsp;678&nbsp;&nbsp;&nbsp;&nbsp; 568&nbsp;235&nbsp;<BR />444&nbsp;&nbsp;333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />555&nbsp;&nbsp;444&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />666&nbsp;&nbsp;555&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />777&nbsp;&nbsp;666&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />1002&nbsp;&nbsp;890&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />1560&nbsp;&nbsp;1021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />1567&nbsp;&nbsp;8946&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />2340&nbsp;&nbsp;1290&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />3460&nbsp;&nbsp;2230&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />How to loop through the two datasets in the following fashion and do the subtraction?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />(221-823)&nbsp; &nbsp;&nbsp;&nbsp;(334-567)&nbsp;&nbsp;<BR />(221-832)&nbsp;&nbsp; &nbsp;&nbsp;(334-346)&nbsp;&nbsp;<BR />(221-568)&nbsp;&nbsp; &nbsp;&nbsp;(334-235)&nbsp;&nbsp;<BR />(456-823)&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(456-732)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(456-568)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(563-823)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(563-732)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(563-568)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;<BR />(3460-823)&nbsp;&nbsp;&nbsp;&nbsp;(2230-567)&nbsp;&nbsp;<BR />(3460-732)&nbsp;&nbsp;&nbsp;&nbsp;(2230-346)&nbsp;&nbsp;<BR />(3460-568)&nbsp;&nbsp;&nbsp;&nbsp;(2230-235)&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />Subtraction&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P> Mon, 12 Mar 2018 19:21:15 GMT https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444897#M111426 mauri0623 2018-03-12T19:21:15Z https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444902#M111429 <P>Try cartesian product and do the subtraction</P> Mon, 12 Mar 2018 19:29:16 GMT https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444902#M111429 novinosrin 2018-03-12T19:29:16Z https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444905#M111431 <P>something like this should work:</P><PRE><CODE class=" language-sas">proc sql; create table work.want as select lang1 , lang2 , lang1-lang2 as lang_diff , long1 , long2 , long1 - long2 as long_diff from work.have1 cross join work.have2 ; quit;</CODE></PRE> Mon, 12 Mar 2018 19:33:16 GMT https://communities.sas.com/t5/SAS-Programming/sas-subtraction/m-p/444905#M111431 Urban_Science 2018-03-12T19:33:16Z