Thank you so much for your solution and explanation. It's really helpful for me! ... View more

@wbsjd wrote: The SAS Log show no error and is like this: I really don't know what's the issue. I highlighted an error in your understanding above. Your output clearly shows RC=20006. From the documentation of the FCOPY function, which is what your Put RC= would be printing from your %ZIP macro, Values That Are Returned by the FCOPY Function FCOPY returns these values: a value of 0 if records were copied without errors or warnings a positive value if an error occurred a negative value if a warning was issued The magenta is where you did not understand that your code was throwing an error. Follow up with: You can use the SYSMSG function to retrieve error or warning messages, and you can use the SYSRC function to retrieve the return code. So you might use something like if rc ne 0 then do; message=sysmsg(); put message; end;     ... View more

Add files to a ZIP archive with FILENAME ZIP By Chris Hemedinger on The SAS Dummy March 4, 2016 https://blogs.sas.com/content/sasdummy/2016/03/04/add-files-to-a-zip-archive-with-filename-zip/   BR, Koen ... View more

My understanding is these library definitions are stored in SAS metadata. You can use SAS Management Console to restore from a metadata backup from before you deleted the library. You will however lose any metadata changes made since then. By default SAS metadata is backed up daily.   Select Metadata Manager ==> Metadata Utilities ==> Server Backup to list the available backups to restore from. To restore just right click on the required backup, and select Recover from this backup. You might want to do a backup first before restoring just in case you need to revert. ... View more

Actually without examples of the data sets A and B I would not suggest an SQL "equivalent" because MERGE treats same-named variables that appear in both data sets, other than the by variables, quite differently than an SQL join of any flavor. If you have other variables of the same name to get the the same result with SQL you would need either Coalesce(b.varname,a.varname) as Varname for Numeric variables or Coalescec(b.charvar, a.charvar) as Charvar for each pair of like named variables.     ... View more

We are converting all our projects from Base SAS to SAS DI Studio. In SAS DI Studio, most transformations are based on SQL instead of data step. Thus I am trying to translate our code from SAS data step to Proc SQL. I think I will use User Written transformation in the SAS DI studio to include this data step, that works. Thank you for answering my question~ ... View more

Your solution is awesome, works perfectly, thank you so much! ... View more

The code you posted is just the definition of a macro. So it wouldn't actually do anything since there is no actual call to the macro.   But if it is getting stuck then perhaps you did submit something that actually calls the macro?   Why does the code have double slashs in the paths? Does the machine where the scheduler is running the job actually have a physical F: drive?  If that is a mapped drive is the drive actually mapped for the process that is running the scheduled job? ... View more