Control file check in SAS DI 3.4

[SYN]

I am getting one .CSV file along with control file.

Control file having number of records in .CSV file.

How can I check the records count in control file and .csv file records count.

Please any one help me about this. Thanks in advance.

[Patrick]

One way to go:

You first read both the control and data file. Then you add a user written code node (or a user transformation if such comparison is used for more than one file). The code could look like something below ( not tested):

Data _null_;

call symput('nobs',cats(nobs));

stop;

set <my data> nobs=nobs;

run;

data _null_;

set <control>;

if <ctrl var containing number of obs> ne &nobs then <do something>;

run;

[shivas]

Hi Syn,

You can create control table using Library contents transformation(please read it).

For example purpose i have hard coded the value(but you can get his values from control table) .

First create a job with your csv file and load into data set.After job is created then add post process code.

Hope this helps..

log

2050       data _null_;

2051       if &x=5 then job="Success";

2052       else job="fail";

2053       put job=;

2054       ;

2055       run;

job=Success

Thanks,

Shiva