Hi ... re "Your putting the where clause in the wrong place." ... that WHERE clause is fine in that location and does work since there is an output data set ... data want (where = (name ne 'balaji')); input name $ age; datalines; ramkuma 26 chandra 27 balaji 33 ; LOG ... data want (Where = (name ne 'balaji') ); 4 input name $ age; 5 datalines ; NOTE: The data set WORK.WANT has 2 observations and 2 variables. NOTE: DATA statement used (Total process time): also, re "Where statements like that can be put on the set part of a data step. In your case as there is not a set clause you would need to do:" ... that won't work given there's no data set yet ... data want; input name $ age; where name ne 'balaji'; datalines; ramkuma 26 chandra 27 balaji 33 ; LOG ... 22 data want; 23 input name $ age; 24 where name ne 'balaji'; ERROR: No input data sets available for WHERE statement. 25 datalines; NOTE: The SAS System stopped processing this step because of errors.
... View more