BookmarkSubscribeRSS Feed
Statsconsultancy
Fluorite | Level 6
I will like to select disease with codes beginning with B2 or C2. Is it possible to use logical operations here. I tried the following, but it did not work

data new;
set lib.data;
where disease like 'B2%' or where disease like 'C2%';
run;

I want to select patients with disease codes B2*** or C2***. Can anyone help.
3 REPLIES 3
jklaverstijn
Rhodochrosite | Level 12
This should work, you just have the syntax not entirely correct. Ommit the repetition of WHERE:

where disease like 'B2%' or disease like 'C2%';

That should do it. Basic SQL, nothing SAS here.

Good luck, Jan.
art297
Opal | Level 21
Works in data step. Nothing SQL here!

Is it Friday yet?
Art
advoss
Quartz | Level 8
You could also do:

data new;
set lib.data;
where disease IN: ('B2','C2'); /* note the colon on the IN, just matches on 1st chars*/
run;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 866 views
  • 0 likes
  • 4 in conversation