You can't read native Excel spreadsheets with INFILE. However if you save your Excel spreadsheets as a delimited file, for example CSV (comma delimited) you can then PROC IMPORT these files using DBMS = CSV or DLM, or an INFILE using the DLM option. ... View more

Actually if you have SAS 9.2 you can do it. Check this out: http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#win-func-finfo.htm ... View more

Are the files date-stamped in any way? If so something like this may help: data _null_; rc=filename('mydir','c:\mydir'); did=dopen('mydir'); numopts=doptnum(did); memcount=dnum(did); if (memcount gt 0) then do i = 1 to memcount; filename=dread(did,i); fid = mopen(did, filename,'i',0,'d'); optname=foptname(fid,2); recfm=finfo(fid,optname); optname=foptname(fid,3); lrecl=finfo(fid,optname); rc=fclose(fid); put filename = recfm= lrecl=; end; rc=dclose(did); run; Unfortunately you can't get the file dates this way, but you can get the names. ... View more

That's correct. CONNECTWAIT = no means SAS does not wait for the RSUBMIT block to complete before running subsequent steps. This allows you to process in parallel as long as you are doing it in different remote sessions, which you appear to be doing. ... View more

What happens if you run just one RSUBMIT batch and wait for it to finish? Does it work OK? If it does, then I think that interaction between batches (possibly processing the same datasets at the same time) when you do multiple RSUBMIT batches may be the problem. Try CONNECTWAIT = YES to force all of your batches to run consecutively. Do the batches now work OK? ... View more

I assume you are outputing to Excel using EXCELXP tagsets although you don't say so explicitly. If so then you can use: ods tagsets.excelxp options (SHEET_NAME = 'Mytab' SHEET_INTERVAL = 'NONE') ; before your PROC REPORT code so that the two reports stay in the same tab. ... View more

Please note that a hash merge is not the only way to improve performance. A lookup SAS format created from your product table can also be a lot faster and simpler to code.The number of discrete loan numbers are you joining on should influence your chosen lookup technique. Be aware there are memory limitations with both hash tables and lookup formats. ... View more

You can also bypass this problem by running the program in batch mode: from a command line type SAS -SYSIN "mysasprog.sas" ... View more

Agreed. For large numbers of levels MEANS/SUMMARY using BY also runs a lot faster than using CLASS, at the expense of having to sort first. ... View more

Have a look at your SASAUTOS SAS option. To keep both your own AUTOCALL macros plus the SAS ones you could try something like this: options SASAUTOS=(MYAUTOS, SASAUTOS); The MYAUTOS DD points to your AUTOCALL macros and this is concatenated in front of the SAS SASAUTOS so you should be able to use both. ... View more

I came up with a list of 16 SAS notes when I searched SAS Support for your error. I suggest you check these out yourself as they are operating system and SAS version specific. One possibility since you are on Unix is that file permissions may not be set correctly for SAS and/or Oracle files. ... View more

My guess is the NOSYNTAXCHECK SAS option was causing this issue. With this option off then SAS goes into syntax check mode and the OBS option is set to 0 so no code step processes any data. This option is set differently for batch versus interactive SAS sessions by default so you can get different symptoms when an error occurs. Message was edited by: SASKiwi ... View more

Check out the NOPRINT option on the REPORT DEFINE statement: define example / sum NOPRINT 'Example Not Printed'; ... View more

Something like this might do the trick without any pre-processing: proc sql; create table test2 as select x ,y ,z ,sum(missing(a)) as miss_count from test group by x, y, z ; quit; ... View more

Grace, just so you know how I found it I searched on: System.IO.FileNotFoundException and it was about the 5th listed note. You can use the exact text of a SAS error to locate relevant notes. ... View more