Using SAS
The purpose of this page is to help users understand the basics of using SAS. Please note that while this page will help get you started, it is important that you read all directions in the Canvas module items and course assignments.
Be sure to also use the Additional Resources page of this guide to access more in-depth SAS training materials and how-to videos.
If you have any questions or concerns, visit the Support page of this guide
Using SAS Studio: Uploading an Excel Data Sheet
The area of this guide is to help you understand how to upload and save an Excel data file in SAS. Doing so will allow you to use the data for any SAS task within SAS Studio. These steps must be completed before your data is ready to use in SAS.
Additionally, please refer to your course for any assignment specific directions.
Step 2
Select SAS Studio from your SAS dashboard.
Step 3
Select Files (Home) in the Server Files and Folders section. This will allow you to upload your Excel file into SAS.
Step 4
Select the icon.
Step 5
The Upload files textbox shows you the path your document will be saved under.
Select Choose Files. This opens up your device's file explorer. Find and open the Excel file you want to upload.
Step 6
Select Upload.
Step 7
Open the Files (Home) folder. The Excel file you uploaded will now be listed at the bottom. Double-click it to open it as a new tab in the SAS interface.
Step 8
You'll see file information open on the right. Select the icon in the toolbar. This helps generate a table of the data in SAS.
Step 9
You need to now name the data worksheet you'll use in SAS. Type the name in the textbox and select Change. A dialog box with your SAS libraries will open.
Note: You may need to scroll down or expand the window to see the change button.
Step 10
Select WORK from the list of libraries.
In the Data set textbox, type the worksheet name.
Then select Save.
Step 11
Open the Libraries directory and open the WORK folder.
Double-click IMPORT to open your data in the SAS interface.
Step 12
You can now see your data organized in columns. You can use this data set to perform multiple tasks in SAS. Visit your course for specific information on the necessary tasks you need to complete.
You may want to visit the Additional Resources page for comprehensive SAS guides and video tutorials. This can help you in performing tasks within the SAS Studio interface.
Coming Soon
Using SAS Studio: Uploading an Excel Data Sheet
The area of this guide is to help you understand how to upload and save an Excel data file in SAS. Doing so will allow you to use the data for any SAS task within SAS Studio. These steps must be completed before your data is ready to use in SAS.
RSCH 650 requires you to perform a t-test with data loaded in SAS. Visit the Performing a t-Test with SAS Studio area of this guide to learn how .
Additionally, please refer to your course for any assignment specific directions.
Step 2
Select SAS Studio from your SAS dashboard.
Step 3
Select Files (Home) in the Server Files and Folders section. This will allow you to upload your Excel file into SAS.
Step 4
Select the icon.
Step 5
The Upload files textbox shows you the path your document will be saved under.
Select Choose Files. This opens up your device's file explorer. Find and open the Excel file you want to upload.
Step 6
Select Upload.
Step 7
Open the Files (Home) folder. The Excel file you uploaded will now be listed at the bottom. Double-click it to open it as a new tab in the SAS interface.
Step 8
You'll see file information open on the right. Select the icon in the toolbar. This helps generate a table of the data in SAS.
Step 9
You need to now name the data worksheet you'll use in SAS. Type the name in the textbox and select Change. A dialog box with your SAS libraries will open.
Note: You may need to scroll down or expand the window to see the change button.
Step 10
Select WORK from the list of libraries.
In the Data set textbox, type the worksheet name.
Then select Save.
Step 11
Open the Libraries directory and open the WORK folder.
Double-click IMPORT to open your data in the SAS interface.
Step 12
You can now see your data organized in columns. You can use this data set to perform multiple tasks in SAS. Visit your course for specific information on the necessary tasks you need to complete.
You may want to visit the Additional Resources page for comprehensive SAS guides and video tutorials. This can help you in performing tasks within the SAS Studio interface.
Performing a t-Test with SAS Studio
You must complete the How to Use SAS Studio for RSCH 650 prior to completing the following steps.
Be sure you refer to your course for assignment specific information. The purpose of this area is to help you perform a t-test using SAS Studio.
Step 1
Be sure you are logged into SAS Studio. If you haven't already, open the Libraries directory and open the WORK folder.
Double-click IMPORT to open your data in the SAS interface.
Step 2
Your data should be open on the left area of the SAS interface. To perform a task, go to the Tasks and Utilities section.
Open Tasks > Statistics. Double-click t Test to open the statistics task interface.
Step 3
You need to load your data into the t-Test interface. Select the icon to open your SAS libraries.
Step 4
Under Roles > t test, choose Paired test from the dropdown.
Step 5
Two boxes for Group 1 variable and Group 2 variable will appear. Next to Group 1 variable, select the icon. A dialog box will open.
Step 6
Pick which column from your data that you want for the Group 1 variable. Select OK.
Step 7
Repeat Step 5 and Step 6 for Group 2 variable.
Step 8
You are now ready to run the t-test. Select the icon in the toolbar. A dialog box will open.
Step 9
Once you've run the test, your results will appear in the right side of the SAS interface. You can export your results by selecting the following icons:
- HTML File: Use this if you are familiar with HTML files and want to share it with HTML coding.
- PDF File: Use this if you want to share the results in a static document on its own.
- Microsoft Word File: Use this if you want to be able to embed tables, graphs, and other data within a paper. This provides image copies of SAS results.
- Email: Allows you to email the files.
