Hello,   I am running some ETL routines against an Oracle database via SAS ACCESS ODBC, using PROC SQL.   There is a datetime field in the source table that contains some invalid values (8 of then according to the log) and I would like to view these in order to provide feedback to the users and get them fixed.   Code: proc sql; create table test2 as select myDateField as dates from myTableView order by dates; quit;   I see the following log note: The data value for column DATES (DATES) was truncated or was out of range 8 times when retrieving that data from the DBMS.   I have tried using the "Put" function, but this also gives an error.   Thansk in advance   Jim ... View more

Hi all,   I have some budgetary data that needs to be included on a VA report, which is provided at a "Department" level. The VA report in question is built over a dataset that is at the sales invoice level.   What would be your advice on the best ways to allow the top level visualisations, at Company and Department level, to show the budget data along with actual sales metrics, whilst allowing drill down all the way to the sales invoice level.   I was thinking of doing something in SAS Studio at the data prep stage, perhaps dividing the budget by number of invoices to give budget column, which should then sum all the way back up once in VA...   Thanks in advance   Jim     ... View more