Introduction to SAS [19-19]

h

Shortcut for Exporting Data Sets

SAS Studio provides a shortcut for exporting data sets. If you prefer not to write code, you can simply follow the steps below to export the data.

3 Steps to Export Data:

Step 1: Right click the data set that you'd like to export and click Export. ​

Picture

Step 2: Select the folder where the data set should be exported to.

Picture

Step 3: Name the file to be exported (from Filename) and select the type of file to be exported (Excel, text, CSV, etc.)​

Picture

Done! The file is exported:

Picture

? Sign up for a free SASCrunch account now and keep track of your learning progress!


Exercise

Locate the Fish data set in the SASHelp library. 

Export the Fish data set into an Excel spreadsheet using the shortcut. Save the spreadsheet in the Files (Home) folder. 

Need some help?

Get Hint

Get Solution