Overall my general understanding of SAS is increasing. I become better and better at debugging my code and I am starting to understand the structure of better. I.e., proc’s sql’s, where statements, etc. However, as I know I am sounding redundant… when I can’t figure it out and get stuck for hours it is extremely frustrating and I loose all confidence that I have gained.
I see how crucial %macro’s are going to be. There is a lot of work involved to set up and structure the data… however once that is done and you set your Macro, you can easily manipulate the data and save lots of time!!!
When I was having trouble with week 4’s assignment, especially the CASE WHEN statements… I ran a proc means to be able to see when I finally had captured the data in the case when statements. I thought it was a good and creative way to see if the code was generating an end result.
emiles blog 