How to go to specific column directly?

Accepted Solution Solved
Reply
Super Contributor
Posts: 319
Accepted Solution

How to go to specific column directly?

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.

 

 


Accepted Solutions
Solution
‎08-11-2017 03:11 PM
Super User
Posts: 19,870

Re: How to go to specific column directly?

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;

View solution in original post


All Replies
Solution
‎08-11-2017 03:11 PM
Super User
Posts: 19,870

Re: How to go to specific column directly?

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;
Trusted Advisor
Posts: 1,933

Re: How to go to specific column directly?

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.

Super User
Posts: 11,343

Re: How to go to specific column directly?

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.

Trusted Advisor
Posts: 1,933

Re: How to go to specific column directly?

What is Form View? How do you enable it?

Super User
Posts: 11,343

Re: How to go to specific column directly?

Posted in reply to PaigeMiller

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.

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 167 views
  • 2 likes
  • 4 in conversation