topic alter table in SAS Procedures

alter table

BrahmanandaRao — Sat, 07 Mar 2020 06:18:00 GMT

/*Query to ADD COLUMNS AGE AND COURSER TO STUDENT TABLE*/
proc sql;
Alter table Student add(Age num(3), Course varchar(40));
quit;

error

Ksharp — Sat, 07 Mar 2020 06:44:24 GMT

Your code looks good. What is your ERROR info ?

data have;
set sashelp.class;
run;

proc sql;
alter table have
 add x num,y char(20);
 
select * from have;
quit;