sas proc sql create table / initialize value to zero

alepage — Tue, 06 Feb 2018 13:17:54 GMT

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;

Re: sas proc sql create table / initialize value to zero

LinusH — Tue, 06 Feb 2018 13:25:37 GMT

Use the coalesce function.