Hi  I'm new to SAS programming, I want to count the total number of people in each year without double counting and using these conditions. This is the dataset          For each patient I want to know ,if they got a vaccine (i.e. there is no missing value for the "total number of vaccines" column. If the answer is "yes" to having a vaccine (that is for the patient , the "total of vaccine" column is not empty). Then do   1. Did you complete the vaccine (i.e. completed =1), if yes I want to count in the first year we see the patient ID. For example, customer ID K001, I will only count you once, that is  as a part of Year 2018 and not count in the any year you might appear. For example patient with ID K001 will only be counted in 2018 and not 2019 or any other year. and K003 will be counted in Year 2020 and NOT 2021 or any other year   2. if No to completion of vaccination (that is completed=0), I can you count you also in the first year you appeared in the dataset and can NOT for any other year. So, for example patient with ID K004 will be counted in year 2017. I want to do this for each patient.   This is what I want .In 2017, we had a total of 2 patients because K004 and K007 are the only ones in that year. Year 2018, has a total of 2 people because K001 first year of vaccine 2018 so I counted it just once (and never in 2019) and patient with ID K005 are that year group.     Thank you. Please let know if you have questions     ... View more

Hi, I'm new to sas and want to make confidence for braplots ( bounding at 0-100%) . I have dataset with three variables and they are all categorical. This is how the data looks like.    Area_of_interst , Meds, Response, "Internal Med", "asprin", "yes", "Internal Med", "vitamins","no", "Internal Med", "folic acid","yes", "Emergency Med", "asprin", "yes", "Emergency Med", "vitamins","no", "Emergency Med", "folic acid","yes",  This is the SAS code I have . Please help me proc sgplot data = out2; vbar meds / response = RowPercent group=area_of_interest groupdisplay=cluster ; where response = "yes"; run;   ... View more