alter table

[BrahmanandaRao]

/*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 · Accepted solution]

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;