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;
I have two ;
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.
I have two ;
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 ;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.