Desktop productivity for business analysts and programmers

How to locate a variable in a SAS data opened under EG window?

Accepted Solution Solved
Reply
Contributor
Posts: 61
Accepted Solution

How to locate a variable in a SAS data opened under EG window?

Hi, All,

I am working with SAS EG.

I want to take a look at one specific variable in a newly generated data. For example, 'TU_BRAND'. However, this variable is buried with other 100+ variables in the same data set. Is there any way I can quickly locate this variable/column in the data set, something similar to the Ctrl+F key combination?  I don't want to dragged the bar with my mouse for 5min before I can find it.

Thanks.

Joe

SAS EG.JPG


Accepted Solutions
Solution
‎03-18-2015 03:22 PM
Respected Advisor
Posts: 3,062

Re: How to locate a variable in a SAS data opened under EG window?

Open your SAS table, Ctrl F, choose Column Headings only search option, type in the column name or part column name to search on then press the Find Next button.

View solution in original post


All Replies
Solution
‎03-18-2015 03:22 PM
Respected Advisor
Posts: 3,062

Re: How to locate a variable in a SAS data opened under EG window?

Open your SAS table, Ctrl F, choose Column Headings only search option, type in the column name or part column name to search on then press the Find Next button.

Contributor
Posts: 61

Re: How to locate a variable in a SAS data opened under EG window?

Thank you very much. I wasn't aware of it at all before!:smileylaugh:

Respected Advisor
Posts: 3,062

Re: How to locate a variable in a SAS data opened under EG window?

Neither was I until your question prompted me to try! Thanks in return because its really useful. :smileygrin:

Contributor tlk
Contributor
Posts: 49

Re: How to locate a variable in a SAS data opened under EG window?

Thank to the both of you, great tip... a time saver... right under our noses  Smiley Wink

Occasional Contributor
Posts: 6

Re: How to locate a variable in a SAS data opened under EG window?

Alternatively, you can do a query builder task and arrange the variables, in the output data set, in any order you want. By right-clicking where the variables are listed, in the query builder task, you can arrange the variables names in ascending or descending order also.

Contributor
Posts: 61

Re: How to locate a variable in a SAS data opened under EG window?

Thanks, Jay.

BTW, do you know how to subset the data table by obs in EG using query builder?

I mean, I can do it with code:

data want;

set have (obs=3);

run;

Is there anyway I can do it in filter or builder?

Just curious.

Occasional Contributor
Posts: 6

Re: How to locate a variable in a SAS data opened under EG window?

Choose the Options button (located below the Query name, on the right side). Under Query limits, check the box for Limit number of matching rows to process and set the number of rows.

Contributor
Posts: 61

Re: How to locate a variable in a SAS data opened under EG window?

Find it, Jay.

Thanks a lot.

EG Option.JPG

☑ This topic is SOLVED.

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

Discussion stats
  • 8 replies
  • 858 views
  • 5 likes
  • 4 in conversation