topic Re: need to read text file has zero in SAS Programming

need to read text file has zero

cho16 — Fri, 05 Aug 2022 15:41:04 GMT

Hi there,

We aim to add some additional logic to the prod code that already exists. The code should read the text file as though it were a one-time task if any plans needed to be removed from the logic. Otherwise, 0 values must be read from the text file.
Is it possible to add logic to it in any way?

Thanks in advance

Re: need to read text file has zero

Tom — Fri, 05 Aug 2022 15:52:13 GMT

Probably since SAS is a programming language.

But you need to provide a lot more information about what you are actually doing and what the terms you are using actually mean.

Re: need to read text file has zero

cho16 — Fri, 05 Aug 2022 16:38:36 GMT

Tom...Below I have provided some additional details..
Can we add a flag that says "Y" or "N"? If changes need to be made, set the flag to "Y" and start the process. If not, the procedure shouldn't start.
DATA DE_CONVER_ACTS;
infile "/hf_out.txt" dsd dlm='|' MISSOVER FIRSTOBS=2 end=eof;
length
ACCOUNT$ 16
SYS$ 4
MEMBER$ 4
AGENT$ 4
Date$ 8
;

input
ACCOUNT$
SYS$
PRIN$
MEMBER $
Date$
;
run;

Re: need to read text file has zero

Kurt_Bremser — Fri, 05 Aug 2022 16:46:11 GMT

Explain (in detail!) what you mean by this:

If changes need to be made

and also, what you mean by "process" and "procedure".

Re: need to read text file has zero

cho16 — Fri, 05 Aug 2022 16:56:42 GMT

Our organization has a lot of plans. The vendor will put the file in one place if we wish to eliminate one plan from the extract.
For instance, the deconversion is a one-time activity for the August release; the same process should not be followed for the September release; again, the deconversion will occur for the November release; hence, there is no need to modify the SAS code; rather, additional conditions must be included.Hope this helps

Re: need to read text file has zero

Reeza — Fri, 05 Aug 2022 17:00:38 GMT

What tool are you using? SAS DIS or Studio/Base?



%macro run_report(report_run = );
%if &report_run = Y %then %do;

DATA DE_CONVER_ACTS;
infile "/hf_out.txt" dsd dlm='|' MISSOVER FIRSTOBS=2 end=eof;
length
ACCOUNT$ 16
SYS$ 4
MEMBER$ 4
AGENT$ 4
Date$ 8
;

input
ACCOUNT$
SYS$
PRIN$
MEMBER $
Date$
;
run;
%end;

%mend;

%let changes_required = Y;

%run_report(report_run= &changes_required);

UCLA introductory tutorial on macro variables and macros

https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

Tutorial on converting a working program to a macro

This method is pretty robust and helps prevent errors and makes it much easier to debug your code. Obviously biased, because I wrote it 🙂 https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Examples of common macro usage

https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716

Re: need to read text file has zero

cho16 — Fri, 05 Aug 2022 17:03:53 GMT

Thanks Reeza..we are using SAS EG

Re: need to read text file has zero

Reeza — Fri, 05 Aug 2022 17:15:03 GMT

Do you want a prompt in the process?
Or set a macro variable at the start of a program?
Do you have a control program where you set parameters?
Or is the status of changes required driven by something in the process?

Either way the macro solution above is how you structure the code. Exactly how you incorporate that into your process depends on your process, which we do not have or understand. You could have a prompt for the parameter instead of the LET for example.

Re: need to read text file has zero

Tom — Sat, 06 Aug 2022 14:45:48 GMT

Which variable is the one that indicates if the "process" needs to happen?

None of those variable names look like they could contain that information.

ACCOUNT SYS MEMBER AGENT Date

Or are you saying that the indicator is whether or not there are any records in the file?

DATA DE_CONVER_ACTS;
  if eof then call symputx('nobs',_n_-1);
  infile "/hf_out.txt" dsd dlm='|' MISSOVER FIRSTOBS=2 end=eof;
...
run;

%if &nobs %then %do;
... process that will be skipped ...
%end;

Or are you saying that the indicator is whether or not there is a file?

%if %sysfunc(fileexist(/hf_out.txt)) %then %do;
... process that will be skipped ...
%end;