Sometimes you have to move between these different analysis programs, but don't know how to convert a file.
There are functions within SPSS and Excel, SAS to help you convert it. In addition, there is another tool you can use: N2MPlus.
The software allows you convert a SPSS or Excel file into a text file, which then can be used in SAS. The advantage is that you can choose just some variables you are interested in.
Step 1: Download and install it
Step 2: Choose a file to convert
Step 3: Choose a definition for missing values
Step 4: Choose all or some variables you like
Step 5: Go!
Step 6: Go back to the folder where you picked the original file. The newly created file, with selected variables, is there.
Step 7: In SAS, key in the address of the newly created file, and RUN.
