In addition to the normal .SAV file format, SPSS has also a portable format(portable between all past SPSS versions and specific operating systems); frequentlyused by data archives and other data providers to disseminate data (internet, storage media).
STEP 1: Start up SPSS and convert the SPSS data to a"portable" data set (i.e., a .por data set). To do this, simply openthe data set, click on the File menu and select Save As. A windowwill appear. In the File Format section, click on "SPSS Portable."When you name the file make certain to add the .por extension; SPSSdoes not do this automatically. See the special note at theend if you are transferring the SPSS data set from one computer toanother. For this example, let's assume that we have saved the SPSSdata set wolfdata.sav in portable file format as "wolfdata.por" indirectory ~myname/myspssstuff.
STEP 2: Start up SAS. In the program window, give a LIBNAMEstatement to the SPSS portable data set. this LIBNAME statement mustcontain the qualifier SPSS after the nickname. For example,LIBNAME convert SPSS '~myname/myspssstuff/wolfdata.por';
NOTE WELL: SPSS portable data sets are not quite asportable as it seems. If you are transferring a .por data set fromone computer to another, then you may have to call up SPSS on thesecond computer and resave the .por file. For example, if you createa .por data set on a PC and then ftp it to samiam, then you muststart SPSS on samiam, open the .por file (use the File menu andselect Open) and then resave it by clicking on the File menu andselecting Save As. Any name will due, but make certain that it issave as an SPSS portable file with a .por extension.
R can import SPSS files quite easily, using the package foreign and the read.spss command. It usually works quite well out of the box, so well that I usually choose the SPSS file when downloading secondary data (hint: look at the argument use.value.labels depending on how you want your data).
The portable file (* .por) is an old format used for compatibility in different versions of SPSS and different OS. Its current use is not recommended by several limitations, including: shorten variable names, change the file encoding (not support unicode), recoded variable information, etc.
SASPairs can convert either an SPSS system file (i.e., a .sps file) or an SPSS portable file (a .por file). It is much easier to convert the portable file, so if you are familiar with SPSS, it is suggested that you create a .por file from your system data set.
From 2003 to 2015, data was also made available in SPSS portable file format (.POR), stored in a zip file archive. After downloading, the zip archive must be extracted to access the SPSS portable file. The SPPS statistical system or another statistical software package able to read the SPSS portable file format is necessary to properly access the downloaded files.
Russian variable and value labels are available in the SPSS portable files distributed by The National Research University Higher School of Economics, Moscow. Please go here to apply for the Russian language files.
We primarily distribute data files in eight data formats: three plain text formats (column-delimited ASCII, comma-delimited ASCII, and tab-delimited ASCII), two SAS formats (SAS XPORT and CPORT files), two SPSS formats (SPSS SAV and portable files), and the single Stata data format. Virtually every data file is available in a plain text format. We also supply many data files in one or more of the other formats.
We distribute two types of SPSS data files: SPSS SAV files written by the SPSS save command and SPSS portable files written by the SPSS export command. Both types of data files include variable labels and usually include value labels and missing value definitions.
SPSS setup files can be used to generate native SPSS file formats such as SPSS system files and SPSS portable files. SPSS setup files produced by generally include the following SPSS sections. Click on each section to see an example taken from ICPSR 6512 (Capital Punishment in the United States, 1973-1993).
And if you want to remove the formats from the mix, you can "flatten" the data set so that the formatted values become the actual values within the data. The data might lose some fidelity in the process (as the formatted values might be less precise than the underlying raw values), but the data set is then more portable
And if you want to remove the formats from the mix, you can "flatten" the data set so that the formatted values become the actual values within the data. The data might lose some fidelity in the process (as the formatted values might be less precise than the underlying raw values), but the data set is then more portable. I'll share a technique for that in a different article.
Hi @lijunchen - you can turn your SPSS-labels-turned-SAS-formats into SAS data sets. Use the PROC FORMATS and CTLOUT= option as I showed in a previous comment. That data set can then be used in another PROC FORMATS step with the CTLIN= option if you ever need to rebuild it. That's the standard way to keep SAS format definitions portable across systems and different operating systems. Open or PROC PRINT the data set to see the format definition rules.
Creating SAS and SPSS Transport FilesThe files you want to move need to be in a format that is readable by another operating system. There is no conversion necessary to move your raw data files and your program source code files to your PC. However, if you are moving any SAS® or SPSS® system files, you will first need to export (convert) the files to a transport format. To create a SAS Version 6 transport file or an SPSS portable file, follow the instructions in the following examples. If you also have SAS Version 5 files to move, you first need to convert the Version 5 files to Version 6 using PROC V5TOV6.
SPSS Save FileThese are the instructions to export an SPSS save file into an SPSS portable file using an example where the TSO ID is SHOWME and the SPSS save file is named PAPAYA.SPSSYS. An SPSS portable file named PAPAYA.POR is created. When using these instructions to convert your files, substitute your TSO ID and file names.
To complete the task of moving from TSO to your PC, examine the files that you moved to your PC. Look at your raw data files and program source code files to verify that the entire contents of the files were downloaded. Import (convert) the SAS transport files and the SPSS portable files back to SAS system files and SPSS format data files respectfully and then view the contents.
Use the download links on the data pages to download individual files in their native formats (generally SPSS portable, and ascii), or the checkboxes to download multiple files at once. To download data in other formats or to run analyses on line use the [Subsetting/Statistics] button next to each data file.
A naming system identifies the data found in a file. For example, the file "mg_ak.por" contains the 1984-1990 MCD files for Arkansas. The file "ak86mp20.por" contains the 1986 voting precinct file for Arkansas. In all cases, the data files are SPSS portable files and have a ".por" extension identifying them as such.
I tested it by copying 80GB of data from a computer that runs on the Samsung SSD 970 Pro. The drive had sustained speeds of more than 1600 MB/s for both writing and reading. These were some three times that of even the fastest SATA-based portable SSDs.
At this speed, you can finish copying two CDs worth of data in less than one second. As a result, the new portable drive can function as a storage device for even the most demanding tasks, such as 4K editing or rendering real-time 3D images.
Note: In order to use SAS transport files, you need to change it to the SAS Windows or SAS Unix environment. In addition, if before you can use SPSS portable files, you need to change it to the extension .SAV 2b1af7f3a8