hi! Tom below is the log... no error at all... and I copied your code and run them in my home's computer and it is OK... my company's sas is 9.1 on xp... and this is a old problem for me and i cannot solve it. so every time i just avoid to use proc sql although i love it... thanks again 106 data t; 107 108 input a $ x @@; 109 110 cards; NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.T has 5 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 114 run; 115 116 proc sql ; 117 118 create table nocount as 119 120 select "no count bigger than 5" as comment from t where x > 5 121 122 ; NOTE: Table WORK.NOCOUNT created, with 0 rows and 1 columns. 123 124 create table count as 125 126 select count(*) as count 127 128 , "count bigger than 5" as comment from t where x > 5; NOTE: Table WORK.COUNT created, with 1 rows and 2 columns. 129 130 create table wrongcount as 131 132 select count('1','2') as count 133 134 , "count bigger than 5" as comment from t where x > 5 135 136 ; NOTE: Table WORK.WRONGCOUNT created, with 0 rows and 2 columns. 137 138 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more