Hi,  i need to convert a column  TM_INS_C   char ($26.) "2016-09-05-17.38.51.717187" to timestamp.   I use thsi query:   data WORKUSI.T03_totale_pag_P ; set WORKUSI.T03_totale_pag; new_var=input(TM_INS_C,datetime26.); FORMAT new_var datetime26.; WHERE NDG_TITR_CARTA = '034361749'; run; but i have this error:     NOTE: Invalid argument to function INPUT at line 1723 column 13. TM_INS_C=2016-07-25-17.03.46.213975 CO_CAU_OPER_ATM=M90 CO_SUB_CAU_OPE_ATM=0000 NDG_TITR_CARTA=034361749 CO_KEY_CARTA_ATM=20081436919871987 DT_OPE=25JUL2016 OR_OPE=17:03:00 DB_OPER=PAGAMENTO BOLLETTINI POST IM_OPER_ATM=0.000 FL_CARTA_BANCA=S FL_CARTA_POOL=N CODCAB=03045 CO_ATM=05496 TIPOPER_=M900000 KEYATM=020080304505496 CONTO=PAGAMENTI DESCR=PAGAMENTO BOLLETTINI POST LOG=PAGAMENTI new_var=. _ERROR_=1 _N_=11 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 11 at 1723:13 NOTE: There were 11 observations read from the data set WORKUSI.T03_TOTALE_PAG. WHERE NDG_TITR_CARTA='034361749'; NOTE: The data set WORKUSI.T03_TOTALE_PAG_P has 11 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 1.49 seconds cpu time 0.12 seconds What is my error ?     Thank's M. ... View more

Hi, i want create a xml file with this code: ODS TAGSETS.EXCELXP file="C:\Users\ui43925\Desktop\PROVA\&FILE." style=printer OPTIONS ( Center_Horizontal = 'yes' Embedded_Titles = 'yes' Embedded_Footnotes = 'no' Sheet_Name = 'Elenco terminali' /* Absolute_Column_Width = 'NONE' */ Center_Horizontal = 'yes' Autofit_Height = 'yes' /*Frozen_Headers = '6' */ width_fudge='2.2' /* default_column_width='3' */ Autofilter = 'yes' absolute_column_width= '5,4,3,7,7,5,3,3,7,7,2,7,2,3,4' ); options missing=' '; TITLE1 font=calibri h=5 "TERMINALI IN DOTAZIONE ALL'AGENZIA"; /*TITLE2 '(Richieste totali pervenute - Interazioni con operatore)'; */ proc report nowd data=WORKUSI.OUT_TEMP1; COLUMN REGION KEYATM COD_AG AGENZIA DESCRIZIONE_PRESSO TIPO_UBICAZIONE TIPOLOGIA_TERMINALE MODELLO_TERMINALE INDIRIZZO COMUNE PRO REGIONE CAP BARCODE_SI_NO DATA_ATTIVAZIONE_BARCODE; define DATA_ATTIVAZIONE_BARCODE / FORMAT=DDMMYY10.; define KEYATM / FORMAT=$15.; run; ODS TAGSETS.EXCELXP CLOSE; The problem is the column KEYATM: define KEYATM / FORMAT=$15.; in the file xml i have a number format and not text   What is the problem ? I need text 020082230007073 .... Thanks!!!! ... View more

Hi, i would import a file excel but i have a problem:   PROC IMPORT OUT= WORK.example DATAFILE= "C:\Users\ui43925\Desktop\example.XLSX" DBMS=EXCEL REPLACE; SHEET="example"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN;     After import, in the table sas the column "Ora format" and "Hour" isn't format timestamt but in DATE9., what is my fault ? Thanks!!!   ... View more

Hi, i have create this sas macro: %MACRO MACROFILTRO (TABELLA=, OWNER= ); PROC SQL; CREATE TABLE ATM.T7_D_ELENCO_TERMINALI_IMP AS SELECT * FROM ATM.T7_D_ELENCO_TERMINALI_IMP UNION ALL SELECT C.*, B.IM_TOT_CARIC, B.CO_ID_OLI FROM ATM.T7_D_ELENCO_TERMINALI_VER1 A INNER JOIN ATM.T01C_CANONI C ON (A.KEYATM = C.KEYATM) LEFT JOIN &OWNER..MOANAATM_&TABELLA B ON (A.KEYATM = B.KEYATM) /* 1° 102015 2° 082015 3° 062015 4* 042015 5° 022015 6° 012015 7°122014 8° 112014 9°062014 10° 012014 11° 082013*/ WHERE B.KEYATM IS NOT NULL ; quit; %MEND MACROFILTRO; %MACROFILTRO(TABELLA=%Str(102015), OWNER= %Str(TERM) ); why i have this error ? 1780 WHERE B.KEYATM IS NOT NULL 1781 ; 1782 quit; 1783 1784 %MEND MACROFILTRO; 1785 %MACROFILTRO(TABELLA=%Str(102015), OWNER= %Str(TERM) ); NOTE: Line generated by the macro variable "TABELLA". 1 TERM.MOANAATM_102015 ------ 22 ------ 200 ERROR 22-322: Syntax error, expecting one of the following: a name, (, AS, ON. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.00 seconds Thanks!!!!!!!!!!!!!!!!!!!   ... View more