Hello All, The question is you have unique policy ID# and each PolicyID# can have more than 1 vehicleID. So I want an individual report of policy# with the highest # of vehicleIDs. So in this case the policyID 102 had highest vehicleIDs and I want it to be displayed on the top of the report so in descending ORDER. I know proc report is one way, can you please tell me any other method to get the same output. Below is code that I used to figure using proc report, everything works but it doesn't create the output in descending. Please HELP...I need the answer soon...Thanks. data insurance; input policy_id$ vehicle_id$ ; cards; 100 ABC 100 XYZ 100 JLI 101 EFG 102 HIJ 102 KLM 102 NOP 102 QRS 102 TUV ; run; Proc Report Data=insurance nowd; by policy_id; column policy_id vehicle_id; Define policy_id / group; Define vehicle_id / order order=freq;
... View more