I tried to calculate age using the  current_age=int(yrdif(b_date, today(), 'ACTUAL')); Since the age is before 1960 for bene_id 02, It is giving me negative value. Here is my data after calculating age:   bene_id    b_date           Current_age 01             18May64        54 02             18Jun22         -3 03              08sep51        67   Any help appreciated!     ... View more

My data looks like below without the flag, I want to create a flag that has the value of 1 when B> A (0 when reverse is true)and it should be missing when either A or B has a missing value.   A       B Flag .        65 . .       12 . 626   5 0 20    . . .        23 . 10 25 1   I have tried this; data X; set Y; if (A ne .) or (B ne .) and B >A then flag=1; else flag=0; run;   and didn't work.    Please help!   ... View more

My data is like: ID class ACDC 1 ABCD 2 ADCB . ACBD . ACCD 2 ABBB 2 AAAB 1 ACDA 2   Proc freq give me output like: Class Frequency Percent Cumulative Frequency Cumulative Percent 1 2 33.33% 2 33.33% 2 4 66.67% 6 100.00% Frequency missing=2       I need output(percent based on entire N of the dataset): Class Frequency Percent 1 2 25.00% 2 4 50.00% . 2 25.00% Total   100.00%   Please help-thanks in advance! ... View more

My data is  A   B  C  1   0  1 0  0   0 1  1   0 0  0   1 1  1   1   What to create a flag variable which is missing when A or B or C have 1 and flag variable should be . when all three of them have 0   WANT dataset like A   B  C nmiss 1   0  1    . 0  0   0   1 1  1   0    . 0  0   1    . 1  1   1    .   Any quick way to do this? ... View more