I have a variable called date that's in the format yymmdd10., and I need to convert it in a numeric value, for example: 2022-04-18 will be converted into 20220418 (or look different, as long as it's a number) as a numeric variable.   I have tried this code but it doesn't work. the output variable n is all empty.   DATA want; SET have; n=input(put(date, yymmdd10.), 8.); put n=; RUN;   appreciate the help!  ... View more

If I group the data I have by name and id, I want to add a new row per group if the first code = last code, the new row need to have the same name and id, and the value of the 'amount' column is N/A, the values for the rest columns can just be the same as one of the rows in the group (can also just be empty, doesn't really matter).   data have; input name : $1. id : 8. code : $8. amount : 8. ; datalines; A 10 12345678 100 A 10 09876543 30 B 9 88997700 20 B 9 88997700 -20 B 9 88997700 40 C 28 11223344 30 C 28 11223344 40 C 28 67676767 50 D 10 78654890 40 D 10 78654890 50 ;   data want; input name : $1. id : 8. code : $8. amount : 8. ; datalines; A 10 12345678 100 A 10 09876543 30 B 9 88997700 20 B 9 88997700 -20 B 9 88997700 40 B 9 88997700 N/A C 28 11223344 30 C 28 11223344 40 C 28 67676767 50 D 10 78654890 40 D 10 78654890 50 D 10 78654890 N/A ; ... View more

data have; input name : $1. id : 8. code : $8. num_1 : 8. num_2 : 8. ; datalines; A 10 12345678 1 0 A 10 09876543 0 1 A 34 23456789 1 1 B 9 88997700 1 0 B 9 88997700 0 0 B 9 88997700 0 1 C 28 11223344 1 1 C 28 34343434 1 0 C 28 67676767 0 0 C 30 78679870 1 0 C 30 78679870 0 1 ;   What I want: A 10 12345678 1 0 A 10 12345678 0 1 A 34 23456789 1 1 B 9 88997700 1 0 B 9 88997700 0 0 B 9 88997700 0 1 C 28 11223344 1 1 C 28 11223344 1 0 C 28 11223344 0 0 C 30 78679870 1 0 C 30 78679870 0 1   ... View more

I want to group by name and ID, and want to delete the entire group of observations whenever both num_1 and num_2 = 1 or both = 0.    What I have: name ID num_1 num_2 A        10     1          0 A        10      0          1 A        34     1          1 B        9      1          0 B        9      0          0 B        9      0          1 C        28      1          1 C        28      1          0 C        28      0          0 C        30      1          0 C        30      0          1   What I want: name ID num_1 num_2 A        10     1          0 A        10      0          1 C        30      1          0 C        30      0          1 ... View more