Replacing null columns in the table with precious not null column

[vskon]

The following is my Input 
 
 
INPUT
 
 
 
 
 
 
 
id
email
date
1
 
1/1/2020
1
a@gmail.com
1/2/2020
1
 
1/3/2020
1
 
1/4/2020
1
 
1/5/2020
1
b@gmail.com
1/6/2020
1
 
1/7/2020
2
c@gmail.com
1/1/2020
2
 
1/2/2020
2
 
1/3/2020
2
 
1/4/2020
2
 
1/5/2020
2
d@gmail.com
1/6/2020
2
 
1/7/2020
2
 
1/8/2020
2
 
1/9/2020
and I am trying to achieve the below output using SAS. 
 
 
OUTPUT
 
 
 
 
 
 
 
id
email
date
1
a@gmail.com
1/1/2020
1
a@gmail.com
1/2/2020
1
a@gmail.com
1/3/2020
1
a@gmail.com
1/4/2020
1
a@gmail.com
1/5/2020
1
b@gmail.com
1/6/2020
1
b@gmail.com
1/7/2020
2
c@gmail.com
1/1/2020
2
c@gmail.com
1/2/2020
2
c@gmail.com
1/3/2020
2
c@gmail.com
1/4/2020
2
c@gmail.com
1/5/2020
2
d@gmail.com
1/6/2020
2
d@gmail.com
1/7/2020
2
d@gmail.com
1/8/2020
2
d@gmail.com
1/9/2020
 
Please suggest.
 
Thank you in advance

[brzcol]

Hi,

Thank you for posting a picture of some sample data. I have a few questions for you:

• Is the data coming from an Excel spreadsheet, csv file, etc?
• In your data, will the email for row 1 always be missing?
• What is the relationship between the ID and the emails? I noticed the emails for A and B both correspond to ID 1. 
• Is the purpose to create a new table or a report?
• What code have you tried thus far?

[PaigeMiller]

@vskon Please help everyone out by changing the Subject on your original post to something that describes the problem. "SAS Code" is not a meaningful description. Something like "Filling in Blank Lines" would be a much better subject, it is a meaningful description of your problem, and it allows the SAS Community to operate more efficiently, people with a similar problem can see this meaningful subject line and read the responses.