02-08-2017 01:24 PM
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.
create table library.text2 as
select HAVARTH3 _BMI5CAT _SMOKER3
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.
02-08-2017 01:44 PM
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;
Need further help from the community? Please ask a new question.