topic Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine. in SAS Programming

sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 03:14:40 GMT

data a; set sashelp.class; run;

PROC EXPORT DATA= WORK.A OUTFILE= "C:\Users\lenovo\Desktop\class.dta" DBMS=STATA LABEL REPLACE; RUN;

options MSGLEVEL=I;

PROC IMPORT OUT= WORK.class DATAFILE= "C:\Users\lenovo\Desktop\class.dta" DBMS=STATA REPLACE; RUN;

How to solve this problem，SAS lost some advantage.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

jimbarbour — Wed, 04 Aug 2021 03:25:09 GMT

It would be helpful if you could show more of your log using the indicated icons:

Often, it's not serious when you get a "VARCHAR data type is not supported by the V9 engine" message in the log. Usually, SAS just converts it to Char.

What are your results like? Is there a problem with the results or is the message the only issue?

Jim

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 03:37:28 GMT

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 03:40:35 GMT

SAS exports the file, and then imports it into SAS. The data is inconsistent and the label is missing.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 03:47:26 GMT

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

SASKiwi — Wed, 04 Aug 2021 04:03:56 GMT

Looks like you have an encoding difference between Stata and SAS. Run this to check your SAS encoding and post the result:

proc options option = encoding;
run;

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 04:48:39 GMT

Chinese coding，M2, there will be no problem with this operation.M6 has this problem.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Wed, 04 Aug 2021 10:07:46 GMT

By comparison, ENCODING=WLATIN1, there is a warning under this code, but there is no problem, but not under Chinese code. This is a bug.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

jimbarbour — Wed, 04 Aug 2021 15:52:20 GMT

The warning is not a serious one, and the warning is not related to the encoding problem that you are seeing. The real problem is the encoding and not the Varchar.

I'm not sure this is a bug; I think the configuration just needs to be adjusted.

Since you have two SAS versions available, what is the encoding on your older (M2) version of SAS versus your newer (M5) version of SAS?

Jim

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Thu, 05 Aug 2021 03:01:22 GMT

Here are the M2 and M6 SAS versions of the encoding, I think the two encoding are the same, which I have considered, so I think it is a encoding problem.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

jimbarbour — Thu, 05 Aug 2021 03:37:14 GMT

Well, something is clearly wrong and character data is being lost, the question is exactly where the problem lies in all the various options and settings. I'm going to have to think about it some more.

In the meantime, this paper has some discussion on the subject:
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4561-2020.pdf

Jim

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

jimbarbour — Thu, 05 Aug 2021 05:08:39 GMT

@zhanghaipo,

If you have a moment, would it be possible for you to run the following code in your M2 environment and also your M6 environment? I would like to see if there are any differences.

PROC OPTIONS GROUP=LANGUAGECONTROL;
RUN;

Thank you,

Jim

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Thu, 05 Aug 2021 06:06:06 GMT

E6 added the DSCAS module, abandoned the use of DS2ACCEL=NONE and DSACCEL = NONE, perhaps updated this piece, resulting in some missing characters in the East Asian SAS version.

Thank you for your help

Haipo

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

jimbarbour — Thu, 05 Aug 2021 15:10:04 GMT

I'm not seeing anything obvious that would cause this issue. @SASKiwi, do you have any thoughts?

Perhaps, @zhanghaipo, you should open a Track with SAS Customer Support. This should not be happening.

Jim

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

SASKiwi — Thu, 05 Aug 2021 20:12:53 GMT

I agree with @jimbarbour 's suggestion regarding Tech Support as I can't test Chinese encoding myself. At least you have a workaround using LATIN1 encoding.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Mon, 09 Aug 2021 01:13:09 GMT

Thank you very much for your help. If I get a solution, I will share it.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

zhanghaipo — Mon, 09 Aug 2021 01:14:42 GMT

Thank you very much for your help. I try not to use stata files to avoid this.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

ChrisNZ — Mon, 09 Aug 2021 01:45:25 GMT

Any reason you're not using UTF-8? This seems to be the standard where data is converging. This would make your data universal.

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

xxformat_com — Thu, 11 Apr 2024 20:14:27 GMT

I don't have the explanation.

I can just share with you that I also have that kind of message when using dbms=xlsx with proc import.

I don't have the message

when using the xlsx engine in the libname statement or
when using dbms=excel with proc import.

The value for of my global encoding option is UTF-8.

Current version: 9.04.01M5P091317

Re: sas9.4 m5 VARCHAR data type is not supported by the V9 engine.

Tom — Thu, 11 Apr 2024 21:02:20 GMT

SAS datasets have two types of variables. Floating point numbers and fixed length character strings. When you convert a XLSX file the columns that SAS guesses should be convert to character variables will be.

So you can just ignore that message. The programmer at SAS that wrote that was confused.