The way of creating the same distribution
14. April 2007 06:41Sometimes We want to create the same distribution .
We can do it in this way : The ttt limits the commulative distribution of another variable, which we can receive from proc freq )DATA SAME_DISTR;
SET SAME_DISTR;
IF TARGET =0 THEN DO;
ttt=ranuni(31311115)*100;
if ttt<=5 then kod=200502;
else if ttt<=28 then kod=200503;
else if ttt<=40 then kod=200504;
else if ttt<=52 then kod=200505;
else if ttt<=62 then kod=200506;
else if ttt<=71 then kod=200507;
else if ttt<=80 then kod=200508;
else if ttt<=88 then kod=200509;
else if ttt<=93 then kod=200510;
else if ttt<=100 then kod=200511;
end;
if target=1 then kod=100* year( Loan_Value_Date)+month(Loan_Value_Date);
run;
This is more wise way to do the same:
proc freq DATA = required_destribution;
tables Loan_Value_Date /out = outkod outcum noprint;
run; data _null_ ; length kod_str pct_str $5000;
set outkod end=eof;
retain kod_str pct_str;
kod_str=compress(kod_str||','||Loan_Value_Date);
pct_str=compress(pct_str||','||cum_pct);
if eof then do;
call symput('a1',substr(pct_str,2));
call symput('a2',substr(kod_str,2));
call symput('nn',_n_);
end;
run;
DATA SAME_DISTR;
SET SAME_DISTR;
array a1 {&nn} _temporary_ (&a1);
array a2 {&nn} _temporary_ (&a2);
IF TARGET =0 THEN DO;
ttt=ranuni(31311115)*100;
do i=1 to dim(a1);
if i=1 then do;
if ttt<=a1[i] then Loan_Value_Date=a2[i];
end;
else do;
if a1[i-1]<ttt<=a1[i] then Loan_Value_Date=a2[i];
end;
end;
end;
kod=100* year( Loan_Value_Date)+month(Loan_Value_Date);
run;
Email 
7/25/2011 11:34:11 PM
It's okay... love looking at your lovely post.
Not much words needed, really.
Pandora Charms