I'm trying to find number of Tuesdays in a year using 2 approaches. I want to know why both give different answers!   Approach : 1 --> total tuesday are 53 %let year = 2024; data count; tuesday_count = 0; do date = mdy(1, 1, &year) to mdy(12, 31, &year); if weekday(date) = 3 then tuesday_count + 1; end; output; keep tuesday_count; run; Approach : 2 --> total tuesday can be 52 as 52 rows are generated data calendar (drop=yr1 yr2); yr1="01jan2024"D; yr2="31dec2024"D; do i=yr1 to yr2; Day=weekday(i); output; end; format day downame3.; run; data new2; set calendar; format day downame3.; where day=4; run; I do know approach 1 is giving correct ans. But can anyone plz explain the logic why approach  2 is generating only 52 rows i.e and not 53 rows?  ... View more

I have completed my Master's in Pharmacy and obtained SAS Advanced Professional Certification.   I have been applying for positions as a Data Analyst and SAS programmer, but unfortunately, I haven't had any success. Consequently, I am interested in utilizing this time to acquire new skills and earn another certification. However, I am uncertain about what path to pursue.   While I am aware of the Clinical SAS certification, I am also interested in exploring other options. Could anyone please offer guidance on what other certifications or skills I could pursue next? I truly appreciate any advice and thank you for taking the time to read this. ... View more