Hi,    I have a question about how to use do while loop, when the condition depends on the value from other datasets. Specifically, I want to create a semiannual calender dating back from various starting dates to 2002. Say, data0 contains a list of 100 dates ('begindate'), tagged by a variable 'id'.   What I wrote was:   %macro makecalender; %Do i = 1 %to 100;   data temp; set data0; if id = &i; run;   data calender&i; n = 0; set temp; do while (begindate - n*183 > '1JAN2002'd); date = begindate - n*183; output; n+1; end; run;   %if &i=1 %then %do; data calender; set calender&i; run;   %end; %if &i>1 %then %do; data calender; set calender calender&i; run; %end   %mend   which did not work.  The issue seems to lie on the line "do while (begindate - n*183 > '1JAN2002'd);", as when I replaced "begindate-n*183" with some specific inputs (like "27NOV2015"d) then it worked.   Could someone suggest how I might fix this?   Best regards, Yosh         ... View more

Hi, This is the first time I write a code with macro and I get stucked with seemingly very easy step. %macro readdata(yrmo=); data &yrmo;           infile 'C:\Users\XXX\&yrmo';           input cusip          $ 1-8 name $ 9-40 date          issue_date          maturity_date          trader_matrix $ flat_prc acc_int coupon          yield duration amount_out          Moody_rat SP_rat callability $ call_prc putability $ put_prc ret ind_code Fitch_rat index_flag convexity Duff_Phelps; run; %mend; %readdata(yrmo = Y0173); This code gives me an error message. ERROR: Physical file does not exist, C:\XXX\&yrmo. OK, the file actually exists and if I replace &yrmo with Y0173, the code works fine. How should I get &yrmo automatically replaced by macro? Any advice will be appreciated.  Thank you! Yosh ... View more

Hi, I have troubles in doing operation on my data 'ds_code', whose entry are all 6 or 7-digits numerics and characters. Seeing this as a source of trouble, I converted it into character (Line 2108 of the codes below). However, when I got to line 2117 (to identify which entry is the first for the particular ds_code), SAS shows the error message and stops. Could anyone suggest me how to fix this?  Your feedback is greatly appreciated. Thanks, Yosh 2104  data ds; 2105      set monthly_prices_yield_and_returns; 2106      sp1lag = lag1(spread_over_benchmark_curve); 2107      sp3lag = lag3(spread_over_benchmark_curve); 2108      char_code = put(ds_code, 7.); 2109      drop ds_code; 2110      rename char_code = ds_code; 2111  run; 2112 2113  Data ds; 2114      retain ds_code c; 2115      old_ds_code=put(ds_code, 6.); 2116      old_c=c; 2117      set ds; ERROR: Variable ds_code has been defined as both character and numeric. 2118      if old_ds_code=ds_code 2119          then c=old_c+1; 2120          else c=1; 2121  run; ... View more