BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
BrahmanandaRao
Lapis Lazuli | Level 10
/*Query to ADD COLUMNS AGE AND COURSER TO STUDENT TABLE*/
proc sql;
Alter table Student add(Age num(3), Course varchar(40));
quit;

error 

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

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;

View solution in original post

1 REPLY 1
Ksharp
Super User

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;

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 695 views
  • 0 likes
  • 2 in conversation