02-06-2018 08:17 AM
I would like to know how to initialize selected variables to zero to replace missing value by zero in proc sql create table
In the example below, I would like to have missing(web) and missing(internet) set to zero.
How is it possible to do that in a pro sql procedure?
proc sql ;
create table internet as
select A.id, A.class, A.date,A.performer,A.title,A.category, A.web, B.internet
from dataset1 A full join
Need further help from the community? Please ask a new question.