Hello:   I would like to write a macro to representing my files name because the program is needed to run many times.  However, the system showed syntax error.  Please help.  Thanks.   %let libname=RF; %let filename=NG; %let year=2013; %let number=02; % X1=wage; % Y1=salary; data &libname.&filename&year(&number+2); set &libname.&filename&year&number; if &Y1 in (1,2) and &X1 in (1,2,5,6); run;   51 data &libname.&filename&year(&number+2); - 200 ERROR 200-322: The symbol is not recognized and will be ignored.   52 set &libname.&filename&year&number; - - - 22 200 200 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored.   WARNING: Apparent symbolic reference LIBNAME not resolved. WARNING: Apparent symbolic reference FILENAME not resolved. WARNING: Apparent symbolic reference YEAR not resolved. WARNING: Apparent symbolic reference NUMBER not resolved. ERROR: File WORK.FILENAME.DATA does not exist. ERROR: File WORK.YEAR.DATA does not exist. ERROR: File WORK.NUMBER.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.   ... View more

Hello,    How to define a column with "between" condition in PROC SQL?  I got an error message from the syntax.  Please advice.  Thanks.       705 PROC SQL; 706 update work.test 707 set 729 POOR=case when 1 =< POOR < 14 then POOR=1 - 22 730 when 14 =< POOR =< 30 then POOR=2 end; - - 22 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. ... View more

Hello:   I got this error message from the log,   Please advice how to fix it, thank you.   640 PROC SQL; 641 update work.test 642 set age=case when age in (1,2,3,4,5) then 1 643 when age in (6,7,8,9) then 2 644 when age in (10,11,12,13) then 3 end, 645 set EDUCATION=case when EDUCATION in (1,2) then 1 --------- 73 76 ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored. 646 when EDUCATION in (3,4) then 2 647 when EDUCATION in (5.6) then 3 end; 648 quit; ... View more

Hello:   I have a syntax error code show below.   I would like to select all of the previous variables from the old table 1 to create a new one table 2, with condition TH=1.  I don't know why it didn't work?   504 proc sql; 505 create table two 506 select * ------ 73 ERROR 73-322: Expecting an AS. 507 from work.one 508 where TH=1 509 order by B; 510 quit; ... View more

Hello:   I try to update the multiple values in different columns.  I wrote a code below,  The log shows in the Syntax error.  Please help.  Thanks.   338 PROC SQL; 339 update work.test 340 set age=age 341 case ---- 22 202 ERROR 22-322: Syntax error, expecting one of the following: ;, !!, (, *, **, +, ',', -, '.', /, WHERE, ||. ERROR 202-322: The option or parameter is not recognized and will be ignored. 342 when age in (1,2,3,4,5) then age=1 ---- 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, !, &, AND, OR, |. ERROR 76-322: Syntax error, statement will be ignored. 343 when age in (6,7,8,9) then age=2 344 when age in (10,11,12,13) then age=3 345 end; 346 , set marital=marital - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 347 case 348 when marital in (2, 4) then marital=2 349 end; 350 , set education=education - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 351 case 352 when education in (1,2) then education=1 353 when education in (3,4) then education=2 354 when education in (5.6) then education=3 355 end; 356 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds   ... View more