Thanks for your help ... View more

Thanks for your quick reply. I used the same syntax you have provided. I am getting following out put. I don't want the first six rows. I can use missing function and delete those values. but In my work I have millions of rows (four category variables). I used drop= _freq_ _type_  for my out put data set. So is there any short cut to get the data I want     generated out put . . 426 786 1026 . AAAA 210 390 510 . BBBB 216 396 516 Aug-20 . 138 258 338 Sep-20 . 142 262 342 Oct-20 . 146 266 346 Aug-20 AAAA 66 126 166 Aug-20 BBBB 72 132 172 Sep-20 AAAA 74 134 174 Sep-20 BBBB 68 128 168 Oct-20 AAAA 70 130 170 Oct-20 BBBB 76 136 176   desired output Aug-20 AAAA 66 126 166 Aug-20 BBBB 72 132 172 Sep-20 AAAA 74 134 174 Sep-20 BBBB 68 128 168 Oct-20 AAAA 70 130 170 Oct-20 BBBB 76 136 176   my syntax:   proc summary data=have; class date name; var marks:; output out=want (drop=_freq_ _type_) sum=; run;   Thanks in advance; ... View more