topic Re: Control file check in SAS DI 3.4 in SAS Data Management

Control file check in SAS DI 3.4

SYN — Thu, 21 Jun 2012 10:35:36 GMT

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.

Re: Control file check in SAS DI 3.4

Patrick — Thu, 21 Jun 2012 11:53:36 GMT

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;

Re: Control file check in SAS DI 3.4

shivas — Fri, 22 Jun 2012 04:23:02 GMT

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