topic Re: How to go to specific column directly? in SAS Programming

How to go to specific column directly?

ybz12003 — Thu, 10 Aug 2017 18:48:55 GMT

Hello:

I use proc contents to find one specific column is located at 158 among 800 columns of my dataset. Is there a way to go to that 158 column directly, instead of moving my mouse back and forward? Thanks.

Re: How to go to specific column directly?

Reeza — Thu, 10 Aug 2017 18:54:31 GMT

You're trying to manually review the column?

I would suggest using PROC PRINT and using the VAR statement to limit the results. You can also limit the amount of observations to help you examine the data.

proc print data=sashelp.cars(obs=100);
var mpg_highway;
run;

Re: How to go to specific column directly?

PaigeMiller — Thu, 10 Aug 2017 18:56:32 GMT

What part of SAS are you looking in when you are trying to do this? ViewTable? Some other viewer?

If viewtable, sometimes the fastest way is via PROC SQL, create a VIEW with only the column(s) you want to see.

Re: How to go to specific column directly?

ballardw — Thu, 10 Aug 2017 19:16:29 GMT

If you are using the Viewtable I might suggest using the Form view instead of table. If your window is large enough the Form view will show all of the variables for one record on a single page.

But you have so many variables I'm not sure you could get a form view large enough to help much.

Re: How to go to specific column directly?

PaigeMiller — Thu, 10 Aug 2017 19:29:24 GMT

What is Form View? How do you enable it?

Re: How to go to specific column directly?

ballardw — Thu, 10 Aug 2017 19:56:09 GMT

@PaigeMiller wrote:

What is Form View? How do you enable it?

In Base SAS with a table open go to View on the menu and click on Form View. The data appears like a data entry form. The name or the variable label appears next to a box with the value of the variable in columns. There are navigation buttons for pages: first, previous, next,last on the bottom of the display area. If there are more variables than fit on the current display area then you get a "page corner" to allow navigating to "next page" or "Previous page" within a record.

I have no idea if EG supports this.