@Cynthia_sas,   Thank you very much. You understand my question right but I want to investigate one more thing, I guess I skipped to tell. My "Variables" macro varible can include different values such as -> %Let Variables=Variable1 Column2 Variable3 Column4 Variable5; If I get foregoing macro variable, the following code cannot add "P" values at the beginning of  "Column2" and "Column4" values.   I mean that the values of macro variable can change, so can you help me to resolve this step, please?   %Let Variables=Variable1 Column Variable3 Column Variable5; /* */ %Let VariablesP=%Sysfunc(TranWrd(&Variables,Variable,PVariable)); %Put PVar is &VariablesP; Thank you ... View more

Thank you very much @RW9 for trying to help me.   I just didn't  exactly understand your response.   I need macro variable because I will use in my future steps in my project. I just want to get this values being a macro variable. I could not understand your  sample exacty, it brings an error because I did not have "Have" Data set. If I create this variable in data set I cannot use without its data set. I need a macro variable because I want to use everywhere what I want without depending on any data set.   Is it possible to get these values into Macro Variable? ->PVariable1 PVariable2 PVariable3 PVariable4 PVariable5   Thank you     ... View more

Thank you very much @ballardw,   You are right, I told myself incorrect. I want to get "VariablesP" variable as a Macro variable.   I mean that &VariablesP should include ->PVariable1 PVariable2 PVariable3 PVariable4 PVariable5   Is it possible to do?   Thank you and sorry for missunderstanding. ... View more

Okay, I will consider it Xia, thank you 🙂 ... View more

Thank you very much both @Ksharp and @Reeza 🙂 ... View more

@Reeza,   1-There aren't any error in my log. How can I fix my format? 2-Yes, it does.   Can you tell me that how can I write my format correct? ... View more

@Reeza,Sometimes like this?   PROC FORMAT; Value $Bucket 0.0-0.2="0.0-0.2" 0.2-0.4="0.2-0.4" 0.4-0.6="0.4-0.6" 0.6-0.8="0.6-0.8" 0.8-1.0="0.8-1.0"; Run; Proc Tabulate Data=Have; Var Predicted; Class Bucket / PreLoadFmt; Class Target; ClassLev Target; ClassLev Bucket; Format Bucket $Bucket.; Table Bucket , Predicted*Mean Target*(N ColPctN) N ColPctN /Printmiss MissText='"-"'; Run; ... View more

@Ksharp,   Thank you very much for trying to help me.   But instead of "0.0-0.2" what the range of "0.2-0.4" was empty, For example, If I change my sample as below, so I need to change your code as below too.   Instead of this method, Can PreLoadFmt format is more efficent than this?     Data Have; Length Target 8 Predicted 8 Bucket $ 30; Infile Datalines Missover; Input Target Predicted Bucket; Datalines; 0 0.1 0.0-0.2 0 0.3 0.0-0.2 0 0.7 0.4-0.6 0 0.5 0.0-0.2 0 0.9 0.8-1.0 1 0.1 0.0-0.2 1 0.3 0.0-0.2 1 0.7 0.4-0.6 1 0.5 0.0-0.2 1 0.9 0.8-1.0 0 0.1 0.0-0.2 0 0.3 0.0-0.2 0 0.7 0.4-0.6 0 0.5 0.0-0.2 0 0.9 0.8-1.0 1 0.1 0.0-0.2 1 0.3 0.0-0.2 1 0.7 0.4-0.6 1 0.5 0.0-0.2 1 0.9 0.8-1.0 ; Run; Proc sql; create table classdata as select * from (select distinct Bucket from have union select '0.0-0.2' from have(obs=1) union select '0.2-0.4' from have(obs=1) union select '0.4-0.6' from have(obs=1) union select '0.6-0.8' from have(obs=1) union select '0.8-1.0' from have(obs=1)), (select distinct Predicted from have), (select distinct Target from have); Quit; Proc Tabulate Data=Have classdata=classdata; Var Predicted; Class Bucket; Class Target; Classlev Target; Classlev Bucket; Table Bucket , Predicted*Mean Target*(N ColPctN) N ColPctN / misstext='"-"'; Run; ... View more

