Sas is closing when i run this code... but was working last friday! help please!

[Annie_Fréchette]

Hi! I'm a beginner with SAS. I'm tryin to import some files. Last friday when  I finished my workday everything was fine. But today, I can't run my code! Worse, SAS keeps closing when I submit this few lines... (in blue, see the printscreen). Anyone can help me?  (I have SAS 9.4) Thank you very much!

[Lacona]

I am no SAS specialist, but I can see, that you try to import a .his file and dbms=csv. 
Try to convert your .his in .csv or .xlsx and set dbms=accordingly.

And after checking your code again:
your import file is not starting with /folders/myfolders. Did you install SAS correctly with the connection to the folders/myfolders folder on your computer?

[Annie_Fréchette]

Hi!

Could you explain how can I convert my .his? I'm not familiar with this format....

Not sure how SAS was install on my laptop, but again, everything was working two days ago, so can't figure why this isn't working anymore....

Thanks!:)

[Oligolas]

Hi,

the code looks correct to me. I suspect some Errors in your csv data or either in the previous Statements ran by SAS.

I noticed that in the screenshot you post your SAS is not finished with running a step.

[Annie_Fréchette]

Hi!

I have not touched my data since last friday, so I struggle to understand what is happening and how could it suddenly be some errors in my data...

I open my program than  I run what I've outlined and then SAS crash.... I'm not sure what you mean by "your SAS is not finished with running a step." Sorry if it's evident, I'm really a beginner.

Thanks a lot!

[Tom]

Please post the CODE you are running, not a photograph of your screen.  Use the Insert SAS Code button on the forum editor menu to get a pop-up window where you can post the code.

If SAS is closing try first making sure you do NOT have the ERRORABEND option turned on.  You might also just be having an issue with find format definitions, so make sure you don't have the FMTERR turned on.

option NOFMTERR NOERRORABEND ;

[Annie_Fréchette]

Hi! I'm sorry I don't  don't see the SAS code button... but here is the code:

proc import datafile="C:\doctorat\Projet1-LFR\Données\lactanet\tip files\tipfilesoriginal\18580044.his"
out=f2
dbms=csv replace; getnames=no;
run;

Thanks,

Annie

[Tom]

That code should not cause SAS to stop working.  But it might generate an error if the file is not found.  Make sure ERRORABEND option is turned off.

options noerrorabend ;
proc import
  datafile="C:\doctorat\Projet1-LFR\Données\lactanet\tip files\tipfilesoriginal\18580044.his"
  out=f2 dbms=csv replace
; 
  getnames=no;
run;

[Annie_Fréchette]

hi Tom! I have just tried with your suggestion and it's still not working....

Annie

[Tom]

"Not working" is not enough information to debug with.

Start a new SAS session and try it again.

Start a new SAS session and try to run anything. For example run this:

proc print data=sashelp.class;
run;

[Annie_Fréchette]

Hi!

What I meant is that it is still doing the same thing as  my print screen. I have tried to start a new session and it gaves me the same bug. I've double checked the file location too.

I 've just run the sashelp.class and it went well (no error).

[Tom]

But your original posting did not include any error message.

How large is the file you are trying to import?  Perhaps it is still trying to run?

Did you turn of the NOTES option?  Perhaps the step finished but did not print anything to the log to indicate that.  Can you run the proc print of SASHELP.CLASS after submitting the IMPORT step?

Also are you running on a PC? (I would assume so from the source filename). Perhaps your PC has run out of memory, or really disk space to support virtual memory, and it is just thrashing and taking a long time.

[Annie_Fréchette]

Hi again,

What is in my original post is just a print screen of the log... I can't click on it and copy it, I can't do nothing and a few seconds later SAS shut down.

The file is 266 ko.

I'm workin on a laptop and 142 Go are available.  Here is an overview of what my data looks like.

Thanks again for you help.

[Tom]

That is NOT a CSV file.  Looks like it might be a delimited file with TAB as the delimiter.

Try just reading the file instead of using PROC IMPORT.

For example this code will read the first 10 columns from each line into character variables with a maximum length of 50 bytes.

data test;
  infile "c:\......" dsd dlm='09'x truncover ;
  input (col1-col10) (:$50.);
run;

[Annie_Fréchette]

I have tried your code and again after I click run, few seconds later, SAS is shutting down... If I check my performance disk in the meantime, it goes to 100%... Need to check that.... :S