Thank your very much @Ksharp,   Okay, I'm going to open a new discussio @Reeza   Thank you ... View more

  Thank you very much   According to my question, what if my Have data set was as below;   Data Have; Length Variable $ 32 Dataset $ 32 Suffix $ 10 Value 8; Infile Datalines Missover; Input Variable Dataset Suffix Value; Datalines; Variable1 Dataset1 Suffix1 0.70 Variable2 Dataset1 Suffix1 0.40 Variable3 Dataset1 Suffix1 0.80 Variable1 Dataset2 Suffix2 0.45 Variable2 Dataset2 Suffix2 0.65 Variable3 Dataset2 Suffix2 0.35 ; Run; Proc Sort Data=Have; By Variable; Run; Proc Transpose Data=Have Out=Want(Drop=_:); By Variable; ID Suffix; Var Value; Run; /*Data Want2;*/ /*Set Want;*/ /*Suf1vsSuf2=((Suf1-Suf2)/Suf2);*/ /*Suf1vsSuf3=((Suf3-Suf1)/Suf1);*/ /*Suf2vsSuf3=((Suf3-Suf2)/Suf2);*/ /*Run;*/ Proc Sql; Create Table Want2 As Select * ,((Suf1-Suf2)/Suf2) As Suf1vsSuf2 ,((Suf3-Suf1)/Suf1) As Suf1vsSuf3 ,((Suf3-Suf2)/Suf2) As Suf2vsSuf3 From Want; Quit; Proc Report Data=Want2 Nowd; Column Variable Suf1 Suf2 Suf3 Suf1vsSuf2 Suf1vsSuf3 Suf2vsSuf3; Define Variable / Display; Define Suf1 / Display; Define Suf2 / Display; Define Suf3 / Display; Define Suf1vsSuf2 / Display; Define Suf1vsSuf3 / Display; Define Suf2vsSuf3 / Display; Run; I do not want to get errors, I want to build a dynamic structure, how can I prevent these errors?   For me Have data set is uncertain, it can change.   Have data set can include Suffix1 and Suffix2 or Suffix2 and Suffix3 or Suffix1 and Suffix or can include none of them. I need to build this structure depending on posibility of changes Have data set.   Can anybody help me, please? I need some direction and guidance 🙂   Thank you ... View more

Thank you very much,   I think the best thing which I do, as below;   Proc Sort Data=Have; By Variable; Run; Proc Transpose Data=Have Out=Want(Drop=_:); By Variable; ID Suffix; Var Value; Run; Thank you ... View more

Thank you very much @Cynthia_sas. I will consider your suggestions 🙂 ... View more

Thank you for your sensitivity and attention ... View more

Thank you very much @Ksharp, you helped me so much. After I change my code as below, it worked . What do you think? Does it seem dynamic and proper? I think I won't face any errors in future, If I use this code?   Ods Escapechar='~'; Options Missing=' '; Proc Report Data=Spr2_&Suffix. Nowd SpanRows Style(Column)=[BorderColor=Black BorderWidth=1px] Style(Header)=Header [BorderColor=Black BorderWidth=1px]; Column ("Spearman Correlation Coefficients, N = &Nobs ~n Prob > |r| under H0: Rho=0" Variable &ModelVar. Dummy); Define Variable /Order ' ' Style(Column)=Header{VJust=C FontWeight=Bold Color=#112277} ; %MakeDefine; Define Dummy / Computed NoPrint; Compute Dummy; N+1; If Mod(N,2)=1 Then Do; %If &Count. GT 0 %Then %Do; %Do j = 1 %to &Count.; %Let Var&j = %Scan(&ModelVar.,&j,%str( )); %Put Var&j= &&Var&j; Call Define("&&Var&j","Style","Style={BackGround=CorrSec.}"); %End; %End; End; Else Do; %If &Count. GT 0 %Then %Do; %Do j = 1 %to &Count.; %Let Var&j = %Scan(&ModelVar.,&j,%str( )); %Put Var&j= &&Var&j; Call Define("&&Var&j","Format","PValue."); %End; %End; End; EndComp; Run; Thank you ... View more

