Hi, Can I please get some help with this. The Destination Table contains a list of customers who holidayed last year to DESTINATION Europe, or remained in NZ for their holidays. A customer may have had holidays in both Europe and NZ. The layout for the table is shown below: I would like to create a report that shows the precentage of customers, who went to Europe last year, but based on Customer_Age: 20 – 29, 30 –39, 40 – 49, 50+. And the report should only show the Age Range and the Percentage of Customers who went to Europe for their holiday. How can I implement an Age_Range in this report? Would I be right to do it with PROC FORMAT? Something like: Proc format ; value Customer_Age; 18 - 29 = ' Age Range 20 – 29’ 30 - 44 = ' Age Range 30-39' 45 - 59 = ' Age Range 40 49' 60 - high = ' Age Range 50+'; run; and then I would start like below, but I am not sure how to link my Age Range . I thought the Proc format creates the Group that I can define and analyse using a computing block. But I am not really sure how it connects. Help much appreciated Proc Report Data = Holiday headline headskip; title1 "Customer Holiday Report"; COLUMN CUSTOMER_AGE('_Destination_' Destination = pct); DEFINE CUSTOMER_AGE /GROUP FORMAT=8. ; DEFINE pct /GROUP FORMAT=8. FORMAT=PERCENT8. ; RBREAK AFTER /SUMMARIZE UL OL; RUN; CUSTOMER_NUMBER CUSTOMER_AGE DESTINATION 123 27 NZ 123 27 Europe 124 42 Europe 125 33 NZ 126 45 Europe 127 60 NZ 128 45 Europe 129 62 Europe 130 33 Europe 131 58 Europe 132 34 Europe 133 49 Europe 133 49 NZ 134 33 Europe 135 45 NZ 136 60 NZ 137 45 NZ 138 62 NZ 139 33 NZ 140 45 Europe 141 60 Europe 142 45 Europe 143 62 Europe 144 33 Europe
... View more
