We're trying to incoroprate Data Management Studio into our process by cleaning up data before doing our transformations and such in DI Studio.
Source data comes from Excel, and we use a user written code node in DI Studio to write a proc import statement to turn the excel spreadsheets into sas datasets. The output datasets look like attached image, but we want them to look as follows:
ID Name Date
1 John Fall 2013
2 Juan Fall 2013
3 Kara Fall 2013
So, my questions are...
1) Is there a way to do this in the proc import statement? Create a new column and provide the value for it?
2) If not, can this be done in Dataflux - Data Management Studio?
The idea is that we convert the spreadsheets into sas datasets, Dataflux cleans the data, then DI Studio continues processing the clean datasets.
I can do the above in DI Studio (and probably the data standardization with lookup tables), but again we want to do cleaning and standardizing in Dataflux if possible.
Are we going about this the wrong way?
Thanks!
... View more