PC error for sas view sashelp.vextfl

[GeorgeSAS]

PC SAS 9.3 (will be upgraded to 9.4 soon)

I tried vt sashelp.vextfl get same thing, same error log and can't open it.but thank you for teach me the magic method.

it happens after not only I restart SAS but also restart my computer

error log:

ERROR: Invalid Operation.
ERROR: Termination due to Floating Point Exception

Thanks!

[DaveBirch]

So it looks like modate is the offending variable. My guess is that the operating system or file system is passing some value like 00/00/00 to SAS.  Further, I'd guess that is either the TERMINAL or the PIPE that is the offending external file.  Try seeing whether WHERE XENGINE NOT IN('TERMINAL','PIPE') gets rid of the problem.  You may need decide which variables/rows you really need.

[GeorgeSAS]

I think maybe this caused by our system is upgrading to use SAS grid. the value(modate) can't be browsed(double clicked) or assigned dynamically.

And Chris,May I ask  what is the "select 'exists'n from  dictionary.extfiles"  used in proc sql to create view/table? why i can't use 

"select exists from  dictionary.extfiles"??

is that for markup the reserved  keywords?

 proc sql;
     create table test111 as
     select 'exists'n as a ,exists as b
     from dictionary.extfiles;
   quit;

Thanks!

[Tom]

---

@GeorgeSAS wrote:

I think maybe this caused by our system is upgrading to use SAS grid. the value(modate) can't be browsed(double clicked) or assigned dynamically.

And Chris,May I ask  what is the "select 'exists'n from  dictionary.extfiles"  used in proc sql to create view/table? why i can't use 

"select exists from  dictionary.extfiles"??

is that for markup the reserved  keywords?

 proc sql;
     create table test111 as
     select 'exists'n as a ,exists as b
     from dictionary.extfiles;
   quit;

Thanks!

---

PROC SQL cannot figure out that you want to use EXISTS as the name of a variable and not as the SQL keyword EXISTS.  By formatting your query using a name literal helps SAS understand that you mean a variable name.  You can also use the DQUOTE=ANSI option on the PROC SQL statement to have SAS consider strings in double quotes as representing variable names, as is done in a number of other SQL implementations.

proc sql dquote=ansi;
  create table test111 as
     select "exists"
     from dictionary.extfiles
  ;
quit;