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!
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.
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!
@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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.