Dear All, Here is a scenario where BETWEEN Operator is not working as expected.Please help me in understanding what could be the possible reason for this. 751 DATA VS; 752 SET STUDY.VS; 753 KEEP USUBJID VISIT VSTESTCD VSTEST VSORRES VSORRESU ; 754 WHERE VSTESTCD ='WEIGHT' AND VSORRES BETWEEN '35' AND '150'; 755 756 /*WHERE (VSTESTCD='WEIGHT') AND (INPUT(VSORRES,BEST.) BETWEEN 35 AND 150);*/ This is working ; 757 RUN; NOTE: There were 6 observations read from the data set STUDY.VS. WHERE (VSTESTCD='WEIGHT') and (VSORRES>='150' and VSORRES<='35'); - Please help in comprehending how the condition was negated. NOTE: The data set WORK.VS has 6 observations and 6 variables. NOTE: Compressing data set WORK.VS increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds VSORRES : CHAR VARIABLE HAVING NUMERIC VALUES
... View more