Hello @Ksharp and @Cynthia_sas,   I'm so close to complete my task, however, because of my code's structure the "N+1" statement probably multiplexing.For this reason the image of my result comes little bit strange. %Macro MakeDefine; %If &Count. GT 0 %Then %Do; %Do j = 1 %to &Count.; %Let def&j = Define %Scan(&ModelVar.,&j) / Display /*Format=PValue. Style={BackGround=CorrSec.}*/ %Str(;); %Put def&j= &&def&j; &&def&j; %End; %End; %Else %Do; %Put ERROR: No value for ModelVar specified: &ModelVar; %End; %Mend MakeDefine; Ods Escapechar='~'; Options Missing=' '; Proc Report Data=Spr2_&Suffix. Nowd SpanRows Style(Column)=[BorderColor=Black BorderWidth=1px] Style(Header)=Header [BorderColor=Black BorderWidth=1px]; Column ("Spearman Correlation Coefficients, N = &Nobs ~n Prob > |r| under H0: Rho=0" Variable &ModelVar.); Define Variable /Order ' ' Style(Column)=Header{VJust=C FontWeight=Bold Color=#112277} ; %MakeDefine; %If &Count. GT 0 %Then %Do; %Do i = 1 %to &Count.; %Let Var&i = %Scan(&ModelVar.,&i,%str( )); %Put Var&i= &&Var&i; Compute &&Var&i; N+1; If Mod(N,2)=1 Then Do; Call Define("&&Var&i","Format","PValue."); Call Define("&&Var&i","Style","Style={BackGround=CorrSec.}"); End; EndComp; %End; %End; Run; The result of image as below;   As you can realise column's formats are different.   Thank you ... View more

@Ksharp,   Thank you very much for your help. Let's change my format with following format.   Proc Format; Value CorrSecond Low-<2 = "CX00B050"; Run; Then my desired output like this    In @Cynthia_sas's sample there is a separatrix for "Sex" variable like "F" and "M" but in my data set both two rows have same values like "Numeric1" and "Numeric1" and etc.   You did some additional calculation here but I do not exactly understand. Can you help to reach my desired output?   n+1; if mod(n,2)=0 then do;  Thank you ... View more

@Cynthia_sas and @Ksharp,   I realized something, some of the values of Numeric variables first row are coming as "<.0001" . Shouldn't them come as  "0" instead of ".<0001"   ... View more

@Cynthia_sas,   Exactly, you are totally right, after %Put statement I added &&def&j; then it worked. I'm sorry for tired you and @Ksharp out.    If I have an one more question to ask you, I would like to ask that is it possible to perform the format only first rows of Numeric variables? Current; Desired; Thank you ... View more

@Cynthia_sas, I meant this code ->   Proc Format; Value CorrSecond Low-<0.7 = "CX00B050"; Run; %Macro MakeDefine; %If &Count. GT 0 %Then %Do; %Do j = 1 %to &Count.; %Let def&j = Define %Scan(&ModelVar.,&j) / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} %Str(;); %Put def&j= &&def&j; %End; %End; %Else %Do; %Put ERROR: No value for ModelVar specified: &ModelVar; %End; %Mend MakeDefine; %Macro; Ods Escapechar='~'; Options Missing=' '; Proc Report Data=SprRaw2_&Suffix. Nowd SpanRows Style(Column)=[BorderColor=Black BorderWidth=1px] Style(Header)=Header [BorderColor=Black BorderWidth=1px]; Column ("Spearman Correlation Coefficients, N = &Nobs ~n Prob > |r| under H0: Rho=0" Variable &ModelVar_Raw.); Define Variable /Order ' ' Style(Column)=Header {VJust=C /*BackGround=CorrSecond.*/ FontWeight=Bold Color=#112277}; %MakeDefine; Run; %Mend; And this is the log from my real project-> MPRINT(REPORTING_CORRELATION): Title ; MPRINT(REPORTING_CORRELATION): Ods Escapechar='~'; MPRINT(REPORTING_CORRELATION): Options Missing=' '; MPRINT(REPORTING_CORRELATION): Proc Report Data=Spr2_MDL Nowd SpanRows Style(Column)=[BorderColor=Black BorderWidth=1px] Style(Header)=Header [BorderColor=Black BorderWidth=1px]; MPRINT(REPORTING_CORRELATION): Column ("Spearman Correlation Coefficients, N = 2813~n Prob > |r| under H0: Rho=0" Variable WOE_CMON_SCORE_PRD WOE_MEM_BANK_COUNT WOE_MEM_TOT_CASH_UTI WOE_MEM_TOT_NONCASH_UTI WOE_MEM_YKB_CASH_UTI WOE_MONTHS_CIF_OPEN WOE_NEGINFO_CT_2YR WOE_NET_SHARHOLDR_EQUITY WOE_ROA); MPRINT(REPORTING_CORRELATION): Define Variable /Order ' ' Style(Column)=Header{VJust=C FontWeight=Bold Color=#112277} ; def1= Define WOE_CMON_SCORE_PRD / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def2= Define WOE_MEM_BANK_COUNT / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def3= Define WOE_MEM_TOT_CASH_UTI / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def4= Define WOE_MEM_TOT_NONCASH_UTI / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def5= Define WOE_MEM_YKB_CASH_UTI / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def6= Define WOE_MONTHS_CIF_OPEN / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def7= Define WOE_NEGINFO_CT_2YR / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def8= Define WOE_NET_SHARHOLDR_EQUITY / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; def9= Define WOE_ROA / Display Format=PValue. Style(Column)={BackGround=CorrSecond.} ; MPRINT(REPORTING_CORRELATION): ; MPRINT(REPORTING_CORRELATION): Run; Can you observe any mistake in my  code?   Thank you ... View more

@Cynthia_sas,   The green colors are important for me, I think Tagattr just for decimals. In my previous code, why it cannot be working? what can be the reason? What about PValue format, it is so strange while it is working on my sample but not working on real data.   Do you have an idea about why it cannot be working in my data set?   Thank you ... View more

It didn't work 😞 ... View more