I'm calculating CV and RMSE for several variables and would like to output the PROC GLM results to a SAS table. Is there a way to do this?   *Create sample data with repeat measures; data have ( keep = subjectid weight momwtgain cigsperday ); format subjectid; set sashelp.bweight; if _N_ <= 6; subjectid = _N_; if _N_ = 2 then subjectid = 1; if _N_ in ( 3, 4 ) then subjectid = 2; if _N_ in ( 5, 6 ) then subjectid = 3; if _N_ = 1 then cigsperday = 1; run; *Calculate CV and RMSE; %macro cv ( covar ); proc glm data = have; model &covar. = subjectid; ods select FitStatistics; run; quit; %mend cv; %cv ( weight ); %cv ( momwtgain ); %cv ( cigsperday ); *Would like a table that looks something like this; data want; length Name $20.; input Name $ CV RMSE; cards; Weight 23.43 851.41 MomWtGain -141.24 9.89 CigsPerDay 229.13 0.38 ; run; ... View more

Is there a way to prevent my variables names from being truncated to 20 characters in the output?   data have; set sashelp.bweight; rename momwtgain = dont_truncate_this_var; run; proc glmselect data = have; model weight = momage cigsperday dont_truncate_this_var; run; quit; My actual GLMSELECT statement uses stepwise selection and a CLASS statement, so I'd prefer to stick with GLMSELECT if possible.   ... View more

I have a variable that has a first name and last name embedded in it. How can I extract the name into a new variable, assuming it always comes after "Requestor: " and before "Reason:"?   data have; length note $200.; input note $ ; cards; This_is_the_Requestor:_Mary_L._Santiago_Reason: Additional_text_This_is_the_Requestor:_John_Doe_Reason:_stuff This_is_the_Requestor:_Tyler_Nguyen_Reason:_text_text ; run; data have; set have; note = tranwrd ( note, "_", " " ); run; ... View more

My apologies if this has already been answered on here and I didn't see it, but I have two tables that I'd like to do a many-to-many merge on.   data one; input id $ color $ animal $ farm $; datalines; a blue . . a black . . d green . . ; run; data two; input id $ animal $; datalines; a turtle a snake b cat b cow c bird c horse ; run; data want; input id $ color $ animal $ farm $; datalines; a blue turtle . a blue snake . a black turtle . a black snake . b . cat . b . cow . c . bird . c . horse . d green . . ; run;   I've tried the following, but it doesn't yield the same results as the "want" table. proc sql; create table both as select * from one as a full join two as b on a.id = b.id; quit; Any suggestions would be greatly appreciated. ... View more

I'm trying to identify which of my variables are perfectly correlated so that I can remove one of them in order to run a principal component analysis. The large number of variables in my dataset makes it hard to find based on visual inspection alone, so is there an easier way for me to identify those pairs?   proc corr data = sashelp.applianc out = have; var units_:; run; ... View more

I'm running a variable fit_msr_shldr_wst_sml_b_r_f through PROC MEANS and want it to output the 25th and 75th percentiles as fit_msr_shldr_wst_sml_b_r_f_p25 (31 chars) and fit_msr_shldr_wst_sml_b_r_f_p75. Why is the name being truncated and coming out as fit_msr_shldr_wst_sml_b_r__p25 (30 chars)? I know it's not an ideal variable name, but any help would be appreciated.     data have; input fit_msr_shldr_wst_sml_b_r_f; cards; 4 9 9 8 2 4 ; run; proc means data=have nway noprint; var fit_msr_shldr_wst_sml_b_r_f; output out=temp0 P25= P75= / autoname; run;     ... View more