Good day I want to create a report on data that is missing in my table. For example if I have data: Country City Quarter Amount France Paris 99Q1 10 France Paris 99Q2 15 France Paris 99Q4 20 France Bordeaux 99Q3 50 France Bordeaux 99Q1 50 Italy Rome 99Q2 10 Italy Milan 99Q4 8 Where Quarter is a YYQ. format. I want to create a report summarising the countries that have not provided any amount figures for 99Q3 or 99Q4. Thus my output should be Report Country Missing quarter Cities missing Quarter France 99Q3 Paris France 99Q4 Bordeaux Italy 99Q3 Rome, Milan Italy 99Q4 Rome Any ideas on how to achieve this? The code I wrote extracts exactly the opposite of what I want where I took the Quarter to a SAS date, How can I change it to get the right answer? Data Amount;
set Sasuser.Amounts;
where Quarter='SAS Date for 99Q3' or Quarter='SAS date for 99Q4';
run;
proc print data=Work.Amount;
run;
Proc report Data=Work.Amount nofs headline headskip;
Columns Country Date City;
define Country / Group ;
define Quarter / Group ;
Define City/ across;
run;
... View more
