topic Re: Need help with copying data into missing fields using SAS VA 7.3 Data Builder in SAS Visual Analytics

Need help with copying data into missing fields using SAS VA 7.3 Data Builder

cdickens3676 — Thu, 17 May 2018 15:06:27 GMT

I need assistance Need help with copying data into missing fields using SAS VA 7.3 Data Builder

Here is an example of the results in Data prep

Record ID Name Activity Number Year Month

1 snoopy 123

1 2018 JAN

2 bob 456

2 2018 FEB

3 raul 123

3 2018 MAR

Here is what I want the results to look like

Record ID Name Activity Number Year Month

1 snoopy 123 2018 JAN

2 bob 456 2018 FEB

3 raul 123 2018 MAR

Reeza — Thu, 17 May 2018 15:10:20 GMT

If it supports data step code:

data want;
update have(obs=0)  have;
by recordID;
run;

FredrikE — Fri, 18 May 2018 07:19:17 GMT

Sweet 🙂