Flow of Data Step

iSAS — Tue, 20 Oct 2020 13:34:15 GMT

Hello,

Please refer on the data steps below:

data have;
length;
infile datalines delimiter='|' dsd truncover;
input job_id return_cd1 Trigger $ Prerequisite $;
datalines;
2|0|Exec|
11|1|Exec|
7|.|Not Exec|11,2
;
run;

data Job_Sch_Merge;
set have;
array statuses(1000) _temporary_;
length pending_job $100;
statuses(job_id) = return_cd1;
if find(Trigger,'Not Exec','i') and Prerequisite ne '' then do; /*This will list down pending pre-requisite jobs in pending_job column*/
do _n_ = 1 to countw(Prerequisite);
_job = scan(Prerequisite,_n_);
if statuses(_job) ne 0 then
pending_job = compress(catx(',',pending_job,_job),,'s');
end;
end;
drop _job /*return_cd1*/;
run;

data step Job_Sch_Merge will work fine as long as the Prerequisite of a job_id is above it (see above work.have).

However, if work.have is like the dataset below, it will have an issue. May i know how to fix data step Job_Sch_Merge? Thank you in advanced.

data have;
length;
infile datalines delimiter='|' dsd truncover;
input job_id return_cd1 Trigger $ Prerequisite $;
datalines;
2|0|Exec|
7|.|Not Exec|11
11|0|Exec|
;
run;

Re: Flow of Data Step

Kurt_Bremser — Tue, 20 Oct 2020 13:30:14 GMT

Expand your DATALINES statement:

infile datalines delimiter='|' dsd truncover;

so that missing values are correctly dealt with.

topic Re: Flow of Data Step in SAS Programming

Flow of Data Step

Re: Flow of Data Step