Hi @melissagodfrey, did everything work out for you? ... View more

@srenivas661,   Hello. I would start by taking the free SAS® Programming 1: Essentials e-learning course. That course can be found here.   On that page you can also search for in person classes or live web instruction.   - Peter ... View more

Hm that is weird. I took your code and tested it and it works for me. I even check the first few rows for each year in your workbook and they look accurate. The by statement in the frequency procedures is working. Why your titles aren't changing I am not sure of yet.     Do me a favor and check your SAS output not the Excel file. How does it look in your results tab? You should see the year breaks like this:   ... View more

Yeah completely understandable.Since many who are using Enterprise Guide are connected through a server the video accounts for this and will show you how to create the data and store it in your WORK library to allow those of you on a server to access the data.   The video will show you how to set it up so that every time you are planning on working on the course you can run the programs so the data is created and placed in your WORK library. Since you are on a server you will need to run the program the video shows you every time you are working on the course. Remember once you close out of SAS the work library is cleared. So when you reopen Enterprise Guide to work on the course you will have to recreate the data.   Did you a create the autoexec process flow for the two SAS programs like it show in the video? Here is a screenshot of the end of the video and what your project tree should look like:                         You might of missed a step for the Enterprise Guide setup since it is different from the others.       ... View more

@yayicecream,   Here is the link for the videos to get your data ready : How to access data for SAS Programming 1 course     When you go to the page, scroll to the bottom. There you will find a video for Enterprise Guide instructions.   Let us know if it works,     - Peter ... View more

There was, thank you. I copied at pasted it from my previous post.   @alirezaje, here is the link again. I apologize for that.   File storm_summary.sas7bdat not found - Post Solution   - Peter ... View more

Hi @alirezaje,   Check out this thread, I believe you were having a similar issue. It contains the setup instructions document and a video if you want to follow it.   Please let us know if it helps,   Thanks!   - Peter ... View more