topic Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A in SAS Enterprise Guide

Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A

Lauban — Fri, 09 Jun 2017 02:55:30 GMT

Beginner here. Unfortunately a bit overhhelmed and new to coding. I would like to be able to select multiple cases and create a table of them. I understand that creating a table I need to use this:

proc sql; select * from ____.__ where initials = 'XX'; quit;
proc sql; create table test as select * from _____.______ where initials = 'XX'; quit;

But I would like to find multiple individuals

Thank you in advance!

Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A

kiranv_ — Fri, 09 Jun 2017 03:13:16 GMT

below is the link for free Proc SQL session, which may be helpful for you. You just need to register and you can listen to an excellent session.

s://www.sas.com/en_us/webinars/sql-introduction/register.html

Please give some more details, so that someone call help you. How your sample dataset looks like and how your result dataset look like.

Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A

Lauban — Fri, 09 Jun 2017 03:34:06 GMT

Thanks for your help I will check that session out.

My data set looks like

Initials DOB Variable 1 Variable 2

XX _ 1 2

XY _ 3 4

XO _ 4 5

I would like to find XX, XY, XO and have a table of their variables in the results viewer

Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A

kiranv_ — Fri, 09 Jun 2017 03:41:38 GMT

proc sql;
create table have as
select * from want
where initials in('XX', 'XY', 'XO');
quit;

Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner – Ask the Expert Q&A

PaigeMiller — Fri, 09 Jun 2017 10:35:46 GMT

It makes no sense to have a title on this thread "Re: Variable Selection: SAS Enterprise Guide & SAS Enterprise Miner -- Ask the Expert Q&A", as this question has nothing to do with Enterprise Guide, nothing to do with Enterprise MIner, and nothing to do with "variable selection". This is not a variable selection question, this is a question about selecting observations or rows (not variables).