Hi, How do I calculate confidence intervals for sensitivity/specificity for correlated data?  My original plan was as follows: my response variable is binary and I have multiple data points per person, which is why I want to use GEE (proc genmod) to calculated the predicted probabilities, use proc logistic and the ctable option to get the classification table and then use proc freq with the option senspec to get the CI for sensitivity/specificity.  I have read this post (https://support.sas.com/kb/24/170.html) that helped me understand how to get CIs using proc freq.  HOWEVER, I'm worried that proc freq will not take into consideration the correlated nature of my data which will have a direct impact on my confidence intervals.  My point estimates will remain the same whether I assume independence or correlated data, but it's the confidence intervals that will be different. I also saw this old 2016 posting https://communities.sas.com/t5/Statistical-Procedures/Sensitivity-and-Specificity-Confidence-Intervals-for-repeated/td-p/268017 where someone had the same question as me, but no resolution.  I'm wondering if there has been any developments since then? I'm using SAS v9.4. Is there a macro that I can use to calculate confidence intervals for sensitivity/specificity for correlated data? Thank you in advance.   ... View more

Hi, I've looked extensively at this forum for how to convert (calendar) years into fiscal year format, but I'm having problems with the formatting and data manipulation of the fiscal years.   In my code I can use the year function to get years, but this is calendar years:  format calendar_year Best12.;  calendar_year=compress(year(date));   I then create a new variable called "combine" that just has the calendar_year with a "check" text: format combine $20. combine = compress(calendar_year||"check");   The result is what I want: "2019check" Note that I see the year displayed correctly.   However, when I try to convert my code into fiscal year, using what I learned from this forum, I don't get what I want.   I do the following: format fiscal_year year. ; fiscal_year = intnx('YEAR.4',date,0);   If I proc print fiscal_year, it displays correct e.g., 2019.   Then I try to create the combine2 variable as follows: format combine2 $20.; combine2 = compress(fiscal_year||"wrong");   My result is the SAS date format as follows: 1524wrong. I would like it to display as 2019wrong.   What am I doing wrong?   Thanks in advance. ... View more

Hi, I am having problems creating a new SAS dataset.  Here is my code:   data cars6; infile DATALINES DLM="," ; input category $ category_desc $ ; CARDS; A00,This group will go inside Y83,This group will go to the outside yard and have a snack at lunch ; run; PROC PRINT DATA=cars6(OBS=5); RUN; proc contents data = cars6;run;   I want the output to be two columns, exactly how I entered the data.  However, when proc contents has set both variables set to length 8.  So my variables are being truncated.   I'm feeling frustrated because I already put in a deliminater of a comma.    What am I doing wrong?   Thanks. ... View more