https://communities.sas.com/t5/SAS-Procedures/WHERE-with-SET/m-p/69577#M19998 Hi All,<BR /> <BR /> I use :-<BR /> <BR /> data Segment_Pop;<BR /> set convert;<BR /> where content_category='Pop';<BR /> run;<BR /> <BR /> It runs well but outputs only variables with 0 observations.<BR /> <BR /> Kindly Suggest. Sun, 06 Feb 2011 10:15:08 GMT deleted_user 2011-02-06T10:15:08Z https://communities.sas.com/t5/SAS-Procedures/WHERE-with-SET/m-p/69577#M19998 Hi All,<BR /> <BR /> I use :-<BR /> <BR /> data Segment_Pop;<BR /> set convert;<BR /> where content_category='Pop';<BR /> run;<BR /> <BR /> It runs well but outputs only variables with 0 observations.<BR /> <BR /> Kindly Suggest. Sun, 06 Feb 2011 10:15:08 GMT https://communities.sas.com/t5/SAS-Procedures/WHERE-with-SET/m-p/69577#M19998 deleted_user 2011-02-06T10:15:08Z https://communities.sas.com/t5/SAS-Procedures/WHERE-with-SET/m-p/69578#M19999 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.<BR /> <BR /> 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> data step programming +"where statement" +pdv site:sas.com Sun, 06 Feb 2011 19:59:09 GMT https://communities.sas.com/t5/SAS-Procedures/WHERE-with-SET/m-p/69578#M19999 sbb 2011-02-06T19:59:09Z