topic Replacing null columns in the table with precious not null column in SAS Programming

Replacing null columns in the table with precious not null column

vskon — Tue, 15 Sep 2020 12:07:19 GMT

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

Re: SAS Code

brzcol — Fri, 11 Sep 2020 15:43:54 GMT

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?

Re: SAS Code

PaigeMiller — Fri, 11 Sep 2020 15:49:55 GMT

@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.