Hello,  I need to convert a numeric variables (all the numbers are whole numbers, no decimals) to character because I need to insert some character symbols and I seem to be able to do the conversion using compress. i.e. new=compress(old). This seems to work. Is this bad practice? Can using compress for this num to char conversion introduce some sort of errors that I am not aware of? ... View more

Hello,  I am required to report incidents of X by year, state, mode of transport. I have a decade worth of data and I used proc sql to count the incidents by mode of transport. The problem is that I get no 0 counts, so I have some missing rows for some year+state+mode combinations.  How do I fix this issue? I want to have all years and all states and all modes showing with 0s as the count, but the 0 count rows just don't appear.   PROC SQL; CREATE TABLE WANT AS SELECT YEAR, STATE, MODE, count(MODE) AS VALUE FROM HAVE GROUP BY YEAR, STATE, MODE; QUIT; ... View more