I mentioned previously that the SPSS data file was coming from REDCap. REDcap is not a data format it is a data collection tool. The 2 options from REDCap is SPSS or csv, which I was not aware of and for that I apologize. REDCap provides a sas code to transform the csv data file into a sas file. I am yet to do this though, so I could still run into issues. I did learn a lot of things I did not know about with the exchange of messages here though, so I am grateful for that. Things I would otherwise never ask about. I do work with a lot of SPSS files (not quite this long though). I am constantly having to save SPSS files into sas files to be able to work with them. I don't always have access to csv files for this. I am happy I found out that REDCp does provide this option though.  ... View more

Thank you, That is very good for me to know. I was saving the SPSS into a sas file first (as a permanent file) and then trying to work with that sas file. I just realized I can actually download the data file from Redcap as a sas file. I am trying this now and see what will happen. I will let you know if I still run into issues. Thank you so much again.  ... View more

I am trying to use a SPSS file (sav), saving it to sas first, to write a long code  to change this file (original SPSS) from a long format to a wide format. The SPSS file has 6.000 + entries and the sas file has only 4.000 entries due to the errors I mentioned in my original question, I am using sas 9.4 (unicode support). So I think it already has the unicode support you are mentioning, since it is in the name? I really  do not know, as I never had this issue before. Thank you. ... View more

Thank you. Could you please walk me through this? I searched to try to figure it out by myself but I can't seem to be able to. I am trying to convert my SPSS file into CSV. Using what you suggested(test is what my SPSS file is named). When I got he errors below I tried adding the DBMS=csv but the same error shows up. What am I doing wrong? Thank you again.   libname pr ' my computer location'; filename edited 'c:\temp\temp.csv' encoding='utf8' ; proc export data= 'test' outfile= edited 'Editedtest'; Run;   filename edited 'c:\temp\temp.csv' encoding='utf8' ; NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 68 proc export data= test outfile= edited Editedtest; ---------- 202 ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DBLABEL, DBMS, DEBUG, FILE, LABEL, OUTFILE, OUTTABLE, REPLACE, TABLE, _DEBUG_. ERROR 202-322: The option or parameter is not recognized and will be ignored. 69 DBMS=csv; 70 Run;       ... View more

My apologies. I am not good with macros and it is something I need to learn. And I am not sure I understand what you told me to do. However, I ran this right after the libname  %put &sysencoding.; Run;   Then I called in my file  (using encode any) and interesting enough it is still saying there was some truncation but the data file was generated this time (all obs were there, as opposed to 0 obs from before).   However, the error remains and I am sorry I don't see a pop up window when I run the %put. I am using SAS 9.4  My log looks like this After I run the %out in my input data   libname pr 'XXXXXXXXXXXXXXXXXXXXXXXX'; NOTE: Libref PR was successfully assigned as follows: Engine: V9 Physical Name: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 43 %put &sysencoding.; wlatin1 44 Run;   And when I call my data (sorry I don't know where else to place encoding =any. data test3(encoding=any); 46 set pr.X; NOTE: Data file pr.X is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 47 Run; ERROR: Some character data was lost during transcoding in the dataset PREMR.PREMRDATA1092020. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 4023 observations read from the data set X. WARNING: The data set WORK.TEST3 may be incomplete. When this step was stopped there were 4023 observations and 3053 variables. WARNING: Data set WORK.TEST3 was not replaced because this step was stopped. I don't know if I said this before (I think I did) and if it matters,  but the data file is coming from REDCap as SPSS and I am saving it as a sas  file to work with it. Thank you so much for your patience.          ... View more

Hi. I finally had time to go back to this issue I was having. I tried your suggestion:  Data test; Set pr.mydatafilename; %put &sysencoding.; Run;   and the error remains: After expansion the size of at least one character variable exceeds the maximum length of 32767. The length will be set to the maximum   and then: Some character data was lost during transcoding in the dataset  pr.mydatafilename . Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 4023 observations read from the data set X (my data file name) WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 4023 observations and 3053 variables. WARNING: Data set WORK.TEST was not replaced because this step was stopped.   I am not sure what to do. it is the first time I am trying to work with such a long data file and with such long strings.     ... View more

Hi. I finally had time to go back to this issue I was having. I tried your suggestion:  data test(encoding=any); set pr.nameofmydatafile; Run;   and the error remains: After expansion the size of at least one character variable exceeds the maximum length of 32767. The length will be set to the maximum   and then: Some character data was lost during transcoding in the dataset  pr.nameofmydatafile . Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 4023 observations read from the data set X (my data file name) WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 4023 observations and 3053 variables. WARNING: Data set WORK.TEST was not replaced because this step was stopped.   I am not sure what to do. it is the first time I am trying to work with such a long data file and with such long strings.     ... View more

I will try the suggestions next week, as I am not working this week, but wanted to thank you in advance. I will let you know what I find. ... View more

I will try the suggestions next week, as I am not working this week, but wanted to thank you in advance. I will let you know what I find.   ... View more