Desktop productivity for business analysts and programmers

Freezing columns

Reply
New Contributor
Posts: 3

Freezing columns

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
New Contributor
Posts: 3

Re: Freezing columns

Posted in reply to 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
Super User
Posts: 20,224

Re: Freezing columns

Posted in reply to Medanmani

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.

New Contributor
Posts: 3

Re: Freezing columns

Posted in reply to 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
Super User
Posts: 20,224

Re: Freezing columns

Posted in reply to Medanmani

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.

Ask a Question
Discussion stats
  • 4 replies
  • 127 views
  • 0 likes
  • 2 in conversation