69 PROC PRINT data= Bbq (where=(state='New York')); 70 By State; 71 Run; NOTE: No observations in data set WORK.BBQ. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 72 Proc print data= Bbq(where=(state='New York')) out=bbq1; --- 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL, GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL, UNIFORM, WIDTH. ERROR 76-322: Syntax error, statement will be ignored. 73 By State; 74 Run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 75 Proc sort data= Bbq(where=(state='New York')) out=bbq1; 76 By State; 77 Run; NOTE: Input data set is empty. NOTE: The data set WORK.BBQ1 has 0 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.07 seconds 78 Proc sort data= Bbq (where=(state='New York')) out=bbq1; 79 By State; 80 Run; NOTE: Input data set is empty. NOTE: The data set WORK.BBQ1 has 0 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.04 seconds     Again I am not sure if I am doing this right. I am very new to this program. ... View more

PROC PRINT data= Bbq (where=(state='New York')); By State; Run; ... View more

Thanks for your help. Why does this error come up when I try what you have?   NOTE: Input data set is already sorted, no sorting done. NOTE: There were 0 observations read from the data set WORK.BBQ. WHERE 0 /* an obviously FALSE WHERE clause */ ; NOTE: The data set WORK.BBQ has 0 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.07 second   ... View more

The actual variable name is State. But I would like just a table with New York so what would I need to add? ... View more