DATA Step, Macro, Functions and more

Like Operator

Accepted Solution Solved
Reply
Super Contributor
Posts: 497
Accepted Solution

Like Operator

Like operator

 

Why does this return values like... L02?

 

proc sql;
create table qatar_lookup as
select distinct academic_period, COURSE_IDENTIFICATION, course_reference_number, course_section_number, 1 as qatar_flag
from odsstu.student_course;
where course_section_number like '%Q%';
quit;


Accepted Solutions
Solution
‎08-08-2017 08:36 AM
Super Contributor
Posts: 497

Re: Like Operator

Posted in reply to DavidPhillips2

All Replies
Super Contributor
Posts: 497

Re: Like Operator

Posted in reply to DavidPhillips2

This is in the log

29 where course_section_number like '%Q%';
WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

Solution
‎08-08-2017 08:36 AM
Super Contributor
Posts: 497

Re: Like Operator

Posted in reply to DavidPhillips2

I have two ;

PROC Star
Posts: 1,760

Re: Like Operator

Posted in reply to DavidPhillips2

The log says it:  the where statement is ignored.

SQL cannot have standolone where statements. 

where statements have to be part of a sql clause (a select clause for example).

the cause ends with a ;

Super User
Posts: 11,343

Re: Like Operator

Posted in reply to DavidPhillips2
proc sql;
create table qatar_lookup as
select distinct academic_period, COURSE_IDENTIFICATION, course_reference_number, course_section_number, 1 as qatar_flag
from odsstu.student_course; <NO ; should be here if you need a where clause 
where course_section_number like '%Q%';
quit;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

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