BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
whymath
Lapis Lazuli | Level 10

In SAS windowing environment, I can use "keep name" or "show name" command to keep only "name" variable showed in a data view.

But can I keep two or more variables at one shot? I have tried "keep name age" and "keep (name age)", they didn't work.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

COLUMNS 'sex age height'

ONE set of quotes around a space delimited list of variable names.

 


@whymath wrote:

This is where I use this command:

1.png


 

View solution in original post

3 REPLIES 3
whymath
Lapis Lazuli | Level 10

This is where I use this command:

1.png

ballardw
Super User

COLUMNS 'sex age height'

ONE set of quotes around a space delimited list of variable names.

 


@whymath wrote:

This is where I use this command:

1.png


 

whymath
Lapis Lazuli | Level 10
I quickly tried:
columns 'sex age height'
show 'sex age height'
keep 'sex age height'
They both work, XD

Thank you very much.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 172 views
  • 0 likes
  • 2 in conversation