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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.