DATA Step, Macro, Functions and more

Like Operator

Accepted Solution Solved
Reply
Super Contributor
Posts: 480
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
a week ago
Super Contributor
Posts: 480

Re: Like Operator


All Replies
Super Contributor
Posts: 480

Re: Like Operator

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
a week ago
Super Contributor
Posts: 480

Re: Like Operator

I have two ;

PROC Star
Posts: 1,558

Re: Like Operator

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: 10,483

Re: Like Operator

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
  • 73 views
  • 0 likes
  • 3 in conversation