About ZRick

ZRick · ‎03-08-2012

Can you help explain little bit: why should I take %let mv=&mv; out side of proc sql? Appreciate it!

ZRick · ‎03-08-2012

Main issue is that the macro variable mv is not passed, so, catx can't move on, how do I fix it? data tmp; length stmt $50; input cat stmt &$; datalines4; 1 I am 1 good writer; 2 statement sample here ;;;; proc transpose data=tmp out=trans (drop=_name_); by cat; var stmt; run; /*sets number of cat variables into mv variable*/ proc sql; select count(cat) into :mv from tmp group by cat; %let mv = &mv; quit; data fnl(keep=x); set trans; x=catx(" ",col1-col&mv); run;

ZRick · ‎03-08-2012

How do I lump them into 2 rows now by cat? for following code, lump them into two rows, one for cat=1, one for cat=2 data tmp; length stmt $50; input cat stmt &$; datalines4; 1 data A; 1 set sashelp.class; 1 run; 1 proc print data=a; 1 run; 2 data B; 2 set sashelp.cars; 2 run; 2 proc print data=b; 2 run; ;;;; proc sql; select trim(stmt) into : macrovar separated by '' from tmp; quit; %put %bquote(&macrovar);

ZRick · ‎03-08-2012

Is there a way to group variables together and just write the condition once? I have many variables share the same condition.

ZRick · ‎03-08-2012

sidebar question: how did you get the color coding in the post? I tried to do that in base sas and copy / paste, it does not work for me.

ZRick · ‎03-08-2012

Two variables accrual_1, accrual_2 share the same condition, but I don't know how to write them into the same if statement. data tmp; input accrual_1 accrual_2; cards; 1 2 12 4 3 5 ; data tmp2 tmp3; set tmp; if (accrual_1 or accrual_2) not in (1, 2, 3, 4, 5, 6) then output tmp3; else output tmp2; run;

ZRick · ‎03-08-2012

You asked about "why you want to use %put to output the results" Basically, you see, entrie row will be big data step, I want to use them in the macro, so when this macro is called, the data step is executed automatically. I don't know if output to log is the right place to do that, maybe you have a better suggestion?

ZRick · ‎03-08-2012

I think I am getting there， Ksharp， your code is really useful, I edit it, but final output appeared twice, one shows up as "data tmp", one shows up as the right combination "data tmp; set sashelp.car; run", 2nd one is what I want, not "data tmp", any ideas? data t; length stmt $50; input stmt &$; cards; data tmp set sashelp.car run; data _null_; set t end=last; length row $ 3200; retain row; row=catx("; ",row,stmt); if last then call symput('var', row); run; %put &var;

ZRick · ‎03-08-2012

data t; length stmt $50; input stmt &$; cards; data tmp set sashelp.car run ; data t2(keep = m); set t; m = trim (left(stmt)) || ";"; run; I want to write a macro, a macro that merges all rows into one big row then pass it along to a variable, using %put to output it. Here I give an example 3 rows, the number of rows could be dynamic, How do I do that?

ZRick · ‎02-02-2012

I have a variable CPN_DT that is char, length 80 format $80, has following value: 05/21/2010 07/01/2010 03/01/2011 How do I convert it to sas date? I used following, but it doesn't work cpn_dt = input(trim(cpn_dt),MMDDYY10.); How can I fix this? I really wonder why sas read this as char type with length of 80, because I got this variable via proc sql through odbc to oracle database. why does SAS not recognize this as a mmddyy10. value?

ZRick · ‎02-01-2012

