Alternately use if not instead of delete   data test; set test; if not ('01Sep2018'd <= input(YEAR_MONTH,yymmn6.) <= '30Sep2018'd); run; ... View more

Hope this helps   data have; input IncidentID VISDATE:mmddyy10.; cards; 1 7/3/2017 2 7/3/2017 3 7/5/2017 4 7/5/2017 5 7/5/2017 6 7/7/2017 6 7/5/2017 7 7/5/2017 8 7/5/2017 8 7/7/2017 9 7/5/2017 10 7/6/2017 11 7/6/2017 12 7/6/2017 12 7/17/2017 13 7/6/2017 14 7/7/2017 15 7/12/2017 ; proc sort data=have nodupkey; by IncidentID VISDATE; run; proc freq data=have; table IncidentID/out=want; run;     ... View more

Please try the below code where I used the invalue for creating the informat as 1 and 2 and now you will get the expected result in the flag variable.     PROC FORMAT; inVALUE rvsd_format 5000-10000=1 10000-25000=2 ; run; data have; input nos1 nos2; datalines ; 9544.59 10605.10 8588.00 10781.20 9029.48 11061.31 9831.00 10158.70 9454.00 13380.18 9504.00 15888.00 8400.00 12728.80 6672.00 16516.00 7595.12 14062.24 9951.13 10780.39 ; run; data have2; set have; fmt_nos1=input(nos1,rvsd_format.); fmt_nos2=input(nos2,rvsd_format.); if fmt_nos2=fmt_nos1 then flag="Equal"; else if fmt_nos2>fmt_nos1 then flag="2>1"; else flag="2<1"; run; ... View more

Here you are comparing the the character variables because of which it is taking the last else condition flag="2<1"    You need to compare the numeric variables ... View more

Yes just replace the code ne "A" with the numeric variable and its value ... View more

Yes I did not check that answer and when i posted it was same, now i changed the answer with nobs option. ... View more

Alternatively with nobs option   data want; set have2 nobs=nobs; lastobs=nobs; if _n_=lastobs and code ne 'A' then delete; run;         ... View more

Please try   data want; set have2 end=eof; if eof and code ne 'A' then delete; run; ... View more

Sure, please test and let me know. s - represents substitution / / /- these are delimiters so anything inbetween these delimiters is checked and the third / represent anything between the second / and third / will be replaced with. -1 - it tells the number of times to replace here it is multiple times if it is just 1 then it will replace only once hope this helps ... View more

Hope this code will help   data Namen ; input Name &$35.; name2=prxchange('s/und//i',-1,name); datalines; Von und Zu und Tortilla und Bin dahoam und Curry Wurst und ; ... View more

Alternatively with scan   data Namen ; input Name &$35.; name2=scan(strip(name),1,' '); datalines; Name1 und Name2 und Name3 und Name4 oder ; run; ... View more