Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
Solved
if no errors write output file - if error create empty file - SAS 9.2
Posted on 2013-12-17
Experts,
I have a file that has four columns I am checking to see if there is an error.
if start_date_error = 'X' or
end_date_error = 'X' or
residual_start_error = 'X' or
residual_end_error = 'X' or
lob_error = 'X' or
media_type_error = 'X' or
dnis = . then ..........................
If one of the above conditions is true for any record on the file, I do not want to write an output file. If none of the records have an error, I would like to write an output file.
Can someone tell me if there is a way to do this?
The challenge is all records from the file need to be tested before the decision can be made to create an output file or an empty file.
I have a file that has four columns I am checking to see if there is an error.
if start_date_error = 'X' or
end_date_error = 'X' or
residual_start_error = 'X' or
residual_end_error = 'X' or
lob_error = 'X' or
media_type_error = 'X' or
dnis = . then ..........................
If one of the above conditions is true for any record on the file, I do not want to write an output file. If none of the records have an error, I would like to write an output file.
Can someone tell me if there is a way to do this?
The challenge is all records from the file need to be tested before the decision can be made to create an output file or an empty file.
1 Comment
this can only be accomplished in 2 steps:
step 1 scan through the entire dataset:
data _null_;
set [source data] end = eof;
retain haserror; /* any variable you like to name it */
if _N_ eq 1 then haserror = 0; /* if first record initialize to 0 */
haserror = [all your conditons]; /* as long as the conditions return a TRUE, then haserror will hold the value 1 else haserror will continue to hold the value 0 because of the retain statement */
if eof then do; /* reached the end of dataset */
call symput("haserror", haserror); /* set the last value of haserror into a global variable named haserror - again it's up to you to name it */
end;
run;
step 2 write a macro to determine the next step to take:
%macro donext;
%if &haserror eq 1 %then %do;
[code to create empty file]
%end;
%else %do;
[code to create output file]
%end;
%mend;
%donext;
step 1 scan through the entire dataset:
data _null_;
set [source data] end = eof;
retain haserror; /* any variable you like to name it */
if _N_ eq 1 then haserror = 0; /* if first record initialize to 0 */
haserror = [all your conditons]; /* as long as the conditions return a TRUE, then haserror will hold the value 1 else haserror will continue to hold the value 0 because of the retain statement */
if eof then do; /* reached the end of dataset */
call symput("haserror", haserror); /* set the last value of haserror into a global variable named haserror - again it's up to you to name it */
end;
run;
step 2 write a macro to determine the next step to take:
%macro donext;
%if &haserror eq 1 %then %do;
[code to create empty file]
%end;
%else %do;
[code to create output file]
%end;
%mend;
%donext;
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day.
…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses
Course of the Month11 days, 13 hours left to enroll
601 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.