Yes. You can. Just list all these variable in sub-query of PROC SQL.   proc sql; create table want as select id,South ,North ,East,West, (select mean(South) from ( select South from have union all select North from have union all select East from have union all select West from have )) as mean , (select std(South) from ( select South from have union all select North from have union all select East from have union all select West from have )) as std from have; quit; ... View more

Data ds; infile datalines; input name $40.; call scan(name,1,p1,l1,' '); call scan(name,-1,p2,l2,' '); first=scan(name,1,' '); middle=substrn(name,p1+l1,p2-p1-l1); last=scan(name,-1,' '); drop p1 p2 l1 l2; datalines; Virat Kohli Surya Kumar Yadav Rohit Sharma Dhoni Chetandra Pratap Singh Chauhan ; run; ... View more

You could drop these variables firstly, after that adding these variables in this table . Here is an example:   data have; set sashelp.class; run; proc sql; alter table have drop name,age add name char(20),age num; quit; ... View more

data have; input id South North east west ; cards; 1 2 4 12 9 2 3 . 11 10 3 2 4 12 10 4 6 4 13 12 ; proc sql; create table want as select id,South ,North , (select mean(South) from (select South from have union all select North from have)) as mean_south_north , (select std(South) from (select South from have union all select North from have)) as SD_south_north, east,west, (select mean(east) from (select east from have union all select west from have)) as mean_east_west , (select std(east) from (select east from have union all select west from have)) as SD_east_west from have; quit; ... View more

Check @Rick_SAS blogs: https://blogs.sas.com/content/iml/2024/03/27/likelihood-ratio-test.html ... View more

Check @Rick_SAS blogs: https://blogs.sas.com/content/iml/2018/10/10/fit-growth-curve-sas.html ... View more

Sorry. I have no idea about it. If you want symmetric CI, you could try option " fisher(BIASADJ= no) ". But that is still not get exact symmetric CI. proc reg data=sashelp.heart(obs=100) ; weight ageatstart; model weight= height Diastolic Systolic; output out=want predicted=p; quit; ods output FisherPearsonCorr=FisherPearsonCorr; proc corr data=want outp=outp fisher(BIASADJ= no); var weight; with p; weight ageatstart; run; data FisherPearsonCorr; set FisherPearsonCorr; RSquare=Corr**2; lcl_rsquare=lcl**2; ucl_rsquare=ucl**2; _lcl2=lcl_rsquare-RSquare; _ucl2=ucl_rsquare-RSquare; run; proc print noobs;run;   Or you could try Bootstrap Method to get RSquare CI. Maybe @Rick_SAS @StatDave knew something you want. ... View more

Yeah. That is what supposed to do. Did you try @DanH_sas code ? ... View more

Did you try LSMESTIMATE ,not ESTIMATE ? ... View more

If I was right, you are unable to use option "displaystats=" when you have option "group=", Check its DOC. And you could try add SEX into PANELBY statement. proc sgpanel; PANELBY yearsincetx_grp sex/layout=lattice; ... View more

"call symputx(cats('_',d),_n_+1);" Here I make four macro variables from dataset 'Sheet2'; Macro_Var_Name Macro_Var_Value _AAA 2 _910 3 _123 4 234 5 You see 2,3,4,5 correspond to the row number of D column in Sheet2. " urlstring= cats("#Sheet2!D",symget(cats('_',a)));" Function cats('_',a) make a string like : '_123' , '_234' , '_AAA' from Sheet1. Function symget('_AAA') means get the value of macro variable _AAA , same as '_123' , '_234' . So when a='AAA' in Sheet1, I could get macro variable _AAA 's value 2. And urlstring= "#Sheet2!D2". And I make a URL on the cell (a='AAA' in Sheet1) by "call define(_col_,'URL','#Sheet2!D2');" which redirect to Sheet2 's D2 cell. ... View more

Yes. Try read its DOC in support.sas.com ... View more

Check @Rick_SAS blog: https://blogs.sas.com/content/iml/2020/04/01/estimate-doubling-time-exponential-growth.html ... View more

Yes. You are right. The following code is more simple than the post of mine above (GROUPLC= option make me to complcate the code).   data temp; input x grp $ s1 s2 s3; cards; 1 A 1 1 1 2 A 2 3 4 3 A 1 2 3 1 B 1.2 1.2 1.2 2 B 2.2 3.2 4.2 3 B 1.2 2.2 3.2 ; run; ods graphics/attrpriority=none; proc sgplot data=temp nocycleattrs; series x=x y=s1 /markers group=grp lineattrs=(color=green) markerattrs=(symbol=plus); series x=x y=s2 /markers group=grp lineattrs=(color=red) markerattrs=(symbol=circle); series x=x y=s3 /markers group=grp lineattrs=(color=blue) markerattrs=(symbol=X); run;   ... View more