topic Re: strange error with a simple proc format in SAS Procedures

strange error with a simple proc format

Mic35 — Thu, 30 Apr 2020 16:02:28 GMT

Hi,
Currently I train myself to do a great reporting (on SAS university) and after a few tries I having a problem.

I have uninstalled and re-installed Virtual box and sas several times, the problem persists.
Has anyone ever been confronted at this situation before? Do you have any problem-solving ideas?
Thank you very much.

I coded:

proc format cntlout=titles;
value $title
     "T_01_TITLE01 "= "^{style [just=C fontweight=bold] Title}"
     "T_01_FNOTE01 "='Class table '
     "T_01_ORDER " ='1'
     "T_01_ORIENT " ='L'
     "T_01_BMARK " ='T_01'
; 
run;

I get :

Re: strange error with a simple proc format

ballardw — Thu, 30 Apr 2020 15:58:39 GMT

You need to show more code.

The issue is almost certainly not related to the format but somewhere you have either mismatched quotes around a value or a missing quote. Just like the message.

Show the entire data step code.

And instead of pasting pictures, copy from the log and paste the text into a code box opened on the forum with the </> icon.

That way we can show the actual change likely needed in the code. Pictures are hard to edit.

Re: strange error with a simple proc format

Mic35 — Thu, 30 Apr 2020 16:13:04 GMT

It's not a problem with my code, the only that I used.
Just a proc format....
And at the begining I didn't have problem.. Why I get this error message NOW ?
Maybe uninstalling the virtual machine and SAS is not enough.

Is there a way to make sure that everything is really deleted?

Re: strange error with a simple proc format

Tom — Thu, 30 Apr 2020 16:19:08 GMT

@Mic35 wrote:

It's not a problem with my code, the only that I used.
Just a proc format....
And at the begining I didn't have problem.. Why I get this error message NOW ?
Maybe uninstalling the virtual machine and SAS is not enough.

Is there a way to make sure that everything is really deleted?

So reading between the lines it sounds like you are using SAS/Studio to submit your code. Possibly using the free SAS University Edition.

First thing to try is to Re-start your SAS session. You can do that from the SAS/Studio GUI.

If the problem still exists then check your autoexec file for unbalanced quotes.

Re: strange error with a simple proc format

ballardw — Thu, 30 Apr 2020 16:21:23 GMT

@Mic35 wrote:

It's not a problem with my code, the only that I used.
Just a proc format....
And at the begining I didn't have problem.. Why I get this error message NOW ?
Maybe uninstalling the virtual machine and SAS is not enough.

Is there a way to make sure that everything is really deleted?

None of the code showing an error involves your format. You do not show a complete data step or procedure so it is very hard to tell the exact cause. That very specific and common error relates to some statement that has an incorrect quote. The format doesn't. And the error is not occurring the Proc format code as shown by your picture.

What do you mean "deleted"? Nothing you show would be related to deleting.

Re: strange error with a simple proc format

Mic35 — Fri, 01 May 2020 09:51:24 GMT

The solution was effectively in the autoexec...
one of my macros is a the origin of the error.
I want to investigating what and why i had this message of error in this only step...
Thanks a lot to remind myself cheking this basic step... 🙂