Dear All, Thank you very much in helping and clarifying doubts of my previous questions, Here i have 300+ sas codes(.sas files) where i have to replace block of code in all of them. Piece of code : %if &envi eq "UAT" %then %do; Proc export data=&abc. outfile ="&output\&abc.xls" replace; run; %end; %else %if &envi eq "PRD" %then %do; data out.&abc; set &abc; run; %end; Part of code (in Bold) to be replaced with  : Proc export data=&abc. outfile ="&output\&abc.xls" replace; run; ** &abc is the last data set created just before running the final export statement. Thanks in advance!!! ... View more

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