Desktop productivity for business analysts and programmers

Proc SQL ignores formats that are not loaded, without producing an error

Accepted Solution Solved
Reply
Contributor
Posts: 74
Accepted Solution

Proc SQL ignores formats that are not loaded, without producing an error

SAS-EG version 5.1

In SAS-EG, the data step gives an error, but proc sql doesn't.

In SAS-EG, proc sql just ignores those formats that are not loaded and outputs unformatted data

Is this by design?

Is there a system option or a preference that would show this kind of an error?

(I couldn't find one)

Proc sql in Base SAS gives an error, saying that the format could not be loaded -- in both data step and proc SQL.

Sample code (first format is real, second format is fake but doesn't produce an error in SAS-EG)

proc sql;

  select height format=comma10.5  as ht1

        ,height format=comet10.5  as ht2

  from   sashelp.class

;quit;


Accepted Solutions
Solution
‎08-04-2014 01:46 PM
Community Manager
Posts: 2,693

Re: Proc SQL ignores formats that are not loaded, without producing an error

EG sets the NOFMTERR option, which controls the behavior you're seeing.  See background here:

Do me a favor: stop doing me favors - The SAS Dummy

You can change this by submitting OPTIONS FMTERR; in your program, reversing the default behavior set by EG at startup.

Chris

View solution in original post


All Replies
Solution
‎08-04-2014 01:46 PM
Community Manager
Posts: 2,693

Re: Proc SQL ignores formats that are not loaded, without producing an error

EG sets the NOFMTERR option, which controls the behavior you're seeing.  See background here:

Do me a favor: stop doing me favors - The SAS Dummy

You can change this by submitting OPTIONS FMTERR; in your program, reversing the default behavior set by EG at startup.

Chris

Contributor
Posts: 74

Re: Proc SQL ignores formats that are not loaded, without producing an error

Thank you very much for pointing me to the FMTERR option.

I should've looked a little further -- to system options, not just SQL options

My small confusion is that SAS-EG does produce a format error in the data step -- just not in proc sql -- that's why I was looking for an sql option.

Thank you for instructions on viewing the initialization log. This is nice to know.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 228 views
  • 0 likes
  • 2 in conversation