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.
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;
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.