How to give a value to a new added column in sql alter statement?

[Mike_Davis]

HI everyone,

Could anyoone can tell me how  to give a value to  a new added column in sql alter statement?

Thanks!

proc sql noprint;

ALTER TABLE sashelp.class ADD new2 num label='test'  value=1;

quit;

[PGStats]

Use the update statement :

proc sql noprint;

ALTER TABLE sashelp.class ADD new2 num label='test';

UPDATE sashelp.class SET new2=1;

quit;

PG