Hello:
I would like to use proc sql to create table by using the following variable? Please let me know how to make SAS recognize the variable names.
proc sql;
create table library.text2 as
select HAVARTH3 _BMI5CAT _SMOKER3
from library.test1;
The SAS log showes the following error massage:
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, (, *, **, +,
',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT,
FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT,
LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
Please help. Thanks.
SQL requires commas whenever you specify a list:
proc sql;
create table library.text2 as
select HAVARTH3, _BMI5CAT, _SMOKER3
from library.test1;
SQL requires commas whenever you specify a list:
proc sql;
create table library.text2 as
select HAVARTH3, _BMI5CAT, _SMOKER3
from library.test1;
Sql requires commas to separate elemnt like list of variables:
proc sql;
create table library.text2 as
select HAVARTH3,
_BMI5CAT,
_SMOKER3
from library.test1;
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 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.