Hello I work exclusively in SAS Enterprise Guide and have had the same problem that you have. I solved mine by directly accessing the Windows DLL that contains the copy/move function by using the SASCBTL attribute table with the MODULE family of call routines and functions. Below is a link to a paper that I wrote for SESUG 2010 that describes how to do this. paper http://analytics.ncsu.edu/sesug/2010/CC06.Putnam.pdf SAS DOC http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#accdll.htm Enjoy D ... View more

Hi Patrick Thanks for your input. However, this feature is disabled for me. Since I remotely work on SAS server using SAS Enterprise Guide, many features like Excel Engine are disabled. So, whatever you have suggested doesn't seem to work for me. Please suggest any other approach. Thanks Shankar ... View more

Hi, Shankar Here's a (slightly modified) piece of code that I use in EG on XP. It uses the SAS "External Files" functions to find the files in a directory. I only need the filename, but there's an "FINFO" function that you can probably use to get date information. Tom data work.dsns(keep=infref); length infref $ 64; rc=filename("htmldir","c:\Source"); htmld=dopen("htmldir"); dsncount=dnum(htmld); do i = 1 to dsncount; infref = dread(htmld,i); end; rc=dclose(htmld); run; ... View more

Just to make it easier I checked this solution out on SAS 9.2. Just change the C:\mydir to the directory you want to check: [pre] 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); optname=foptname(fid,5); last_updated=finfo(fid,optname); rc=fclose(fid); put filename = recfm= lrecl= last_updated = ; end; rc=dclose(did); run; [/pre] ... View more

Maybe you need to use Google to search some software which can convert xls into csv automatically. Ksharp ... View more

I normally use PROC Datasets in SAS enhance editor .. I dont know if this is useful to you .. Thanks ... View more