Traditional SAS Programming versus SQL

[manaviswesh]

how to create subcategories as in the below picture 

[PeterClemmensen]

Hi and welcome to the SAS Communities 🙂

If you want a good and usable answer, you have to give us more than this.

Do you have some data?

What does it look like?

What does your desired result look like?

Have you written some code already?

[VDD]

when it comes to programming a picture is not worth a 1000 words.

[ballardw]

What is the question involving "traditional SAS Programming versus Sql"?

The actual data you have and the actual requirement may point to a preferred method or both may be used together.

Considering the appearance, I would almost suspect than somewhat "non-traditional" code as either Proc ODSLIST or the Report Writing Interface in a data step may be one of the tools to generate that sort of output layout.