Solved
New Contributor
Posts: 2

# How to find oud the non missing values of any particular variable at any particular position from existing table

To find out the non missing values of any particular variable at any particular position with conditional statement like it should be greater than or less than

SUB VISIT SBP DBP WEIGHT

001   1      124   134   180

002   2                        170

003   3                        178

004   4      345     128   150

005   5      137     167   180

006   1      136     156   178

007   2      145     152    187

008   3                         187

1. Get only latest non-missing values from on or before 3 visit into 3 different data sets for DBP, SBP and Weight variables

2. Merge all three, SBP, DBP, WEIGHT

I appreciate if you guide me.

Thanks.

Accepted Solutions
Solution
‎04-08-2015 02:55 PM
Posts: 3,852

## Re: How to find oud the non missing values of any particular variable at any particular position from existing table

Your question lacks sufficient details but I will show you what I think you want.  Also,  the values of SUB in your example don't look right and I changed them.

data visit;
input SUB :\$3. VISIT SBP DBP WEIGHT;
cards;
001   1      124   134   180
001   2        .     .   170
001   3        .     .    178
001   4      345     128   150
001   5      137     167   180
002   1      136     156   178
002   2      145     152    187
002   3        .       .     187
;;;;
run;
proc print;

run;
data lastnonmiss;
update visit(obs=0) visit(where=(visit le 3));
by sub;
drop visit;
run;
proc print;

run;

All Replies
Solution
‎04-08-2015 02:55 PM
Posts: 3,852

## Re: How to find oud the non missing values of any particular variable at any particular position from existing table

Your question lacks sufficient details but I will show you what I think you want.  Also,  the values of SUB in your example don't look right and I changed them.

data visit;
input SUB :\$3. VISIT SBP DBP WEIGHT;
cards;
001   1      124   134   180
001   2        .     .   170
001   3        .     .    178
001   4      345     128   150
001   5      137     167   180
002   1      136     156   178
002   2      145     152    187
002   3        .       .     187
;;;;
run;
proc print;

run;
data lastnonmiss;
update visit(obs=0) visit(where=(visit le 3));
by sub;
drop visit;
run;
proc print;

run;

Super User
Posts: 10,784

## Re: How to find oud the non missing values of any particular variable at any particular position from existing table

John,

If I understood right. OP want this:

001   1     124   134   180

001   2        .        .   170

001   3        .     90    178

001   4      345     128   150

001   5      137     167   180

002   1      136     156   178

002   2      145     152    187

002   3        .       .     187

🔒 This topic is solved and locked.