Hi @Kurt_Bremser I have tried to use Proc Report to produce the total number of special request given by customers to City Hotel in my dataset. And again sas took nearly 10mins to produce the error message. Whenever i am wrong in coding, sas is not responding quick. Could you identify whats wrong in the encoding? This is my log report. I am hoping to find a solution for this through this community please! Thank you proc report data=hotel.Hotel_bookings;
column hotel total_of_special_request;
where hotel='City Hotel'and total_of special_request >0;
------------ ---------------
49 22
76
ERROR: Syntax error while parsing WHERE clause.
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting
white space between a quoted string and the succeeding identifier is recommended.
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, <, <=, <>, =, >, >=,
AND, EQ, GE, GT, LE, LT, NE, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
rbreak after/summarize style=[font_weight=bold];
title'No of special request given to City Hotel';
run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
... View more