Second question first. I like the "SAS for dummies" book (first edition is for EGuide 4.1, second is for 4.2 and 4.3). "The little SAS book for Enterprise guide 4.x" is also good.
The QUERY BUILDER task is one way you can take an oracle view and make it into a static SAS dataset. Two things specifically to look at.
1) the options button to make sure that it creates a permanent data set
2) the name of the output dataset (in top right corner).
Remember that the F1 function key provides context sensitive help for any task.
Doc Muhlbaier
Duke
... View more