topic Re: is it possible to tell from codes if a var is new created or from input datasets? in SAS Programming

is it possible to tell from codes if a var is new created or from input datasets?

HeatherNewton — Fri, 22 Apr 2022 10:06:09 GMT

data AMBSA_STATIC(drop=flag tmp point tmp2 _rowcnt);
infile "&G_IFC_RAW_PENDING_PATH./ambsa.static.txt" RECEM+N;
RETAIN flag 0;
If flag=0 then 0;
input tmp $EBCDIC87. @@;
point=index(tmp, '#BEGIN');
if point then do;
call cynput("header_ind",'Y');
header=substr(tmp,1,86);
point =point+86;
flag=1;
input @point r_dte $EBCDIC10. @@;
link readdata;
end;
end;
else do;
input r_dte $EBCDIC10. @@;
link readdata;
end;
if flag=1;
return:
readdata:
if substr(r_dte,1,4) ne '#END' or substr(r_Dte,1,1)ne '#' THEN DO;
input r_type $EBCDIC1.
ABMS_ORG $EBCDIC3.
.
.
AMBS_USER_AMT S370FPD9.0
.
.
.
AMBS_LOAN_TRF_IND    $EBCDIC1

@@;
END;
ELSE DO;
input tmp2 $EBCDIC76.;
CALL SYMPUT("trailer_ind",'y');
trailer=r_dte || tmp2
_rowcnt=sub(trailer,70,9);
FILE log;
IF input(_rowcnt,9)=_n_-1 then do;
PUT_rowcnt _n_;
put "correct_Row_number";
.
.
.

my question is "is it possible to tell if r_dte is created newly in this program or it comes from input dataset RAW_PENDING_PATH.

Re: is it possible to tell from codes if a var is new created or from input datasets?

PaigeMiller — Fri, 22 Apr 2022 10:43:52 GMT

@HeatherNewton wrote:
my question is "is it possible to tell if r_dte is created newly in this program or it comes from input dataset RAW_PENDING_PATH.

Yes:

you can look at the code; or
you can look at the variables in RAW_PENDING_PATH via PROC CONTENTS or other means.

Re: is it possible to tell from codes if a var is new created or from input datasets?

Kurt_Bremser — Fri, 22 Apr 2022 11:40:40 GMT

Option 3: read the log. A message about uninitialized variables positively tells you it's not in an incoming dataset.

Re: is it possible to tell from codes if a var is new created or from input datasets?

andreas_lds — Fri, 22 Apr 2022 11:49:58 GMT

I don't see any statement in your code, that processes a dataset at all, so all variables are created in the step you have posted.

Re: is it possible to tell from codes if a var is new created or from input datasets?

Sajid01 — Fri, 22 Apr 2022 12:05:51 GMT

The variable r_dte does not come from RAW_PEBDING_PATH. It is indeed created newly by the code.

Re: is it possible to tell from codes if a var is new created or from input datasets?

Tom — Fri, 22 Apr 2022 13:06:04 GMT

Can you attempt again to explain what your question is? The current question does not appear to have anything to do with the example code posted. The posted code is not using any existing DATASET. It is reading from a TEXT FILE.

Are you asking if the data step is reading the value of the variable from the contents of the text file?

Then yes there are two different INPUT statement that are setting the value of r_dte by reading characters from the text file.

input @point r_dte $EBCDIC10. @@;
...
input r_dte $EBCDIC10. @@;