I've added the log, there are no warnings or errors. Basin is a character value, it is NA, na, SP, etc. There are a couple other options. All of them show in the output data so the where statement is being ignored. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sort data=pg1.storm_summary out=storm_sort; 74 where Basin='NA' or 'na'; 75 by descending MaxWindMPH; 76 run; NOTE: There were 3118 observations read from the data set PG1.STORM_SUMMARY. WHERE 1 /* an obviously TRUE WHERE clause */ ; NOTE: The data set WORK.STORM_SORT has 3118 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2517.15k OS Memory 32060.00k Timestamp 04/18/2021 06:12:26 PM Step Count 83 Switch Count 5 Page Faults 0 Page Reclaims 296 Page Swaps 0 Voluntary Context Switches 23 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 784 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90
... View more
