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

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

Mike_Davis — Fri, 18 May 2012 15:41:43 GMT

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 — Fri, 18 May 2012 17:27:37 GMT

Use the update statement :

proc sql noprint;

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

UPDATE sashelp.class SET new2=1;

quit;