Hi All,   I regularly use EG to produce (semi) automated data extractions.I have a question which i can't seem to find the answer to anywhere so hoping some of you can help.   I have an EGP which extracts a bunch of data for a bunch of a list of individuals (changes each week, as does the volume of people) from different tables from all over our database. Most of the tables are Oracle and some are HUGE and because it can takes a while to bring back the data back, I pull all the data for all individuals, at the same time.   Because of skills in house, we tend not to use a lot of Program nodes as we have to QA all work to check it's ok and there is a lack of SAS skills in department meaning this is not an issues, so I'm using Query/Append/Transpose nodes etc to get work done.      The second 'part' of the eg, then munges the data together for the first individual in the list and formats it into a usable report which is output.   What I'm trying to do, is get the EG to then loop back to the start of the second 'part' to re-run steps 10-20 (for example) and munge together individuals 2's data, then loop back to do individual 3 etc until it's finished.   Anyone got any ideas how I can achieve this? I'm at a bit of a loss!   Cheers ... View more

Hi All,   First time post - usually I can find an anwer by seaching the forums, but I've struggled on this one.   I've built a WORK.OUTPUT table in EG with some date columns with a dd/mm/yyyy format.   I'm then using a Program with PROC SQL to create a table in Oracle based upon the WORK.OUTPUT table.   However when I do this, all the dates are defaulting to SAS styled format: DD-MON-YY in the Oracle table. How do I get PROC SQL to build the table in oracle with dd/mm/yyyy date formats? I've tried both:   PROC SQL create table ORACLELIB.NEW_TABLE as SELECT * FROM WORK.OUTPUT; QUIT;   and   PROC SQL; create table ORACLELIB.NEW_TABLE as select ITEM 1 ,ITEM 2 ,DATE_1 format=ddmmyys10. ,DATE_2 format=ddmmyys10. FROM WORK.OUTPUT; QUIT;   Anyone able to help? ... View more