Do you like to have you own choice?  Yes=programmer Do you like following orders? Yes = Admin Do you like to experiment?  Yes = programmer Do you like to be called in the middle of the night? Yes = Admin.   The list goes on and on. Are you looking for freedom, or Constance   ... View more

there is no way to let you know the code that statement is unrealistic, others can assist you with issues in your code and can assist in helping you find the correct tool to use, but you have to also assist with replies and confirmations.   Are you asking the community to do your work or to assist you. Assistance is provided with you input and examples of code and data that you are working with. What have you tried the code that has been provided?  Did you try @Kurt_Bremser example?  If you did show those results.   God helps those who help themselves. Managers give work to their employees based on the employees skill abilities they were hired for, did you hire into a position that is above your skill set?.     ... View more

    data have; infile cards flowover dlm=' '; input ID $ group disease @@; cards; 1 1 2 2 1 1 3 1 2 4 0 3 5 1 3 6 1 2 7 0 3 8 1 3 9 0 1 10 0 2 11 1 1 12 0 2 13 1 2 14 1 1 15 0 1 16 1 3 17 0 1 18 0 3 19 0 3 20 0 2 21 0 1 22 1 3 23 1 3 24 1 2 25 1 3 26 0 3 27 0 3 28 1 2 29 1 2 30 0 2 31 0 1 32 1 1 33 0 2 34 0 1 35 1 1 36 1 3 37 1 1 38 1 3 39 0 2 40 0 3 41 1 3 42 0 3 43 0 1 44 1 2 45 1 1 46 1 2 47 0 3 48 0 2 49 1 3 50 1 3 51 0 1 52 1 2 53 0 1 54 1 3 55 0 3 56 0 3 57 0 2 58 1 2 59 1 2 60 0 1 61 0 1 62 1 1 63 1 3 64 0 1 65 1 2 66 0 2 67 0 1 68 1 1 69 1 2 70 1 2 71 0 2 72 0 2 73 0 1 74 0 3 75 0 3 76 1 2 77 1 2 78 0 2 79 1 3 80 1 3 81 1 1 82 0 2 83 0 1 84 1 3 85 0 1 86 0 3 87 1 3 88 0 2 89 1 1 90 0 1 ;   The SAS System Obs ID group disease 1 1 1 2 2 2 1 1 3 3 1 2 4 4 0 3 5 5 1 3 6 6 1 2 7 7 0 3 8 8 1 3 9 9 0 1 10 10 0 2 11 11 1 1 12 12 0 2 13 13 1 2 14 14 1 1 15 15 0 1 16 16 1 3 17 17 0 1 18 18 0 3 19 19 0 3 20 20 0 2 21 21 0 1 22 22 1 3 23 23 1 3 24 24 1 2 25 25 1 3 26 26 0 3 27 27 0 3 28 28 1 2 29 29 1 2 30 30 0 2 31 31 0 1 32 32 1 1 33 33 0 2 34 34 0 1 35 35 1 1 36 36 1 3 37 37 1 1 38 38 1 3 39 39 0 2 40 40 0 3 41 41 1 3 42 42 0 3 43 43 0 1 44 44 1 2 45 45 1 1 46 46 1 2 47 47 0 3 48 48 0 2 49 49 1 3 50 50 1 3 51 51 0 1 52 52 1 2 53 53 0 1 54 54 1 3 55 55 0 3 56 56 0 3 57 57 0 2 58 58 1 2 59 59 1 2 60 60 0 1 61 61 0 1 62 62 1 1 63 63 1 3 64 64 0 1 65 65 1 2 66 66 0 2 67 67 0 1 68 68 1 1 69 69 1 2 70 70 1 2 71 71 0 2 72 72 0 2 73 73 0 1 74 74 0 3 75 75 0 3 76 76 1 2 77 77 1 2 78 78 0 2 79 79 1 3 80 80 1 3 81 81 1 1 82 82 0 2 83 83 0 1 84 84 1 3 85 85 0 1 86 86 0 3 87 87 1 3 88 88 0 2 89 89 1 1 90 90 0 1   ... View more

  data have; infile cards missover dlm=' '; input Date $ Car Client $; cards; 01/01/18 1 Ente 01/02/18 1 Patterson 01/02/18 1 Jeter 01/02/18 2 Davidson 01/03/18 1 Steve 01/03/18 1 Gonzalez 01/03/18 2 York 01/03/18 2 Camara 01/03/18 2 Camara 01/04/18 1 Waters 01/04/18 1 Ventre 01/04/18 2 Perez 01/04/18 3 Rodriguez 01/04/18 3 Jeter 01/04/18 3 Jiminez ; proc freq data=have ; tables date*car / out=want; run; proc sql; create table want2 as select date, count(date) as TotalCount from have group by date; quit; proc sort data=want; by date car; run; data want3; merge want2 want; by date; run; proc transpose data=want3(drop=percent) out=want4(drop=_name_ _label_) prefix=Count_car ; id car; by date totalcount; run; ... View more

  If your datalines where like this data test; input id age sex $; cards; 1 25 M 2 35 F 3 29 F 4 37 M 5 32 M ; run; there would be no difference in you code. or if you fixed the testing to evaluate only the first char for sex then there would be no difference.     ... View more

did you post data for testing and debugging? Did you test your code yourself?   I and others would test for you if you included data. ... View more