I try to eport csv files in a DI Studio job using the file writer transformation. So far, so good. But when I try to have labels as a header instead of the variable names via entering label as a infile statement of the meta data object of the file, he still uses variables instead of labels as headers. Am I missing an option to get labels instead of variable names? ... View more

Okay, I have a tricky issue and hope for some help.   I have two datasets, one (data1) which has values as data and one (data2) which has field names and relational operators which whom I want to check the data in the first dataset.   For instance:   Dataset data1: obs   Field1    Field2    Field3 1           3           5             UT 2           0           12           XX3 ...            Dataset data2: obs rule_no operand1   rel_oper     operand2 1     r1          Field1            >                  0 2     r2          Field3            =                 UT 3     r3          Field1           <=              Field2 ...   I seek to execute the validation rules of data2 on data1 and thus have to resolve operand1, rel_oper and operand2 on the fly if they are fieldnames of data1. For instance if I wand to check the rule in obs 3 of data2 on ob1 of data1 I would expect: 3 <= 5   My first idea was to use a hash to lookup on the validation rules like:   data test;   attrib ...; if _n_ eq 1 then do     dcl hash data2(dataset: 'data2')     data2.definekey('rule_no');     data2.definedata('operand1','rel_oper','operand2');     data2.definedone();     call missing(operand1,rel_oper,operand2); end; set data1; rule_no = r3; rc = data2.find(); now I somehow try to manage to resolve the value of the field name I get from the hash.   run;   Maybe there is a better Solution to my problem? ... View more

The subject may be a little confusing but here is what I want to achive with DS2:   I have a dataset containing a field which contains values I want to use as code, when invoking a method in ds2.    In case of a macro I would use something like that:   %macro subu(ruu1); data test; set sas_data.orders; if &ruu1. then output; run; %mend subu; data _null_; set testdat; call execute('%subu('||vari||')'); run; In this case dataset testdat only having one obs and one variable vari which contains the value: ordertype eq 3   Is there an option in ds2 to call a method with field values of a dataset as parameters which could be used as code it executes in said method? Or can macros be called from a ds2 anyhow? ... View more

Is there a possibility to import xls/xlsx-files into SAS without having ACCESS to PC Files licensed? We have this need just sporadically so licensing ACCESS to PC Files is basically not worth the expenses.   Somewhere I read proc import with the option dbms=xls does not require ACCESS to PC Files. But I nonetheless get the error: ERROR: DBMS type XLS not valid for import. Is there any other possibility or do I have to convert the excel files to csv?     We use SAS 9.04 M3. ... View more