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

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

jiangmi — Wed, 18 Mar 2015 19:00:55 GMT

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

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

SASKiwi — Wed, 18 Mar 2015 19:22:13 GMT

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.

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

jiangmi — Wed, 18 Mar 2015 19:59:13 GMT

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

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

SASKiwi — Thu, 19 Mar 2015 01:27:40 GMT

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

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

tlk — Fri, 20 Mar 2015 13:03:09 GMT

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

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

JayCorbett — Fri, 20 Mar 2015 18:55:44 GMT

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.

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

jiangmi — Sat, 21 Mar 2015 01:52:42 GMT

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.

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

JayCorbett — Sat, 21 Mar 2015 15:01:52 GMT

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.

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

jiangmi — Mon, 23 Mar 2015 13:16:43 GMT

Find it, Jay.

Thanks a lot.