SAS function IMPORT

For this click File -> Import data and you get:

Choose the type of file you want to import (in our case Excel), click Next and choose the file by browsing you catalogue (observe that the extension of the file is .xlsx).

In the next step you choose how the file is saved as SAS-dataset (Choose the SAS destination). You can choose between:

                SASUSER – the file is saved permanently in the SAS library SASUSER

and

                WORK – the file is saved temporarily in the SAS library ‘WORK’ and is deleted when the session is closed.

Usually it is best to choose WORK and save the dataset as permanent dataset when we have seen that the import was successful. Read more about temporary and permanent data sets.

Furthermore you need to specify the name for the file (MEMBER). For the exercise choose to call it ‘indata1’. Click ‘Next’ and ‘Finish’ and your data is imported. Check the log-window to see if the import was done successfully.