Hi All,   I have a few hundred csv files which I need to register in DI Studio (so that they either appear under External Files in the inventory or are imported straight into a SAS library) I also need to set formats and lengths etc. I'd rather not do all of this manually through te wizard but cannot find a way of registering external files fully in code. The register external files wizard doesn't produce any code, just the INFILE statement.   I have a table which contains all, table names, field names, field types and lengths within all of the csv files and was hoping to be able to use macro code to loop over this and create everything on the fly.   Does anyone please have any ideas on how could this be implemented in DI Studio?   Thanks, Matt ... View more

Hi All,   I'm trying to upload around 600 csv files, with differing content, from Windows to a SAS Server to use in DI. Can't import via DI as the facility is switched off due to security limitations. I've come up with a workaround which is using EGs Import Data task but I don't fancy setting a task up for 600 tables as I'd rapidly lose the will to live....   This is in the code for the import task...   Note: In preparation for running the following code, the Import Data wizard has used internal routines to transfer the source data file from the local file system to SASApp-CPB. There is no SAS code available to represent this action.   This suggests that there is a magic way of moving files from Windows to a SAS Server. Does anyone know what SAS does behind the scenes here? Or if there is another solution? Even if I could just get some libnames it would be a great help.   Thanks and have a great day.   Matt ... View more