Thank you very much, Tom!  May you please help me to add the FMTLIB option appropriately? my format file is a .SAS file which only contained the value and variable labels with a proc format at the beginning like this: proc format; value student  1 = "yes" 2 = "no"; . . . %macro format_file (d1 = , d2 = ); data &d2; set &d1; format student student.; . . . label student = "are you currently a student?"; . . . run; %mend; I could use the following code to export my SAS data set and save it as a SPSS_data.sav file. PROC EXPORT DATA=SAS_data FILE="&spss_loc\SPSS_data.sav" DBMS=SPSS REPLACE ; RUN; Without the FMTLIB option, the variable labels and some of the value labels are also in the SPSS dataset but I do not know where/how to add the FMTLIB option to export all variable and value labels. Thanks!         ... View more

@Reeza in another post here https://communities.sas.com/t5/SAS-Programming/convert-SAS-file-to-SPSS/m-p/233538#M42648 you suggested PROC EXPORT. May you please provide more details for your suggestion? Does that mean I can export the SAS dataset with its format file as an SPSS data file? Thanks  ... View more

Thank you, ballardw, for your suggestions! I do not have access to SPSS, my teammates do. Last time they sent me the SAS version of the dataset exported from SPSS. I could read that dataset but I did not check if any variable name was truncated to 32 characters. The variables for my analyses were fine though.    I will ask them to send me the version of their SPSS software and the SAS version of the dataset and see which way I can access their dataset in SAS. Thanks! ... View more

Thank you very much AMSAS and ballardw for checking my questions and your suggestions. I tried DBMS=SPSS but still, I get the same message for "Unknown internal variable type". I checked "Importing and Exporting SPSS Files" and tried the following code which imports format as well (I want the formats once I can read the data set). I will check with SAS technical support then. Thanks LIBNAME A '.'; PROC IMPORT DATAFILE="d:path\test.sav" OUT=SAS_dataset DBMS=SPSS; FMTLIB=A.FORMATS_SPSS; RUN; ... View more

Thank you,  KurtBremser. Yes, the variable city has five levels from 1 to 5. My log repeats the following 5 times.   NOTE: The input data set is subset by WHERE, OBS, or FIRSTOBS. This provides a completely separate analysis of the subset. It does not provide a statistically valid subpopulation or domain analysis, where the total number of units in the subpopulation is not known with certainty. If you want a domain analysis, you should include the domain variables in the TABLES request. NOTE: PROCEDURE SURVEYFREQ used (Total process time): real time 0.02 seconds cpu time 0.00 seconds             ... View more