Thanks so much, ballardw!   Your suggestion successfully answered my first question.   For my second question, I had to run proc means by type & specialty to get the mean of visits per year for each specialty.     This is how I used your code:   Proc summary data=freqVisits; class Specialty Year_of_Visit; output out=work.counts; proc print; run;   _type_ = 2 gives results similar to proc freq; tables Specialty; _type_ = 3 stratifies the frequency of visits to each specialty by year.   The following to show how the proc summary statement worked: Specialty Year_of_Visit _TYPE_ _FREQ_ Specialist 2 . 2 77 Specialist 7 . 2 1 Specialist 3 . 2 17 Specialist 2 2003 3 1 Specialist 2 2004 3 1 Specialist 2 2007 3 5 Specialist 2 2008 3 3 Specialist 2 2009 3 5 Specialist 2 2010 3 11 Specialist 2 2011 3 11 Specialist 2 2012 3 10 Specialist 2 2013 3 16 Specialist 2 2016 3 11 Specialist 2 2017 3 3 Specialist 7 2010 3 1 Specialist 3 2010 3 2 Specialist 3 2011 3 1 Specialist 3 2013 3 1 Specialist 3 2014 3 2 Specialist 3 2015 3 11   /* To calculate (mean ± SD) of visits per year */ proc means data = counts; var _freq_ ; where _type_ = 3; run;    The result was the following: Analysis Variable: _FREQ_ N Mean Std Dev Minimum Maximum 17 5.5882352 4.9378490 1.0000000 16.0000000       /* To calculate (mean ± SD)  of visits per year by specialty type*/ proc means data = counts; var _freq_ ; by Specialty ; where _type_ = 3; run;   The results were the following:   Specialty=Specialist 2 Analysis Variable: _FREQ_ N Mean Std Dev Minimum Maximum 11 7.0000000 5.0000000 1.0000000 16.0000000   Specialty = Specialist 7 Analysis Variable: _FREQ_ N Mean Std Dev Minimum Maximum 1 1.0000000 . 1.0000000 1.0000000   Specialty = Specialist 3 Analysis Variable: _FREQ_ N Mean Std Dev Minimum Maximum 5 3.4000000 4.2778499 1.0000000 11.0000000     Thanks so much again!   ... View more

  The code perfectly worked!   Thanks a lot, ballardw.   Appreciated! ... View more

  Thanks, novinosrin, for stopping by & inviting another user to give a hand here! Appreciated! ... View more

Thanks, Reeza, for your valuable response!   Your suggested code made it easy for me to digest the next suggestions!   Appreciated! ... View more

Thanks RW2 for your prompt response!   I'll make sure in the future to post a test data in the future, so it can be tested.   I followed your instructions regarding doing the replacement according to my own case, but unfortunately it didn't work! probably it was my fault!   Appreciated ... View more

Thanks so much, Reeza   I tried this out and it worked! 🙂   Appreciated.     Best Treeva     ... View more

Thanks so much Suryakiran,   The paper has valuable information though it is somehow outdated!   Appreciated. ... View more

Thanks Reeza,   Yes I tried this and also not working. It is definitely the SAS PC Files server issue.       ... View more

Hi Reeza,   Thanks a lot for your response.   I've tried the code and it gave me the following errors:   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.   I believe that the bitnesses of SAS and Microsoft Office don't match. How can I modify your provided code then, please?   Thanks.   ... View more

Thanks so much Reeza,   yes I am using Base SAS, not SAS DI. I've just learned that so my apologies for not making this differentiation ahead while posting my question!  ... View more