Also  libname _all_;  works to deassigned libraries ... View more

Hi Mike_Davis,   Was your issue solved. I'm facing a similiar issue - to create an executable file without showing the contents of the code.  ... View more

got you ... View more

As others have stated, you are missing a closing quotation mark at the end of your infile statement fileref.  The file format is also quite simple. data subs; infile '/path/to/file.srt' truncover ; input #1 id       #2 xstart_time $12. +5 xend_time $12.    #3 sub $200.    #4 ; format start_time end_time time12.3 ; start_time = input( translate( xstart_time , '.' , ',' ) , time12. ) ; end_time   = input( translate( xend_time   , '.' , ',' ) , time12. ) ; drop xstart_time xend_time; run; ... View more

Maybe this is something you are looking for...? http://support.sas.com/documentation/cdl/en/graphref/65389/HTML/default/viewer.htm#p0ewjb7mkcqfj5n1kkf40i7vuj63.htm ... View more

It really should have little effect. To me it looks like someone wanted to attach a format and accidentally typed INFORMAT instead of FORMAT.   As Art mentions the main effect will be to cause SAS to place HEIGHT as the first variable and set the name as a 'height' instead of 'Height'. It is very hard to tell what the purpose is without a comment from the original coder.  Possible purposes: - The changes that it causes. - They plan to edit the file interactively with FSEDIT and want to be able to type or paste in values with commas. - They want to set the attached informat metadata to help document the variable. ... View more

Or type ODSTEMPLATES in the command bar. PG ... View more

Thanks Art, In this case the nightmares started before I added STRACE.  I have a simple join that is running in a stored process.  Reading data from an oracle database, using a libref defined in the metadata that uses SAS/ACCESS to Oracle. The stored process ran fine a week ago.  Now the join is crashing a "call tech support" segmentation error. It's very much like http://support.sas.com/kb/20/460.html but I'm not using views (and I'm on 9.3). What's driving me crazy is that it worked last week.  And now the join works if I run it from EG, works if I batch submit it , and works if I run the stored process on the workspace server.  So I think I'm going to have to ask the admin to just restart the stored process server, and see if that helps... --Q. ... View more

Or You can add the path of excel into environment variable PATH , then you can directly use command EXCEL . x "excel" ; ... View more

Interesting , If you use another engine XLS ,you will different result: PROC IMPORT OUT= _test2 datafile="c:\temp\oops.xls" DBMS=xls REPLACE; GETNAMES=YES; MIXED=YES; RUN; Ksharp ... View more

Mike, You can do it by including a Range statement.  It is described at: http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm ... View more

FILENAME MyFile "C:\temp\aa\cc\test8.xls"  ;   DATA _NULL_ ;     rc = FDELETE('MyFile') ;   RUN ; FILENAME MyFile CLEAR ; PROC EXPORT DATA=sashelp.class OUTFILE = "C:\Temp\aa\cc\test8.xls" DBMS = excel2002 REPLACE; SHEET = "a"; RUN; this will delete all sheet including b,c,but work for a ... View more

Mike: In answer to how to open a ticket with tech support:  http://support.sas.com/ctx/supportform//createForm Weren't there a number of other posts in this thread?  If you delete a message you end up also deleting all of the responses to that message. ... View more