DATA Step, Macro, Functions and more

How to remove the missing values

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

How to remove the missing values

Hi , i have a data like below , i have to remove the missing cells , please suggest how to do so

 

have .. 

IDshift_loginshift_logoutlunch_loginLunch_logoutrest_loginRest_logout
aaaaa....8:5617:30
aaaaa..8:5617:30..
aaaaa8:5617:30....
bbbbb....8:5617:30
bbbbb..8:5617:30..
bbbbb8:5617:30....

 

WANT...

IDshift_loginshift_logoutlunch_loginLunch_logoutrest_loginRest_logout
aaaaa8:5617:308:5617:308:5617:30
bbbbb8:5617:308:5617:308:5617:30

Accepted Solutions
Solution
‎12-21-2017 07:21 AM
PROC Star
Posts: 1,405

Re: How to remove the missing values

[ Edited ]
Posted in reply to soham_sas

Do like this

 

data have;
input ID$ (shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout)(:time5.);
format shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout time5.;
datalines;
aaaaa . . . . 8:56 17:30
aaaaa . . 8:56 17:30 . .
aaaaa 8:56 17:30 . . . .
bbbbb . . . . 8:56 17:30
bbbbb . . 8:56 17:30 . .
bbbbb 8:56 17:30 . . . .
;

proc sort data=have;
	by ID;
run;

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

 

View solution in original post


All Replies
Solution
‎12-21-2017 07:21 AM
PROC Star
Posts: 1,405

Re: How to remove the missing values

[ Edited ]
Posted in reply to soham_sas

Do like this

 

data have;
input ID$ (shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout)(:time5.);
format shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout time5.;
datalines;
aaaaa . . . . 8:56 17:30
aaaaa . . 8:56 17:30 . .
aaaaa 8:56 17:30 . . . .
bbbbb . . . . 8:56 17:30
bbbbb . . 8:56 17:30 . .
bbbbb 8:56 17:30 . . . .
;

proc sort data=have;
	by ID;
run;

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 174 views
  • 0 likes
  • 2 in conversation