I got an error for this following program. Please help me to resolve my issue.

159 views
Skip to first unread message

Thirumagal manivannan

unread,
Oct 15, 2014, 12:00:22 PM10/15/14
to anova...@googlegroups.com

Hi,
I got an error for this following program. Please help me to resolve my issue.

Code

proc print data=orion3.order_fact;
where Year(order_date)=&year;
Title "orders for &year";
run;

log message.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
42 ;
43 proc print data=Orion3.Order_Fact;
44 where Year(Order_Date)=&Year;
_
22
76
WARNING: Apparent symbolic reference YEAR not resolved.
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, INPUT, PUT.
ERROR 76-322: Syntax error, statement will be ignored.
45 Title "Orders for &Year";
WARNING: Apparent symbolic reference YEAR not resolved.
46 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
47 ;
48 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
58 ;


Thirumagal manivannan

unread,
Oct 15, 2014, 12:14:57 PM10/15/14
to anova...@googlegroups.com
Hi
my problem is resolved.
I have to enter
%let year=2006; statement
Thiru

Thirumagal manivannan

unread,
Oct 15, 2014, 12:16:21 PM10/15/14
to anova...@googlegroups.com

Hi
my problem is resolved.
I have to enter

%let year=2007;
Regards
Thiru

Reply all
Reply to author
Forward
0 new messages