Hi,
I would like to ask a simple question to you. Let's pretend I have two variables and one of them keep records as date values or keep missing values based on CLIENTNO. I want to replace the missing values with date values into same variable.
If you can examine my sample data set as below, you can understand my question better.
Data Have;
Length CLIENTNO 8 DATE $ 20;
Infile Datalines Missover;
Input CLIENTNO DATE;
Datalines;
1 201601
1 201601
1 .
2 .
2 201602
2 .
3 201603
3 201603
3 .
4 201604
4 201604
4 201604
;
Run;
Desired
Or I can also create this desired output in new variable.
Thanks
Here's the SQL way:
proc sql;
create table want as
select *, max(date) as date_filled
from have
group by clientNo;
quit;
And a data step way:
proc sort data=have;
by clientno descending date;
run;
data want_data;
set have;
by clientNo;
retain date_filled;
if first.clientNo then
date_filled=date;
run;
Can you assume the value of DATE is constant throughout all ClientNo?
I think, I can say. My anticipation is that way.
Here's the SQL way:
proc sql;
create table want as
select *, max(date) as date_filled
from have
group by clientNo;
quit;
And a data step way:
proc sort data=have;
by clientno descending date;
run;
data want_data;
set have;
by clientNo;
retain date_filled;
if first.clientNo then
date_filled=date;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.