Help using Base SAS procedures

WHERE with SET

Reply
N/A
Posts: 0

WHERE with SET

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: WHERE with SET

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 119 views
  • 0 likes
  • 2 in conversation