Hi smart people. I have the following code: data want; set have; if dep="1309825" then dep="" AND source_dep=. AND indexdate_dep=.; run;   dep is a character value(it can contain letters) and is 11 characters long. SAS returns a 0 rather then a blank when i run this and I want a blank. I have tried:   if scan(dep,1,"1309825")=1 then dep="" AND ... and the rest, but the result is the same.   i Have also tried:   if lenght(dep)=7 and dep="1309825" then dep="" AND ... the rest, also with the same result.....   How can I make it return a blank and not a zero? thank you ... View more

Hi, below is an example of the data I have (in reality about 20000 entries and many more variables). Identifier Var_1 Var_2 Var_3 1 ZN ZN DS 2 ZN DS FD 3 DS DS   4 FD FD ZN I used proq freq to find frequencies of 'ZN', 'DS' and 'FD' for Var_1, Var_2 and Var_3 seperately like so: proc freq data=rehab order=freq; tables Var_1; run;   I want to find the freq. of 'ZN' and so on in all three variables, but not counting them multible times. As in "so many have 'ZN' at all and so on   I cant seem to grasp it - is it possible oh clever internet-people? ... View more