Freezing columns

[Medanmani]

Hi frnds,i have one data with above 60 columns,every time i unable to go last column in the dataset,
Can anyone tell how to freeze the data for 1st 5 columns

[Medanmani]

In a dataset total 36 columns with variable names ,i want every 6 variable names has one colour
How we can do it in SAS

[Reeza]

How are you reporting your data, HTML, XLSX, PDF, RTF? 

Either way, PROC REPORT will allow you to colour code your headings, if you search for PROC REPORT CUSTOM styles or Complex Reports via Cynthia Zender you'll find a lot of examples.

Note that this isn't easily available via the SAS GUI, it requires programming.

[Medanmani]

Yeah thank you reeza,
I am exporting the data in xlsx
But I didnt require to report that data,
So I need without using PROC REPORT how I can give that customization

[Reeza]

PROC EXPORT doesn't support colour coding. That's a straight data dump, no formatting.

ODS EXCEL and TAGSETS.EXCELXP support formatting and styles. You can even freeze panes and add filters/drop downs.