@Suminder
It's also with DIS not that hard. You just can't use an out-of-the-box transformation which does everything for you but you need to implement user written code.
The DIS way is to implement such user written code directly within the External File object as documented here:
https://go.documentation.sas.com/?docsetId=etlug&docsetTarget=p1h7xnr4n6dmown11ceyi9nmpq7p.htm&docsetVersion=4.903&locale=en
You then can use this External File object as you normally would (as input for a file reader) and then load the extracted table into target via whatever DIS transform is appropriate (like the Table Loader).
Below SAS code demonstrating how you can read your data into the desired target structure - so code close to what you will need for your External File.
/* create the sample external file */
filename extfile temp;
data _null_;
file extfile;
put
'Field1|Field2|Field3|Field4|Field5'/
'id1|name1|age1|DOB1|chr1,chr2,chr3'/
'id2|name2|age2|DOB2|chr4,chr5,chr6'
;
run;
/* read the external file into the desired table structure
- this code bit is close to what you need to implement in the external file object
*/
data read(drop=_:);
infile extfile dlm='|' dsd truncover firstobs=2;
input (Field1 Field2 Field3 Field4) (:$10.) _Field5 :$20.;
length Field5 $10;
_stop=sum(1,countc(_Field5,','));
do _i=1 to _stop;
Field5=scan(_Field5,_i,',');
output;
end;
run;
/* print the created SAS table */
proc print data=read;
run;
... View more
