Also I am sorry the problem does ask for the booksales. I did not share the problem statement. But I do get the idea of what you are trying to convey. TY Paige! ... View more

Sure, I am on this chapter trying to learn these concepts and was working out some homework problems. I will look up proc.summary too. TY! ... View more

Thanks Kurt, will read up on those links! Appreciate it! ... View more

Thanks Paige, appreciate your help in understanding the concepts and how they work.  ... View more

Also if I did not have a if last.code statement, I am presuming it automatically ouputs the last variable values from the first.code statement. I hope I am correct in assuming this. TIA! ... View more

Oh awesome, Thanks Paige,  I have another follow up question reg the initialization of variables in the data step: this is the code : and the partial output (which is what I am looking for): However if I do this: explicitly state a var statement and use assignment then it prints booksales as empty values. The total sales is. correct however.  I presume I have initialized the variables in the if first.date conditional. Can you please shed some light on this as to why the booksales is showing as empty. TIA!! partial output     ... View more

Wow, didnt knwo it is that big a thing that books have been authored on the same. Will try to look up. TY! Do you know of any papers/ books that show examples of comparinc contrasting each one's usage and functions. That will be super helpful to understand the limitations or usages so to speak. TY! ... View more

Thanks Tom, dumb me, I saw only the partial data in the mechanics dataset. TYSM!!🎯 ... View more

But how does it know how to access those datasets that have both the values in them? I have not specified paths for them anywhere. Also what if there did not exist a data set in that same file path that has these values for both? How would SAS determine the values in that case? Also for the freq disbns for the Gender and JObcode I specified the file path to those data sets . The code is as below: Thanks for you answer! ... View more

Thanks Bart, for kindly sharing so many resources. I will go through them. Appreciate it! ... View more

Wow this is amazing, thanks for pointing me to this Kathryn. 🙏 ... View more

Thanks Paige, appreciate the prompt response. So am I right in understanding that at the point of time SAS reads the first line, it is agnostic of what the second or other lines may be in the data file? So it works more as an interpreter than a compiler? But I read there is compiling happening when we 'run' SAS code. Curious to know what happens in this 'compilation' vs. the interpretation.  ... View more