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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.