Hello. I have the following dataset Group_Category Group Total Female Male Hispanic NotHispanic   Group A GroupA_1 32 16 16 2 30   Group A GroupA_2 30 14 16 5 25   Group A GroupA_3 10 6 4 6 4   Group B GroupB_1 10 9 1 1 9   Group B GroupB_2 44 20 24 4 40   Group B GroupB_3 60 20 40 5 55     What I would like to do is modify the variable names for all the groups. Something like this to be outputted eventually to csv or excel and merging Group A and B for their corresponding columns _1, _2, _3.  Category_1 Category_2 Group A     Group B         GroupA_1 GroupA_2 GroupA_3 GroupB_1 GroupB_2 GroupB_3 Total   32 30 10 10 44 60 Gender Female 16 14 6 9 20 20 Gender Male 16 16 4 1 24 40 Ethnicity Hispanic or Latino 2 5 6 1 4 5 Ethnicity Not Hispanic or Latino 30 25 4 9 40 55 i have been having no luck thus far. All I could this is to insert a row in the dataset for each group and then rename the original variable name     ... View more

I would like to average all values ONLY if all values are filled out. 0 doesn't mean missing. if the values are not filled out, then they should be blank ID value1 value2 value3 value4 1 8 2 2 6 2 5   0 10 3 3 4 3 6 3 6 2 0 6   Want ID value1 value2 value3 value4 average_values 1 8 2 2 6 4.5 2 5   0 10   3 3 4 3 6 4 3 6 2 0 6 3.5   This is what i have so far data test; set raw; average_values = MEAN(value1, value2, value3, value4); run;   it still calculates all average  ... View more

I have 2 datasets - one demo (1 row per ID) and one specific event (multiple row per ID). What I would like to do is merge these two tables but have yes_no from the specific event table for one that matches. If there are two or more event in specific table, it should show 1 and 0 for the Ids that don't match   demo ID male race Location 1 1 White US 2 0 Asian Japan 3 1 Unknown Spain 4 1 Unknown Japan event ID date term grade 1 1/2/2010 Fever 1 1 4/2/2020 Rash 2 2 1/2/2010 Fever 1 4 4/1/2011 Cold 1   want: ID male race Location event_yes 1 1 White US 1 2 0 Asian Japan 1 3 1 Unknown Spain 0 4 1 Unknown Japan 1   I tried: proc sql; select a.*, count(b.ID) as yes_no from demo a left join event b on a.ID = b.ID;   quit;   it works but it shows me sum of all events per ID ... View more

I have the following dataset, I would like to convert date and time that are currently in the CHAR format to date and time respectively, and datetime   have: RecordID Date Time 1 12/14/2020 1214 2 11/19/2019 900 3 1/11/2021 815 4 1/8/2021 1314   want: RecordID Date Time date_new time_new date_time_new 1 12/14/2020 1214 12/14/2020 12:14 12/14/2020 12:14 2 11/19/2019 900 11/19/2019 9:00 11/19/2019 9:00 3 1/11/2021 815 1/11/2021 8:15 1/11/2021 8:15 4 1/8/2021 1314 1/8/2021 13:14 1/8/2021 13:14   I tried the following: data want; set have; format Date_newmmddyy10. Time_new time10.  date_time_new datetime.;   Date_new= input(Date,yymmdd10.); Time_new= input(substr(Time, 12, 10), time10.); Date_time_new = DHMS (Date_new, 0, 0, time_new);  run;   Date_new works but not the time_new or date_time_new ... View more

Hello. I am trying to created a stacked bar chart by record ID and year. I would like the x-axis to be 'rate' and inside each stacked bar chart, I would like to have data labels as 'enrolled'   Here is the dataset: recordID year enrolled rate 1 2018 8 31.81818 1 2019 13 54.54545 1 2020 16 68.18182 2 2019 9 36.36364 2 2020 12 50 3 2018 25 54.7619 3 2019 75 90 3 2020 95 100 4 2019 2 4.545455     my attempt thus far:   data test; infile datalines missover; input recordID year enrolled rate; datalines; 1 2018 8 31.81818 1 2019 13 54.54545 1 2020 16 68.18182 2 2019 9 36.36364 2 2020 12 50 3 2018 25 54.7619 3 2019 75 90 3 2020 95 100 4 2019 2 4.545455 ;run; proc sgplot data=test pctlevel=graph; hbar recordID / response=rate stat=percent group=year groupdisplay=stack datalabel; keylegend /title="Location" position=bottom; quit;   Not able to get what I need   This is what I would like (attached)       ... View more

Hello I have the following dataset ID followup age meddrugs gender score 1 3 25 ABC male 1 1 6 25 ABC male 2 2 3 31 GHI female 1 2 6 31 ABC female 2 2 12 31 DEF female 1 3 6 45 ABC female 2 3 12 45 GHI female 1   I would like to transpose ALL to wide by ID and follow up to something like this: ID age_3 age_6 age_12 meddrugs_3 meddrugs_6 meddrugs_12 gender_3 gender_6 gender_12 score_3 score_6 score_12 1 25 25   ABC ABC   male male   1 2   2 31 31 31 GHI ABC DEF female female female 1 2 1 3   45 45   ABC GHI   female female   2 1   I did this following: proc sort data = test; by ID followup;run;   proc transpose data = test out = transpose; by ID; id followup; var age meddrugs gender score;   run;   not getting what i want 😞 ... View more