Can you please try looking at this usage note and see if that helps. Also try rebooting the metadata server and please don't forget to do a backup before. Usage Note 18363: Troubleshooting guidelines for successfully sending an SMTP e-mail from SAS® software   Hope this helps.   Carmine ... View more

The code worked for me, so not sure why your code isn't.  ... View more

Now unfortunately, you are not really learning anything if i do it all for you. 😞    options noxwait; data _null_; /* x "copy c:\temp\testdata.txt c:\temp\testdata_&date..txt";*/ rc= system("copy f:\a\Covid19_report &todaysdate. &time..xlsx f:\b\1_Covid19_report &todaysdate. &time..xlsx"); rc= system("copy f:\a\Covid19_report &todaysdate. &time..xlsx f:\b\2_Covid19_report &todaysdate. &time..xlsx"); rc= system("copy f:\a\Covid19_report &todaysdate. &time..xlsx f:\b\3_Covid19_report &todaysdate. &time..xlsx"); rc= system("copy f:\a\Covid19_report &todaysdate. &time..xlsx f:\b\4_Covid19_report &todaysdate. &time..xlsx"); rc= system("copy f:\a\Covid19_report &todaysdate. &time..xlsx f:\b\5_Covid19_report &todaysdate. &time..xlsx"); put rc=; run;   I would highly recommend you take some SAS training as even though I gave you the solution, you might end up with an error and won't be able to solve it.  The best thing to do is to try to make yourself as self-sufficient as possible and the only way to do this is with educational training.  We have several online training courses that you can choose from. Based on your coding question i would recommend you start with the Programming 1 class. There is a free e-learning version available which is a great starter course. From there I would recommend you also take the 2-day Programming 2 class. Followed by a SAS 2-day Macro 1 class. ... View more

Yes ... View more

You will need to have x command enabled to get this to work. To verify if you have x command enabled. Try and execute this statement in a program editor. If your server runs on windows environment ,   x "DIR";  or  if your server runs on Linux environment ,  x "ls";   If code works above then you should be able to use example below. If it doesn't then you will need to speak to you SAS administrator to get x commands enabled for this to work.   options noxwait; data _null_; /* x "copy C:\temp\book1.xlsx  C:\temp\book2.xlsx";   or  */ rc= system("copy C:\temp\book1.xlsx C:\temp\book2.xlsx"); rc= system("copy C:\temp\book1.xlsx C:\temp\book3.xlsx"); rc= system("copy C:\temp\book1.xlsx C:\temp\book4.xlsx"); put rc=; run;     ... View more

Hmmm not entirely sure why the VB code isn't working.  You might want to try the Microsoft Community site for VB code Visual Studio Community 2019 - Free IDE and Developer Tools (microsoft.com)       ... View more

  So based on the link you sent, you are trying to call a stored process via a Hyperlink.   First, you need to determine what the stored process web application location is. Which looks like this…  http://yourserver/SASStoredProcess Make sure the link above works before combing it with the stored process name and location.   The rest of the link to the SP would look something like this… “do?_program=/WebApps/Sales/WeeklyStoredProcess” You can get this location of your stored process by right-clicking on the stored process from the SAS Folders section in Enterprise Guide and then eventually combining the two.   Hope this helps. Carmine ... View more