Hello! I have data from two site visits per facility, captured as a bunch of binary variables. I need to get one row of data per facility that captures data from both visits so it can be used to show if and how the results changed between visits. For example, if the value for the first observation was 0 and the second was 1, I want the value "NY" (or "01"). I'm trying to concatenate the value and the lag value of the variable, but there may be better solutions.    data example; input id visit_order v1 v2 v3 v4 v5; datalines; 1 1 0 1 0 0 1 1 2 1 0 1 1 0 2 1 0 1 1 0 1 2 2 0 1 0 1 0 3 1 1 1 1 1 0 3 2 1 0 1 1 0 4 1 0 1 0 0 1 4 2 1 0 1 1 0 ; run; data recode_vars; set example; array varlist v1-v5; array charvarlist $ v1_c v2_c v3_c v4_c v5_c; do i=1 to 5; if varlist[i] = 1 then charvarlist[i] = 'Y'; else charvarlist[i] = 'N'; end; run; data summary_data; set recode_vars; by id; array charvarlist v1_c v2_c v3_c v4_c v5_c; if last.id then do i=1 to 5; charvarlist[i] = catx(lag(charvarlist[i]), charvarlist[i]); end; if last.id; run; Thanks for the help! ... View more

Hello! I'm trying to apply formats to all variables in an array. Example: proc format; value correct 1 = 'Correct' 0,2,3 = 'Not Correct' ; run; data example; input id a b c d e; datalines; 1 0 1 1 3 2 2 0 2 1 1 1 3 1 3 2 0 1 4 0 2 2 1 0 5 3 1 0 1 3 ; run; data example; set example; array varlist a--e; do i=1 to dim(varlist); format varlist[i] correct.; end; run; When I run that code, I get the following error message:    Is there a way to apply a format to all variables in an array using similar syntax? I know there are many other solutions to the very simplified example I posted, but the actual program uses several lists of non-consecutive variables that are already stored in arrays, so they are not easily referenced by other means but are already in array format.    Thank you for the help! ... View more

Hello! I have a stacked bar graph created using HBARPARM and am trying to have the segment labels show the percentage, not the count. Is there a way to do that?    My code is:  proc sgplot data = path_resistance; yaxis display = (nolabel) valueattrs = (color=black size=12pt); xaxis grid min=0 label="Number of infections" ; hbarparm category = pathGroup response = resCount / group = pathResistant seglabel; run;       I have a column with the percentages (resPct). The structure of my data is: data path_resistance; infile datalines delimiter = ','; input pathGroup pathResistant resCount resPct; datalines; Pathogen A,No,170,98 Pathogen A,Yes,3,2 Pathogen B,No,100,86 Pathogen B,Yes,6,14 Pathogen C,No,53,65 Pathogen C,Yes,28,35 ; run; Thank you for the help!   ... View more