Hi everyone, I have a dataset that roughly looks like the one below. data have;
infile cards delimiter='|';
input X1 $ V1 $ V2 $ V3 $;
cards;
|a1| |a1 |
||c2,a1| c3,c2 |
||b2| |
te || | |
;
run; Now I want to create a new column miss that indicates whether or not a row had any observation in V1, V2, or V3. Row 1, 2 and 3 all have values in either V1, V2, V3 or some combination, so miss would here be 1. Row 4 has no values in V1-V3, so miss would be 0. Important is that the solution is dynamic, since the dataset grows on a frequent basis. I think an additional issue for my data is that i'm not sure these empty spaces are actually flagged as missing? How would I go about checking that? i've tried some of the missing functions in SAS, but i find them so unintuitive that I might as well just be doing it wrong and getting confusing results. Thanks a bunch.
... View more