Hello I tried to use the put() function (as suggested in this forum) to convert a # to text (line 40) and I get an error. Help please. 29 proc sql ; 30 connect to odbc(dsn=AMP_DSN uid=Dyyyyyy password = XXXXXXXX!); 31 32 33 /* Get Network profile and export results as csv */ 34 35 create table tbl_NetworkProfile_201612 as 36 select * from connection to odbc( 37 38 select distinct 39 a.year_month, 40 put(a.branch_id, 15.) as branch_id, 41 a.hh_id, 42 a.customer_segment as Segment, 43 b.cd_accts as numCD, 44 b.chk_accts as numChk, 45 b.heq_accts as numHE, 46 b.credit_card_accts as numCreditCard, 47 b.investment_accts as numInvestments, 48 b.ira_accts as numIRA, 49 b.mtg_accts as numMortgage, 50 b.mma_accts as numMMA, 51 b.sav_accts as numSAV, 2 The SAS System 12:27 Monday, January 13, 2020 52 c.deposit_avg_bal as depbal, 53 c.loan_curr_bal as loanbal 54 from 55 level2.groupings a, level2.accounts b, level2.balance c 56 where a.year_month ='201612' 57 and a.customer_segment <> 'unknown' 58 and a.year_month = b.year_month 59 and a.year_month = c.year_month 60 and a.hh_id = b.hh_id 61 and a.hh_id = c.hh_id 62 ); ERROR: CLI describe error: [Oracle][ODBC][Ora]ORA-00904: "PUT": invalid identifier : [Oracle][ODBC]Invalid descriptor index <1>. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
... View more