Hi Team,   I have employee count , i have to compare  the employee count loaded previous day with the employee count loaded today.(Note:At any point of time i keep only current data in the report) And if the difference is more than x%, then i have to send an email alert to user. ... View more

Hi Team, I am trying to export the report from Proc report , with the attached input from dataset and optput mentioned in the dataset. I tried , but for me all the months are coming in each quarter proc report data= xxxx; column 'Dept'n 'loc'n 'QUARTER'n,('MonthYear'n,('count'n 'Amount'n)); define 'Dept'n / group; define 'loc'n / group; define 'QUARTER'n / across; define 'MonthYear'n / across; run; ... View more