Hi everyone, I am trying to update the table named "test" in the in the SQL database. I have tried the libname option as;   libname PIlibt odbc noprompt="uid=myuid; pwd=mypassword; dsn=mydsn;" stringdates=yes; PROC SQL; ALTER TABLE PILIBT.TEST ADD MYVAR NUM DROP AGE; QUIT;   This statemnt gave me an error message : ERROR: The HEADER/VARIABLE UPDATE function is not supported by the ODBC engine. ERROR: View PILIBT.TEST cannot be altered.   Next I am trying to use pass through facility option using the the code below and my code is not correct.   PROC SQL; CONNECT TO ODBC AS MYCON (DSN=mydsn USER=myuid PASSWORD=mypassword); ALTER TABLE TEST ADD NEWVAR NUM DROP AGE; DISCONNECT FROM MYCON; QUIT;   could you help me fixing this codes to update my table.   Thanks for your support.   ... View more

Hi Everybody! I am connected to a database using a odbc connection and I need to create a view in  database.  I have written the following code: libname test odbc noprompt="uid=username;                                                   pwd=password;                                                   dsn=mydatabase;"                                    stringdates=yes; Proc Sql; create view test.table1 as select * from orders; Quit; I got the following error message ERROR: The CREATE VIEW statement cannot be processed directly by the database. ERROR: Create View failed. Could somebody help me create the view in the database. Your help is highly appreciated. Ram ... View more