libname glib greenplm dsn=greenplum user=userid password=passwd1 schema=public;

proc datasets lib=glib;
  delete curdata2;
  change curdata1=curdata2;
quit;

ERROR: CLI execute error: [SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol
driver][Greenplum]ERROR: syntax error at or near "."(Position 63;File scan.l;Line 
979;Routine base_yyerror;) 

Workarounds

To work around this issue, do one of the following:

• If the default schema with which the user ID logs in to the Greenplum database is the same as the one needed for use with PROC DATASETS, omit the schema option from the LIBNAME statement.
• Use a different method such as PROC SQL or DATA Step code to create a new data set and delete the old one.

Operating System and Release Information