topic Re: Replacing dates based on Flags & Events in SAS Programming

Replacing dates based on Flags & Events

ASHISH2525 — Mon, 27 May 2019 06:19:50 GMT

Hi all,

I have attached input excel data file & desired output as well.

i have an id 'plan package' for multiple events (Event column )and datetype flag as 'Sch' and 'Act'. if an id has two records as 'Act' & 'Sch' then it should be considered as complete records & no need to have it in output.

outcome which i want is if 'Act' is not available & only 'Sch' is available for a record then on the basis of its 'Plan package' & Event its 'Date' should be replaced accordingly previous 'Act' flag record.

Let me know if any other details are required.

Regard,

Ashish

Re: Replacing dates based on Flags & Events

PeterClemmensen — Mon, 27 May 2019 06:56:23 GMT

Can you post a small part example data in the form of a data step instead? Makes it so much easier to help you.

Re: Replacing dates based on Flags & Events

andreas_lds — Mon, 27 May 2019 06:59:04 GMT

Please post the data you have and what you want as text, i won't open excel-files. See How to convert datasets to data steps for details.

Re: Replacing dates based on Flags & Events

ASHISH2525 — Mon, 27 May 2019 09:02:17 GMT

DATA WORK.INPUT0001;
LENGTH
PlanPackage $ 6
Discipline $ 10
Dates 8
Events $ 11
DateType $ 3 ;
FORMAT
PlanPackage $CHAR6.
Discipline $CHAR10.
Dates DATE9.
Events $CHAR11.
DateType $CHAR3. ;
INFORMAT
PlanPackage $CHAR6.
Discipline $CHAR10.
Dates DATE9.
Events $CHAR11.
DateType $CHAR3. ;
INFILE DATALINES4
DLM='7F'x
MISSOVER
DSD ;
INPUT
PlanPackage : $CHAR6.
Discipline : $CHAR10.
Dates : BEST32.
Events : $CHAR11.
DateType : $CHAR3. ;
DATALINES4;
007EUCElectrical20691Stage oneSch
007EUCElectrical20620Stage oneAch
007EUCElectrical20730Stage twoSch
007EUCElectrical20670Stage threeSch
007EUCElectrical20670Stage threeAch
007EUCElectrical20670Stage fourSch
007EUCElectrical20620Stage fiveSch
007EUCElectrical20573Stage fiveAch
007ZAElectrical20606Stage oneSch
007ZAElectrical20657Stage twoSch
007ZAElectrical20529Stage twoAch
;;;;

Output snap has been attached with Data steps.