https://communities.sas.com/t5/SAS-Enterprise-Guide/Newbie-How-to-create-a-table-from-a-view-in-EG-4-2/m-p/8298#M2457 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.<BR /> <BR /> 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. <BR /> 1) the options button to make sure that it creates a permanent data set<BR /> 2) the name of the output dataset (in top right corner).<BR /> Remember that the F1 function key provides context sensitive help for any task.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Mon, 14 Feb 2011 13:56:30 GMT Doc_Duke 2011-02-14T13:56:30Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Newbie-How-to-create-a-table-from-a-view-in-EG-4-2/m-p/8297#M2456 I am just starting to learn SAS so I have a long way to go. I very much appreciate any help I can get. Here is my problem: I have created an Oracle view and it has been registered to metadata. I go into EG, I started a new project and I have done a 'drag &amp; drop' to bring my view into my project. This view takes a long time to run and the data is static so I want to create a permanent table as the next step after the view and use this to build my reports so the view does not have to run each time. I looked in the 'task list' and just see 'append table'. I can not figure out how to create this next step to 'create table'.<BR /> <BR /> Also, any suggestions on a good book to help me learn EG?<BR /> Thanks so much! Fri, 11 Feb 2011 18:28:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Newbie-How-to-create-a-table-from-a-view-in-EG-4-2/m-p/8297#M2456 ncsthbell1 2011-02-11T18:28:49Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Newbie-How-to-create-a-table-from-a-view-in-EG-4-2/m-p/8298#M2457 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.<BR /> <BR /> 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. <BR /> 1) the options button to make sure that it creates a permanent data set<BR /> 2) the name of the output dataset (in top right corner).<BR /> Remember that the F1 function key provides context sensitive help for any task.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Mon, 14 Feb 2011 13:56:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Newbie-How-to-create-a-table-from-a-view-in-EG-4-2/m-p/8298#M2457 Doc_Duke 2011-02-14T13:56:30Z