topic Re: PROC GLM Error message: Invalid characters in Statistical Procedures

PROC GLM Error message: Invalid characters

Jeff11 — Fri, 20 Jan 2017 16:13:44 GMT

Hi,

The following code produced the desired results using SAS 9.4.

PROC GLM DATA=IMPORT;
CLASS v1 v2;
MODEL v3= v1 v2;
MEANS v2/TUKEY;
TITLE 'Repeated Measures ANOVA FOR v3 with Tukey POSTHOC';
RUN;

However, running it with SASUniversity (Studio) produces the following error message:

ERROR: Invalid characters were present in the data.

I tried converting my dataset to excel and SPSS before importing back to SAS. All variables are numeric. Nothing worked.

Thank you for your help,

Jeff

Re: PROC GLM Error message: Invalid characters

ballardw — Fri, 20 Jan 2017 16:50:05 GMT

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.

You can create data step code from your existing SAS data set following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 That will create code that you can post in a code box using the forum {i} icon or attach as a data step.

Re: PROC GLM Error message: Invalid characters

Rick_SAS — Fri, 20 Jan 2017 18:37:13 GMT

I suspect the data are corrupted. If you do a PROC CONTENTS and PROC PRINT data=Have(obs=5)

PROC PRINT data=Have(obs=5); run;

I suspect you will see the problem.

The different behavior might be because the import step on the virtual machine (which uses UTF-8 encoding) is transcoding character variables differently than your local machine.

Re: PROC GLM Error message: Invalid characters

Damo — Thu, 31 Aug 2017 15:47:16 GMT

Hi @Jeff11

This is an "old" post but if the issue remains, can you try to change the User locale and set it to English

Then when you rerun your GLM procedure, what is the outcome?

Cheers,

Damo

Re: PROC GLM Error message: Invalid characters

Damo — Wed, 06 Sep 2017 10:01:48 GMT

Hi All,

Just in case of...

The actual solution consists in updating your browser language as it my night be possible to access SASPreferences with SAS University Edition.

If you use English, it should work.

Cheers,
Damien

Re: PROC GLM Error message: Invalid characters

Jeff11 — Thu, 07 Sep 2017 14:02:59 GMT

Hi Damien,

Our research group actually decided to purchase a SAS license, so I no longer use SAS University. Thanks anyways for answering my question.

Cheers,

Jeff