topic Re: Like Operator in SAS Programming

Like Operator

DavidPhillips2 — Mon, 07 Aug 2017 17:55:15 GMT

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;

Re: Like Operator

DavidPhillips2 — Mon, 07 Aug 2017 18:10:55 GMT

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.

Re: Like Operator

DavidPhillips2 — Mon, 07 Aug 2017 18:12:05 GMT

I have two ;

Re: Like Operator

ballardw — Mon, 07 Aug 2017 19:07:18 GMT

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;

Re: Like Operator

ChrisNZ — Tue, 08 Aug 2017 05:12:11 GMT

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 ;