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

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

sufianbadar — Wed, 08 Apr 2015 17:53:35 GMT

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.

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

data_null__ — Wed, 08 Apr 2015 18:55:49 GMT

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;

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

Ksharp — Thu, 09 Apr 2015 14:34:26 GMT

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