SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Control file check in SAS DI 3.4

Reply
Contributor SYN
Contributor
Posts: 39

Control file check in SAS DI 3.4


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.

Respected Advisor
Posts: 3,908

Re: Control file check in SAS DI 3.4

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;

Super Contributor
Posts: 349

Re: Control file check in SAS DI 3.4

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..

control1.png

control table.png

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

Ask a Question
Discussion stats
  • 2 replies
  • 245 views
  • 0 likes
  • 3 in conversation