Say that you have SAS/CONNECT software and want to download a _LARGE_ SAS data set from your UNIX server to your Workstation. However, you do not need the entire _LARGE_ SAS data set for your analysis; simply select the observations that contain data for the subset that you are analyzing. You can apply a WHERE statement (or WHERE data set option) to your PROC DOWNLOAD.
Submitted by Michael A. Raithel, The man who wrote the book
on performance. Contact me at my Discussion Page.
Feel free to comment on this tip.