Hello,   Do you just want the date included or you want both the date and time?   Here is a possible solution to get you started based on the link you provided. There may be better alternatives. What this creates is an excel file called Tester_28Feb2023. Is that what you were looking for?   %let exportpath=A:\examplefolder\output\Tester.xlsx; filename fileref "&exportpath"; data a(drop=fid); infile fileref truncover obs=1; fid=fopen('fileref'); moddate=scan(finfo(fid,'Last Modified'),1,':'); /*Just give the date portion instead of full date time*/ call symputx('ModDate',Moddate); /*Create a macro variable called ModDate that holds the value of the variable created above*/ run; %put &ModDate; /*Make sure it looks right*/ proc export data=sashelp.class dbms=xlsx outfile="A:\examplefolder\output\Tester_&ModDate..xlsx" replace; run;   ... View more

Hi,  You do not need a semicolon after the datafile= portion in your code. That seems to be the issue. By adding in the extra semicolon, that creates an incomplete proc import statement that technically wouldn't have an out= option. Hopefully that makes sense.   See below for the basic syntax  :     ... View more

Hi,   You forgot to put the forward slash after the ~ in your libname statement. ... View more

Try looking at this post and see if it helps with your question: Reporting the SAS Code Lines by Program ... View more

Hello,    All of our Viya practice labs are hosted in Azure, so there is an expense associated with them. There are 10 hours of lab time provided with the SAS Viya Overview class. The default amount of hours you can choose is 3, but there is a drop down to choose another reservation length.  You can make as many reservations as you'd like in 1 hour increments. It may be that if you are only able to select 3 more hours, you have used up 7 hours already.     If you would like to purchase additional lab time, click on the Extended Learning - SAS Viya Overview link in the course page, and in the upper right block will be an option to purchase more lab time. It’s $75 for 15 hours. If you have additional questions or issues, take a look at the "View the Documentation" link  or you can reach out to EDU tech support at trainingtechsupport@sas.com.   Hope this helps!   ... View more

Hi, would you mind re-posting the three images above your code? We are unable to see them. Also, did your proc import step successfully run to create the table? ... View more

Hi, Thank you for posting a picture of some sample data. I have a few questions for you: Is the data coming from an Excel spreadsheet, csv file, etc? In your data, will the email for row 1 always be missing? What is the relationship between the ID and the emails? I noticed the emails for A and B both correspond to ID 1.  Is the purpose to create a new table or a report? What code have you tried thus far? ... View more

Click below:    SAS OnDemand for Academics Control Center.        ... View more

Depending on your version of SAS, one idea is to write in a little bit of macro code to create an error message.   libname xyz "AnIncorrectPath"; %if &syslibrc ne 0 %then %do; %put ERROR:The library you tried to create does not exist; %end; data example; set sashelp.class; run;     Documentation for %if %then : https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=mcrolref&docsetTarget=n18fij8dqsue9pn1lp8436e5mvb7.htm&locale=en  Documentation for the syslibrc automatic macro variable: https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=mcrolref&docsetTarget=p0vnvc6k3fo349n1aszgd2ls6oxk.htm&locale=en    Even though you are manually creating the error and not EG automatically, hope this helps some. If this isn't what you were going for, feel free to disregard. ... View more