Thank you, Ksharp. This is what I was using the 'k' modifier. I was hoping to be able to use the 'g' modifier to only exclude the graphic characters. Maybe at some point, I learn to work efficiently with the modifiers. Thanks! ... View more

  data test; input var$ ; datalines; oÔÇÖ\[}s dsd_'"sf ; run;   Obs var 1 oÔÇÖ\[}s 2 dsd_'"sf   data want; set test; new_var=compress(var,"ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890$%.-'"":|&[]{}*!@#()!/+, ",'kg'); run; proc print data=want; run; The SAS System Obs var new_var 1 oÔÇÖ\[}s oÔÇÖ\[}s 2 dsd_'"sf dsd_'"sf  Thank you @Ksharp for your suggestion. I already have a solution but I thought this might be easier to just remove the "graphic characters". Beacuse I want to keep everything except the translation of emojis that appear in my SAS dataset. May you please help me with an example? Thanks   ... View more

May someone please help me to mark this conversation as solved? I am not sure because it was solved based on two suggestions. Thanks ... View more

Thank you, @Tom and @ErikLund_Jensen. A combination of your suggestions solved my problem I used the double "" and,"k" modifier and that gives me exactly what I want. Thanks! ... View more

Thank you, novinosrin. What does this combination do? Thanks! ... View more

@Reeza Good point. May you please check if my step 4 is correct? data sas_data_new (rename (this=that)); set sas_data_with_derived_var(drop=var1 var2); run; %format_file (d1 = sas_data_new, d2 = sas_data); After adding the derived variables, in the last step, I rename and drop some variables and then match my SAS data (sas_data_new) with the format file using the %format_file I created in my format file and the d2=sas_data has all the variable and value labels. This is the SAS data I export to SPSS. Am I missing something here? Thanks!   From previous posts: This is my format file--> 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; and, this is my code to EXPORT the SAS data as an SPSS dataset--> libname thelib "D:\path"; PROC EXPORT DATA=sas_data FILE="&spss_loc\SPSS_data.sav" DBMS=SPSS REPLACE ; FMTLIB= thelib.format_file_name; RUN; "D:\path"; is where I saved my format file "format_file_name.sas" ... View more

Thank you, Tom, for these steps. May you please help me fix my STEP 5? I cannot introduce the format file in the FMTLIB option. This is my try libname thelib "D:\path"; PROC EXPORT DATA=SAS_data FILE="&spss_loc\SPSS_data.sav" DBMS=SPSS REPLACE ; FMTLIB= thelib.format_file_name; RUN; This code creates the SPSS dataset but now all value labels are removed. The log looks fine NOTE: The export data set has 450 observations and 85 variables. NOTE: "D:path\SPSS_data.sav" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 5.20 seconds cpu time 0.01 seconds Thanks! ... View more

Thank you, for your thoughts. I received the original data in SPSS (.sav) and it contained value labels. I derived some variables in SAS and added value labels and variable labels for the derived variables in my SAS format file. The SPSS dataset that I exported from SAS, contains all the variable labels, some value labels from that original SPSS dataset (not all of them) and some of the ones I created for the derived variables. In SPSS, all the missing value labels are recognized as numeric similar to my STUDENT example below: 1 = "yes" 2 = "no" ... View more

Thank you very much, Reeza, for taking the time to respond to my post and for your thoughts. It was not in my mind to exporting directly to a .sav file and PROC EXPORT works very well and exports some value and variable labels (I do not know why not all). I am looking for advice to use the FMTLIB option to export all labels. Thanks! ... View more