I am trying to build a table with PROC Report that summarizes results for the last three years from a dataset containing results from the last 10 years. I am unsure how (if possible) to limit the number of years output.   My current code is given below: proc report data=participating_programs; column sport num_participating_programs,year; define sport / group f=$sport.; define year / across order=internal; define num_participating_programs / analysis sum ''; run; ... View more

I am trying to use CATX() to concatenate lists of character variables of within a dataset, each of which contains a different number of missing variables on the right end. I am getting them concatenated successfully, but all of the lists are ending with , . (the separator and then a dot). I am trying to get rid of this, but can't seem to figure out a way.   Code:   data sport_part_report; set all_schools_sport_t; sports = catx(", ", OF col1-col14); drop school_id _name_ _label_ col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14; run; Output example: BA-M, LA-W, SB-W, .   ... View more

I am trying to write a program that loops over a list of names to create multiple PDFs. It's working fine except that one of the names I need it to loop over contains an apostrophe (single quote). I'd rather not just remove the apostrophe from my data, but can't figure out how to get SAS to ignore it in a string literal. Below is my current code. The problem name occurs as one of the &conf variables that I'm looping over.   *Run report for each conference; %macro runcp; %do i=70 %to &nconfs.; %let conf_name = &&conf&i; %let div_num = &&divs&i; %cpreport; %end; %mend runcp; %runcp; ... View more