@Alkibiades wrote: The screenshot is actually the metadata object of the csv file, not the File Reader. The File Writer does not offer any real Option I could identify using labels. True. And yes, the file writer doesn't provide such an option so you will have to do your own thing.     ... View more

I indeed missed that, good point, thank you.   Not all rules should be checked, just a subset for certain customer.   I'll expand my example:   Dataset data1: obs   customer_no   Field1    Field2    Field3 1           a11                 3           5             UT 2           b34                 0           12           XX3 ...            Dataset data2: obs customer_no   rule_no operand1   rel_oper     operand2 1            b34               r1          Field1            >                  0 2            a11               r2          Field3            =                 UT 3            a11               r3          Field1           <=              Field2   I was thinking of utilizing a hash for this.   Then I even pondered using ds2, the only issue with ds2 is, I cannot hand over values to be used as field names themselves who then reference to the value I want to check. Or handing over values as macro variables to be used in the invoked method as field names like in a macro. If that was possible somehow, it could be a very elegant solution.       ... View more

The PROC SETINIT output indicates that SAS/IML isn't licensed so the SAS interface to R is not an option.   You do license the SAS Add-in for Microsoft Excel and SAS Integration Technologies so I think you can use a stored process to upload the data directly from Excel to the SAS server.   Create a stored process with this code:   %STPBEGIN; libname inxml xml; data work.mydata; set inxml.&_WEBIN_SASNAME; run; * Optional - display output in Excel; title 'Data Received from Excel'; proc print data=work.mydata; run; quit; %STPEND;   During the registration process specify Stream and Package for Result capabilities, and then these options to create a new input data source:     When you run the stored process using the SAS Add-in for Microsoft Office you are asked to select the data.  For example, select A1:C2:     The data is pushed to the SAS server, a temporary data set named WORK.MYDATA is created, and then the PROC PRINT output is displayed in Excel:     Vince DelGobbo SAS R&D ... View more