topic Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco in SAS Programming

Help! Losing observations when reading in sas7bdat file. Says character data lost during transcoding

joelee1 — Wed, 13 May 2020 20:06:31 GMT

I am working on a dataset I got from a colleague in sas7bdat file format. When I tried to read in the file I get that it is in a format native to the host. And then an error that character data was lost in transcoding. So I lose my total number of observations. Attaching screenshots, would appreciate any help. Thank you!

Code:

libname SAMBA "/folders/myfolders/SAMBA";
Data work.pcorifinal;
set SAMBA.pcorifinal;
Run

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

art297 — Wed, 13 May 2020 20:13:03 GMT

Take a look at: https://communities.sas.com/t5/General-SAS-Programming/Data-file-is-in-a-format-that-is-native-to-another-host/td-p/433678

Art, CEO, AnalystFinder.com

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

joelee1 — Wed, 13 May 2020 20:57:15 GMT

Hi,

Thanks for sharing that. I actually referenced that post before and tried it. I'm still getting the same error message of truncating results and losing number of observations. Do you know if there are other solutions? Or would having them send it in another file format and importing/converting it in possibly solve this issue? I'm not sure if it might be associated with SAS University? Thanks!

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

art297 — Wed, 13 May 2020 21:16:50 GMT

A couple of additional possibilities are mentioned in the thread at: https://communities.sas.com/t5/General-SAS-Programming/Transcoding-problem/td-p/390028

Art, CEO, AnalystFinder.com

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

art297 — Wed, 13 May 2020 21:35:14 GMT

Of course this might help to identify which encoding was used: https://documentation.sas.com/?docsetId=viyadatamig&docsetTarget=n0l8h0a2hkxa7cn1a8jwkcilok2z.htm&docsetVersion=3.3&locale=en

Art, CEO, AnalystFinder.com

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

ChrisNZ — Thu, 14 May 2020 01:53:12 GMT

Try:

data work.pcorifinal(encoding='UTF-8');
  set SAMBA.pcorifinal;
run;

Report the result of:

proc contents data=SAMBA.pcorifinal;
run;

Re: Help! Losing observations when reading in sas7bdat file. Says character data lost during transco

Ksharp — Thu, 14 May 2020 11:23:01 GMT

That is to say your SAS encoding is not matched with your colleague's .
Here are options:
1) Let your colleague to make that sas table as a utf-8 encoding.

2)use PROC CPORT + PROC CIMPORT to transform that sas table.

3)Try CVP engine:

libname x cvp '/folders/myfolders/SAMBA';
proc copy in=x out=work noclone;
run;

4) Let your colleague offer you a CSV or TXT file, instead of a sas table .