Hello Everyone~   I am reading data from Excel to SAS.  In excel the requested Date is like the the below, a date time format, However, after I Proc Import the Excel file to SAS, the time became a long ridiculous number.    Can anybody help me to solve this problem?    Thank you so much! ... View more

Hello everyone   The following SAS code which is to move a xlsx file to a zip file works perfectly, filename xfile "y\test.xlsx" recfm=n; filename zfile zip "y\archive\Processed.zip" member="test.xlsx" recfm=n; data _null_; rc=fcopy('xfile','zfile'); put rc=; rc=fdelete('xfile') run; However, there are multiple xlsx files in the same directory need to be moved to the zip file. I put the above code in a Macro, but the filename statement not working in a Macro. %macro zip (file_name=); filename xfile "y\&file_name..xlsx" recfm=n; filename zfile zip "y\archive\Processed.zip" member="&file_name..xlsx" recfm=n; data _null_; rc=fcopy('xfile','zfile'); put rc=; rc=fdelete('xfile'); run; %mend; data _null_; set files; call execute('%nrstr(%zip(file_name='||strip(file_name)||'))'); run; Can you please advise how to modify the second SAS code.    Thank you in advance ... View more

Hello Everyone,   I need to read external xlsx file into SAS, and then put the processed xlsx file into an archive zip file. Previously, we do this using X command, but this option is not available now. Is there any other ways to put xlsx file into zip file without using X command and requiring XCMD privileges?   Thanks a lot for answering my question. ... View more