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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.