BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jiangmi
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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

8 REPLIES 8
SASKiwi
PROC Star

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.

jiangmi
Calcite | Level 5

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

SASKiwi
PROC Star

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

tlk
Quartz | Level 8 tlk
Quartz | Level 8

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

JayCorbett
Calcite | Level 5

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.

jiangmi
Calcite | Level 5

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.

JayCorbett
Calcite | Level 5

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.

jiangmi
Calcite | Level 5

Find it, Jay.

Thanks a lot.

EG Option.JPG

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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