@Reeza,   Thank you very much for trying to help me.   I tried to benefit from following link, but I couldn't succeed, it seems little bit complicated, can you help me to resolve this issue, please?   http://support.sas.com/resources/papers/proceedings11/239-2011.pdf    PROC FORMAT; Value Bucket 0.0-0.2="0.0-0.2" 0.2-0.4="0.2-0.4" 0.4-0.6="0.4-0.6" 0.6-0.8="0.6-0.8" 0.8-1.0="0.8-1.0"; Run; Proc Tabulate Data=Have; Var Predicted; Class Bucket / PreLoadFmt; Class Target; ClassLev Target; ClassLev Bucket; /* Format Bucket.;*/ Table Bucket , Predicted*Mean Target*(N ColPctN) N ColPctN /Printmiss; Run; Thank you ... View more

Hello @Cynthia_sas,   Thank you very much for your detailed answers 🙂 ... View more

@Cynthia_sas,   Sorry for tired you out, the following code meets my desired output.   I investigated your previous code more deeply and I resolved the my desired output. The output seems proper, what do ypu think, can I use this code for my aim?   Proc Report Data=Have Out=Want2 Nowd; title " "; Column Target Dataset ,(Color Value) ; Define Target / Group Style(Column)=Header; Define Color / Group Noprint ; Define Dataset / Across ; Define Value / Analysis ; Compute Value; Length SVar3 SVar5 SVar7 $100; SVar3 = Catt('style={background=',_c2_,'}'); Call Define ('_c3_','style',SVar3); SVar5 = catt('style={background=',_c4_,'}'); Call Define ('_c5_','style',SVar5); SVar7 = catt('style={background=',_c6_,'}'); Call Define ('_c7_','style',SVar7); EndComp; Run; title; Thank you ... View more

Hi,   So I need to use @Ksharp's method to achieve my aim as below,   Data Have; Length Target 8 Numeric1 8 Numeric2 8 Numeric3 8 WOE1 8 WOE2 8 WOE3 8; Infile Datalines Missover; Input Target Numeric1 Numeric2 Numeric3 WOE1 WOE2 WOE3; Datalines; 0 0.2 0.4 0.1 0.0 0.1 0.3 1 0.3 0.5 0.2 0.2 0.4 0.7 0 0.4 0.8 0.9 0.1 0.9 0.3 1 0.6 0.9 0.0 0.2 0.2 0.6 1 0.2 0.1 0.4 0.3 0.5 0.3 0 0.3 0.1 0.3 0.2 0.1 0.2 1 0.7 0.1 0.1 0.4 0.7 0.9 1 0.1 0.8 0.3 0.3 0.3 0.5 ; Run; Ods Select SpearmanCorr; Ods Output SpearmanCorr=Spr; Proc Corr Spearman Data=Have; Var Numeric1 Numeric2 Numeric3 ; Run; data want(drop=PNumeric1 PNumeric2 PNumeric3); set spr; output; Numeric1=PNumeric1; Numeric2=PNumeric2; Numeric3=PNumeric3; output; run; %let dsid=%sysfunc(open(have)); %let nobs=%sysfunc(attrn(&dsid,nlobs)); %let dsid=%sysfunc(close(&dsid)); Ods Tagsets.ExcelXP file="/folders/myfolders/Spearman.xml" style=htmlblue options(zoom="80" embedded_titles='yes' sheet_interval='none' sheet_name="Spearman"); ods escapechar='~'; options missing=' '; proc report data=want nowd spanrows; column ("Spearman Correlation Coefficients, N = &nobs ~n Prob > |r| under H0: Rho=0" Variable Numeric1 Numeric2 Numeric3); define Variable/order ' ' style={vjust=c fontweight=bold}; run; Ods Tagsets.ExcelXP Close; As far as I understand there is no option for my question   Thank you ... View more

I'm little bit confuses, I tried to do by using your method but your method can be advance for me, I'm not sure.   I just want to see following image, but I didn't handle it 😞   Proc Report Data=Have Nowd; title " "; Column Target Color Dataset ,(Value/*,(Color)*/) ; Define Target / Group ; Define Color / Group Noprint ; /*Define N / " " Group ;*/ Define Dataset / Across ; Define Value / Analysis /*Across*/; Compute Value; Length SVar3 SVar5 SVar7 $100; SVar3 = Catt('style={background=',_c2_,'}'); Call Define ('_c3_','style',SVar3); SVar5 = catt('style={background=',_c4_,'}'); Call Define ('_c5_','style',SVar5); SVar7 = catt('style={background=',_c6_,'}'); Call Define ('_c7_','style',SVar7); EndComp; Run; title; ... View more