Thank for the response. This was the code written before Transpose. data a; input route $ count region date9.; datalines; Route1 17 12Jun2018 Route2 4 13Jun2018 Route3 17 22Jun2019 Route4 5 01Feb2019 Route3 6 01Sep2019 Route6 1 08Sep2019 Route2 17 15May2019 Route1 4 11Jun2018 ; run; proc sort data=a out=b nodupkey; by route count; run; //below i used weekv6. format proc print data=b; format region weekv6.; / run; Now i need to do grouping of it , hence tried with below code , However does not work, could you please suggest, How i can do it. proc sql; select route, sum(count) as Count , region format=weekv6. from b group by route , region; run;
... View more