I used if else, select when to map frequency values, but it turns out wrong mapping. how do I fix this? data t3; length coupon_frequency $12; input COUPON_FREQUENCY $; cards; Semi-Annual Semi-Annual Semi-Annual Quarterly Semi-Annual Semi-Annual Semi-Annual Semi-Annual Annual Semi-Annual Semi-Annual Semi-Annual new ; data t5; set t3; select (coupon_frequency); when("annual") freq='1'; when("monthly") freq='4'; when("semi-annual") freq='2'; when("quarterly") freq='3'; otherwise freq='2'; end; run; data t6; set t3 ; if trim(coupon_frequency) eq "annual" then freq='1'; else if trim(coupon_frequency) eq "monthly" then freq='4'; else if trim(coupon_frequency) eq "semi-annual" then freq='2'; else if trim(coupon_frequency) eq "quarterly" then freq='3'; else freq='2'; run;

ZRick · ‎02-01-2012

how do I fix it then? retain statement has no effect in the fcmp function. Reeza, it does look like a NPV issue, but it is acutally bootstrapping the zero curve rate.

ZRick · ‎01-31-2012

I defined a function in fcmp, use ssum to accumulate previous result, initial value is 0, but it didn't take any effect. When you run the data step in following code, the unsifted_t is the same as unshifed, but it should be same as unshifted_spot_result. I really need this function to go through other variables. data unshifted_t; input Years Unshifted Unshifted_spot_result; cards; 0.5 0.06 0.06 1 0.0995 0.099509828 1.5 0.114 0.114015775 2 0.1285 0.128527322 2.5 0.17625 0.17636429 3 0.224 0.224255193 3.5 0.32975 0.330598452 4 0.4355 0.437295432 4.5 0.562 0.565505696 5 0.6885 0.694372675 5.5 0.806875 0.815596351 6 0.92525 0.937551696 6.5 1.043625 1.060324593 7 1.162 1.184005865 7.5 1.242833333 1.268562214 8 1.323666667 1.353681835 8.5 1.4045 1.43941207 9 1.485333333 1.525802656 9.5 1.566166667 1.612905958 10 1.647 1.70077724 10.5 1.7015 1.759653469 11 1.756 1.819015077 11.5 1.8105 1.878885836 12 1.865 1.939291582 12.5 1.900666667 1.978108796 13 1.936333333 2.017278596 13.5 1.972 2.056807704 14 2.007666667 2.096704449 14.5 2.043333333 2.136978638 15 2.079 2.177641474 ; proc fcmp outlib=work.ftn.krd; function OSSC(in); ssum= 0; do i = 1 to 60; llatest = 0.5 * (in) / 100; spot_llatest1 = (1 - llatest*ssum) / (1 + llatest); ssum+spot_llatest1; spot_llatest2 = Exp(-Log(spot_llatest1)/i) - 1; spot_llatest3=spot_llatest2*100*2; return(spot_llatest3); end; endsub; run; data OSSC; set unshifted_t; Unshifted_s = OSSC(Unshifted); format unshifted_s 10.8; run;

ZRick · ‎01-29-2012

what is the purpose of retain statement? Is K initially assume as zero? Should I do following if I want to initial k value other than zero? data want; set t; k=2.4; retain k; k+m; run;

ZRick · ‎01-29-2012

hi all, data t; input m; cards; 5 4 11 ; data t2; set t; k=m+; output; run; I want result like this: m k 5 5 4 9 11 20

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

set IML matrix name based on the do loop, how do I do that?

need the logic to tell if this value looks like numeric

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

how to generate sas code using recursive join

How do I combine each row into one big row?

what is the purpose of if _N_=1 then do in this data step?

Can macro variables created in select into be local?

how to convert char var to sas date?

how to find closest match that is less than its date?

problem catx with macro variable passed in

problem catx with macro variable passed in

How do I combine each row into one big row?

multiple variables use the same condition, how to write them in the sa...

multiple variables use the same condition, how to write them in the sa...

multiple variables use the same condition, how to write them in the sa...

Re: How do I combine each row into one big row?

How do I combine each row into one big row?

How do I combine each row into one big row?

how to convert char var to sas date?

why sas does't map to the right value?

why my ssum didn't accumlate previous sum in FCMP?

why my ssum didn't accumlate previous sum in FCMP?

how to get the variable that is based on cumulative sum of pervious ro...

how to get the variable that is based on cumulative sum of pervious ro...