--On 8/15/08 6:03 PM -0400 Chang Chung wrote:
> good point! but as shown below, you can make a view of multiple datasets
> having the separate indexes, and where seems to be fine with this.
> interesting. ran on sas 9.1.3 sp4 on windows.
> /* make a view of two datasets appended */
> proc sql feedback;
> drop view work.oneTwo;
> create view oneTwo as
> select * from one union select * from two
> order by age;
One thought on this--at least in my general approach to using views--is you
probably want to avoid the ORDER BY statement--especially if it's the variable
you're indexing on and you want to use a subset.
For any amount of data above a trivial one, there's no sense in forcing the
view to re-order th
e data if it doesn't have to.