topic Re: Freezing columns in SAS Enterprise Guide

Freezing columns

Medanmani — Fri, 20 Oct 2017 18:08:23 GMT

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

Re: Freezing columns

Medanmani — Fri, 20 Oct 2017 18:17:01 GMT

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

Re: Freezing columns

Reeza — Fri, 20 Oct 2017 19:04:02 GMT

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.

Re: Freezing columns

Medanmani — Sat, 21 Oct 2017 00:42:31 GMT

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

Re: Freezing columns

Reeza — Sat, 21 Oct 2017 00:48:14 GMT

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.