Good Evening Team,   I am assigning value to one macro variable but while using that macro variable value I am getting error below. Can you please help.   Regards Kajal proc sql; select max(yearmonth) into : yrmonth from source_data; quit; proc sql; delete * from target_data where yearmonth= &yrmonth.; quit;  ERROR: Attribute '202206' not found  %put yearmonth --> &yrmonth;  yearmonth --> 202206 ... View more

Here is one error I am getting after doing some troubleshooting  ERROR: CLI execute error: ERROR: Error from JDBC driver: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:5175 Invalid table alias or column reference 'process_date': (possible column names are: ) After adding table alias 't' getting error: ERROR: CLI execute error: ERROR: Error from JDBC driver: Error while compiling statement: FAILED: ParseException line 1:5168 missing EOF at 't' near 'source_table' ... View more

yes exactly this code is developed in toad and running absolutely fine and loading data when running in toad but failing in SAS only also doing the same just pasting the working code inside sql pass through in sas.   Regards Kajal ... View more

Though it is running fine but still not adding any records to the final table. May I know the possible reasons ?    Regards Kajal ... View more

see below the rest of the portion   NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 553 quit; NOTE: The SAS System stopped processing this step because of errors. ... View more

@SASKiwi Thank you and getting error ERROR: CLI execute error: ERROR: 'INSERT INTO nz_tbl.final ( rec_type,rv,trends,   Regards Kajal ... View more

I am running a fluid query in TOAD data point. Adding sample fluid query I am running in Netezza to get data from Hadoop. Where hd2 is a fluid query. Just thinking a way to run similarly in SAS EG but it is not recognizing fluid query.   INSERT INTO NZ_tbl.final( rec_type , rv , trends , account , address , client , segment ) SELECT rec_type , rv , trends , account , address , client , segment FROM TABLE WITH FINAL (hd2('db.dev', '', 'SELECT rec_type , rv , trends , account , address , client , segment FROM view where date = 20220526 ')) ;  Thanks Kajal ... View more

  For Base SAS Software ... Custom version information: 9.4_M6 Image version information: 9.04.01M6P110718 For SAS/STAT ... Custom version information: 15.1 For SAS/GRAPH ... Custom version information: 9.4_M6 For SAS/ETS ... Custom version information: 15.1 For SAS/FSP ... Custom version information: 9.4_M6 For SAS/OR ... Custom version information: 14.2 Image version information: 9.04.01M4P110916 For SAS/AF ... Custom version information: 9.4_M6 For SAS/IML ... Custom version information: 15.1 For SAS/SHARE ... Custom version information: 9.4_M5 For SAS/ASSIST ... Custom version information: 9.4 Image version information: 9.04.01M0P061913 For SAS/CONNECT ... Custom version information: 9.4_M6 For SAS/EIS ... Custom version information: 9.4_M6 2 The SAS System Tuesday, July 5, 2022 09:07:00 AM For SAS/ACCESS Interface to Netezza ... Custom version information: 9.43 For SAS OLAP Server ... Custom version information: 9.4 For SAS Enterprise Miner ... Custom version information: 15.1 For SAS/ACCESS to Impala ... Custom version information: 9.45 For SAS/IntrNet ... Custom version information: 9.4_M6 For SAS Integration Technologies ... Custom version information: 9.4_M6 For SAS/Secure 168-bit ... Custom version information: 9.41_M3 For SAS Credit Scoring ... Custom version information: 15.1 For SAS Data Quality Server ... Custom version information: 9.46 For High Performance Suite ... Custom version information: 2.2_M7 For SAS/ACCESS Interface to DB2 ... Custom version information: 9.4_M2 For SAS/ACCESS Interface to Oracle ... Custom version information: 9.43 For SAS/ACCESS Interface to PC Files ... Custom version information: 9.4_M6 For SAS/ACCESS Interface to ODBC ... Custom version information: 9.4_M6 ... View more

Hi @SASKiwi , Can you tell me how can I see that SAS/ACCESS ?  so here is the scenario. my source data is in Hadoop and target location is Netezza. So fluid query is reading data from Hadoop and loading it into Netezza also it is working fine and expected when I am running this query on a DB tool.   Regards Kajal   ... View more

Thanks @sbxkoenk actually I am trying to read data from one database and load it to another database.   ... View more

Thank you so much team for your kind help. ... View more