04-20-2015 10:35 AM
I am very new to SAS. I am trying to add a new column to the SAS table but to no avail!!
I get the error "The Delete permission is required to delete tables or views in the SAS library."
Below is the code I'm using, could someone advise if this is the correct way to go about this? Or how can i trouble shoot the error above.
ALTER TABLE DEV_MART.CHURN_MART_WITH_CONTROL_GROUPS ADD AVONDHU_GROUP CHAR FORMAT $24.;
04-20-2015 11:06 AM
Ah, so you are using Metadata server or something. Sorry, its not clear from your post. I don't use this so can't help there. Maybe post in the the softwares specific sub-forum.
04-20-2015 11:49 AM
Are your data sas datasets or on a server i.e. SQL Server?
Can you do it via a data step?
length AVONDHU_GROUP $24.;