WHERE with SET

[deleted_user]

Hi All,

I use :-

data Segment_Pop;
set convert;
where content_category='Pop';
run;

It runs well but outputs only variables with 0 observations.

Kindly Suggest.

[sbb]

Review SAS DOC for the WHERE statement - there are no suitable observation candidates in WORK.convert having the condition/expression called-out on the WHERE statment.

Suggest analyzing your input file, possibly using PROC FREQ, PROC PRINT, or you may also consider self-diagnosis with the WHERE statement and using a LIKE construct in order to learn more about your input, such as case-sensitive tests in the WHERE.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step programming +"where statement" +pdv site:sas.com