sas proc sql create table / initialize value to zero

[alepage]

Hello,

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?

Regards,

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

dataset2 B

on A.id=B.id

quit;

[LinusH · Accepted solution]

Use the coalesce function.