BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10

Hello all;

 

I use PC SAS.

 

The sas view: sashelp.vextfl has problem on my pc,it shows me error when i trying to open or use it:

 

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

 

 

Please help.

 

Thanks!

18 REPLIES 18
novinosrin
Tourmaline | Level 20

I tried opening it after:

 

data w;/*I opened this dataset to view the contents*/
set sashelp.vextfl ;
run;

 

EDIT: Sorry ignore, mine works fine. 

ballardw
Super User

Please show the code of what you attempted.

That specific item is one of the system VIEWS, not a data set, and you really should be attempting to anything other than extract or view data.

 

This specific one keeps track of defined external files such as you would assign with a FILENAME statement.

GeorgeSAS
Lapis Lazuli | Level 10

I just simply double click it or code like this :

data w;/*I opened this dataset to view the contents*/
set sashelp.vextfl ;
run;

same error happend:

 

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

 

Thanks!

SASKiwi
PROC Star

If it is just your PC and not others in your organisation I would try re-installing SAS to see if that fixes it. 

ChrisHemedinger
Community Manager

Try a PROC PRINT to see if there are some funky characters in there.

 

data w;/*I opened this dataset to view the contents*/
set sashelp.vextfl ;
run;
proc print data=w; run;
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
novinosrin
Tourmaline | Level 20

Did that, and attached here is the screen shot of proc print results

GeorgeSAS
Lapis Lazuli | Level 10

my result looks like that.

Thanks!

GeorgeSAS
Lapis Lazuli | Level 10

I just realize although there was error but the dataset w was created successfully.

 

But if I just double click the sas view sashelp.vextfl.

 

It can't be opened and comes with those errors too.

 

To Chris,

The w dataset and its print has no problem.

 

 

also this can print it too, but has error in log:

proc sql;
select * from
sashelp.vextfl;
quit;

 

 

Thanks

 

GeorgeSAS
Lapis Lazuli | Level 10
1.looks the print and refer to it will get right result but come with error message.
2.double click not work to open the view
ChrisHemedinger
Community Manager

Try the workaround in this SAS Note.

 

   proc sql;
     create view work.extfiles as
     select fileref, xpath, xengine, level, directory, 'exists'n, temporary
     from dictionary.extfiles;
   quit;
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
GeorgeSAS
Lapis Lazuli | Level 10

Here is the result of this:

   data _null_;
file "c:\temp\output.txt";
set extfiles;
put _all_ ; 
run;

 fileref=#LN00004 xpath=TERMINAL xengine=TERMINAL level=0 directory=no exists=no temporary=yes _ERROR_=0 _N_=1
fileref=#LN00006 xpath=C:\Users\ABC123456\Documents xengine=DISK level=0 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=2
fileref=#LN00008 xpath=C:\Users\ABC123456\Desktop xengine=DISK level=0 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=3
fileref=#LN00014 xpath=c:\temp\extfiles.txt xengine=DISK level=0 directory=no exists=yes temporary=yes _ERROR_=0 _N_=4
fileref=_CMD xpath=net use xengine=PIPE level=0 directory=no exists=no temporary=no _ERROR_=0 _N_=5
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\core\sasmsg xengine=DISK level=1 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=6
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\accelmva\sasmsg xengine=DISK level=2 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=7
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\access\sasmsg xengine=DISK level=3 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=8
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\af\sasmsg xengine=DISK level=4 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=9
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\dmscore\sasmsg xengine=DISK level=5 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=10
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\ets\sasmsg xengine=DISK level=6 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=11
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\etscomp\sasmsg xengine=DISK level=7 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=12
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\graph\sasmsg xengine=DISK level=8 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=13
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\iml\sasmsg xengine=DISK level=9 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=14
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\insight\sasmsg xengine=DISK level=10 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=15
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\lab\sasmsg xengine=DISK level=11 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=16
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\or\sasmsg xengine=DISK level=12 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=17
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\qc\sasmsg xengine=DISK level=13 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=18
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\spdsclient\sasmsg xengine=DISK level=14 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=19
fileref=#LN00001 xpath=C:\Program Files\SASHome\SASFoundation\9.3\stat\sasmsg xengine=DISK level=15 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=20
fileref=#LN00002 xpath=C:\Program Files\SASHome\SASFoundation\9.3\connect\saslink xengine=DISK level=0 directory=yes exists=yes temporary=yes _ERROR_=0 _N_=21
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\core\sasmacro xengine=DISK level=1 directory=yes exists=yes temporary=no _ERROR_=0 _N_=22
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\accelmva\sasmacro xengine=DISK level=2 directory=yes exists=yes temporary=no _ERROR_=0 _N_=23
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\assist\sasmacro xengine=DISK level=3 directory=yes exists=yes temporary=no _ERROR_=0 _N_=24
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\dmscore\sasmacro xengine=DISK level=4 directory=yes exists=yes temporary=no _ERROR_=0 _N_=25
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\eis\sasmacro xengine=DISK level=5 directory=yes exists=yes temporary=no _ERROR_=0 _N_=26
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\ets\sasmacro xengine=DISK level=6 directory=yes exists=yes temporary=no _ERROR_=0 _N_=27
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\graph\sasmacro xengine=DISK level=7 directory=yes exists=yes temporary=no _ERROR_=0 _N_=28
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\iml\sasmacro xengine=DISK level=8 directory=yes exists=yes temporary=no _ERROR_=0 _N_=29
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\or\sasmacro xengine=DISK level=9 directory=yes exists=yes temporary=no _ERROR_=0 _N_=30
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\qc\sasmacro xengine=DISK level=10 directory=yes exists=yes temporary=no _ERROR_=0 _N_=31
fileref=SASAUTOS xpath=C:\Program Files\SASHome\SASFoundation\9.3\stat\sasmacro xengine=DISK level=11 directory=yes exists=yes temporary=no _ERROR_=0 _N_=32

GeorgeSAS
Lapis Lazuli | Level 10

Hello Chris,

 

I reduce the program error range from you code: I found the error happen only when I select modate column.

if I don't select modate column will be ok.

proc sql;
create view work.extfiles2 as
select fileref, xpath, xengine, filesize,/*modate*/ level, directory, 'exists'n, temporary
from dictionary.extfiles;
quit

By the way, May I ask what is the usage of 'exists'n here? it will not work if i use the original column name exists.

 

Thank you!

 

GeorgeSAS
Lapis Lazuli | Level 10

I doubt about this line of the output :

 

fileref=_CMD xpath=net use xengine=PIPE level=0 directory=no exists=no temporary=no _ERROR_=0 _N_=5

 

(because if I keep modate variable,the output will be truncated just before this row, also its content looks strange than others).

 

 

Thanks!

ballardw
Super User

@GeorgeSAS wrote:
1.looks the print and refer to it will get right result but come with error message.
2.double click not work to open the view

Which version of SAS are you running?

And another approach would be try the SAS command box with vt sashelp.vextfl, which theoretically should be the same a clicking on the dataset/view but sometimes one never knows.

 

Does this also happen after restarting SAS?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 18 replies
  • 1436 views
  • 3 likes
  • 7 in conversation