input dataset as below: data ds; input idno 1-4 visit $ 6-11 lab $17-20 value; cards; Su01 visit1 red1 . Su01 visit1 red2 . Su01 visit1 red3 . Su01 visit1 red4 . Su01 visit1 red1 200 Su01 visit1 red2 10 Su01 visit1 red3 . Su01 visit1 red4 . Su01 visit1 red5 . Su01 visit1 red6 . Su01 visit1 red7 150 Su02 visit1 red1 300 Su02 visit1 red2 45 Su02 visit1 red3 . Su02 visit1 red4 30 Su02 visit1 red1 200 Su02 visit1 red2 10 Su02 visit1 red3 . Su02 visit1 red4 . Su02 visit1 red5 150 Su02 visit1 red6 250 Su03 visit1 red1 . Su03 visit1 red2 . Su03 visit1 red3 . Su03 visit1 red4 . ; run; output should be as below: idno visit lab value Su01 visit1 red1 200 Su01 visit1 red2 10 Su01 visit1 red3 . Su01 visit1 red4 . Su01 visit1 red5 . Su01 visit1 red6 . Su01 visit1 red7 150 Su02 visit1 red1 300 Su02 visit1 red2 45 Su02 visit1 red3 . Su02 visit1 red4 30 Su02 visit1 red1 200 Su02 visit1 red2 10 Su02 visit1 red3 . Su02 visit1 red4 . Su02 visit1 red5 150 Su02 visit1 red6 250 In value variable if the data is . from red1 to redn(lab variable) then I don't want that observations in the output. if the variable value has . and any value(alphabets,dates,numerics)even at once,then I want the output for lab variable for red1 to redn observations for that specific occurrence (red1 to redn) only. Can you kindly let me know how to get this kind of output for huge data with unknown observations.Thank you in advance.
... View more