topic Re: in-line view vs subquery in SAS Programming https://communities.sas.com/t5/SAS-Programming/in-line-view-vs-subquery/m-p/155667#M298834 <HTML><HEAD></HEAD><BODY><P>An in-line view can be reused.</P><P>Is there a difference in the way a query is executed using either an in-line view or a subquery?&nbsp; Possibly, but this would be up to the query optimiser to determine.&nbsp; </P><P>Is there a difference in the way a query is developed using either an in-line view or a subquery? For a complex query it may be easier to design and test one or more in-line queries independent of the main query.&nbsp; There may also be benefits for code maintenance.</P><P></P><P>Richard</P></BODY></HTML> Tue, 13 May 2014 00:08:10 GMT RichardinOz 2014-05-13T00:08:10Z in-line view vs subquery https://communities.sas.com/t5/SAS-Programming/in-line-view-vs-subquery/m-p/155666#M298833 <HTML><HEAD></HEAD><BODY><P>Is there a difference between an in-line view and a subquery?&nbsp; If so, what is the difference?</P></BODY></HTML> Mon, 12 May 2014 23:50:07 GMT https://communities.sas.com/t5/SAS-Programming/in-line-view-vs-subquery/m-p/155666#M298833 dataMart87 2014-05-12T23:50:07Z Re: in-line view vs subquery https://communities.sas.com/t5/SAS-Programming/in-line-view-vs-subquery/m-p/155667#M298834 <HTML><HEAD></HEAD><BODY><P>An in-line view can be reused.</P><P>Is there a difference in the way a query is executed using either an in-line view or a subquery?&nbsp; Possibly, but this would be up to the query optimiser to determine.&nbsp; </P><P>Is there a difference in the way a query is developed using either an in-line view or a subquery? For a complex query it may be easier to design and test one or more in-line queries independent of the main query.&nbsp; There may also be benefits for code maintenance.</P><P></P><P>Richard</P></BODY></HTML> Tue, 13 May 2014 00:08:10 GMT https://communities.sas.com/t5/SAS-Programming/in-line-view-vs-subquery/m-p/155667#M298834 RichardinOz 2014-05-13T00:08:10Z