Have:         UID v1 v2 v3 v4 1 0 0.01 0.1 1 1 1 0.01 . 1 1 10 0.01 . 1 2 0 0.01 1 0 2 1 0.01 . 0 2 10 0.01 . 0           want:         UID v1 v2 v3 v4 1 0 0.01 0.1 1 1 1 0.01 . 1 1 10 0.01 . 1 1 0 0.01 0.1 0 1 1 0.01 . 0 1 10 0.01 . 0 1 0 0.01 0.2 1 1 1 0.01 . 1 1 10 0.01 . 1 1 0 0.01 0.2 0 1 1 0.01 . 0 1 10 0.01 . 0 2 0 0.01 1 0 2 1 0.01 . 0 2 10 0.01 . 0 2 0 0.01 1 1 2 1 0.01 . 1 2 10 0.01 . 1 2 0 0.01 2 0 2 1 0.01 . 0 2 10 0.01 . 0 2 0 0.01 2 1 2 1 0.01 . 1 2 10 0.01 . 1   So. V4 need to be modified for each value of v3 (as you see in the input first 3 observations of ID 1 change from 1 to 0  and then  V3 need to be incremented 10 times its original value per ID. so, v3=0.1,0.2,0.3........1 per ID.   Any help to achieve this in SAS?   Thanks ... View more

Have: id value 1 0 1 1 1 2 2 0 2 0 2 2 2 0 3 0 3 0 3 0 3 0   want:   id  value 1 1 2 2 3 0       I need to select one observation per subject. if the value is 1 then retain that observation. if not 1 then look for value 2 and retain it. if both 1 and 2  are not there then look for 0 and retian it.   I appreciate any help to get the output.   Thanks, ... View more

I have a dataset with 10 observations per subject. I want to create  a copy of the first observation  so that  new datset will contain 11 observations per subject.   Thanks ... View more

Reading numeric variable with commas into SAS 9.4 version. ... View more