To connect to a DBMS source, change Engine type to Database System and select the appropriate SAS/ACCESS engine from the Engine drop-down list. In Step 3, enter access in the Name field and readonly in the Value field. This ensures that even if you are granted Write access to the data at the operating system or database level, SAS does not enable you to make changes to the data sources in the library. Click Next. The name-value pairs correspond with keywords and values used in the LIBNAME statement. In Step 4, verify the settings and select Test Library. You should see OK appear. Finish to define the library in your project. To access the data sources in the library, select or click in the Resources pane. orion View Servers Expand Servers <your server name> Libraries ORION. Double-click ORDERS to add a shortcut to the project. You need to refresh the server view to see the current contents of the orion library. You can do this by highlighting the server name and clicking the Refresh button. Save the project as Chapter2. Exercises Level 1 Assigning a Project Library Create the orion library to access the Orion customer and employee SAS data sets. In the project, use the Assign Project Library task to create the library and point Chapter2 orion to the location of the course data. If you do not have the Chapter2 project, you can create a new project. Include the option in Step 3 of the task. Then test and assign the library. access=readonly View the orion library in the Server window. If you do not see the library or the data sets, select your server and click Refresh. Save the Chapter2 project. Level 2 Using the Servers Window for File Operations Use the Server window to copy, paste, and delete data sets. The Server window can be used to create a copy of a data set. To create a temporary copy, the travel_expenses table in the orion library and select Copy. Then right-click the Work library and select Paste.
To connect to a DBMS source, change Engine type to Database System and select the appropriate SAS/ACCESS engine from the Engine drop-down list. In Step 3, enter access in the Name field and readonly in the Value field. This ensures that even if you are granted Write access to the data at the operating system or database level, SAS does not enable you to make changes to the data sources in the library. Click Next. The name-value pairs correspond with keywords and values used in the LIBNAME statement. In Step 4, verify the settings and select Test Library. You should see OK appear. Finish to define the library in your project. To access the data sources in the orion library, select View Servers or click in the Resources pane. Expand Servers <your server name> Libraries ORION. Double-click ORDERS to add a shortcut to the project. You need to refresh the server view to see the current contents of the orion library. You can do this by highlighting the server name and clicking the Refresh button. Save the project as Chapter2. Exercises Level 1 Assigning a Project Library Create the orion library to access the Orion customer and employee SAS data sets. In the Chapter2 project, use the Assign Project Library task to create the orion library and point to the location of the course data. If you do not have the Chapter2 project, you can create a new project. Include the access=readonly option in Step 3 of the task. Then test and assign the library. View the orion library in the Server window. If you do not see the library or the data sets, select your server and click Refresh. Save the Chapter2 project. Level 2 Using the Servers Window for File Operations Use the Server window to copy, paste, and delete data sets. The Server window can be used to create a copy of a data set. To create a temporary copy, the travel_expenses table in the orion library and select Copy. Then right-click the Work library and select Paste.
SAS_EG.docx