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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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
Respected Advisor
Posts: 3,788

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;


4-8-2015 1-54-17 PM.png

View solution in original post


All Replies
Solution
‎04-08-2015 02:55 PM
Respected Advisor
Posts: 3,788

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;


4-8-2015 1-54-17 PM.png
Super User
Posts: 9,875

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.

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

Discussion stats
  • 2 replies
  • 202 views
  • 0 likes
  • 3 in conversation