Hi, I have to call those lines (among others) with %include: expo1=exp(C_ANGLO_0_5*PANGLO_0_5+C_ANGLO_5_10*PANGLO_5_10+C_ANGLO_25_60*PANGLO_25_60+C_ANGLO_60*PANGLO_60+1*(C_ANGLOxFRANCO_0_5*PANGLO_0_5+C_ANGLOxFRANCO_5_10*PANGLO_5_10+C_ANGLOxFRANCO_25_60*PANGLO_25_60+C_ANGLOxFRANCO_60*PANGLO_60)+ C_ALLO_0_1*PALLO_0_1+C_ALLO_1_3*PALLO_1_3+C_ALLO_10*PALLO_10+1*C_ALLOxFRANCO_0_1*PALLO_0_1+C_ALLOxFRANCO_1_3*PALLO_1_3+ C_ALLOxFRANCO_10*PALLO_10+C_POT_0_500*POT_0_500+C_POT_500_2000*POT_500_2000+C_POT_5000_20000*POT_5000_20000+C_POT_20000*POT_20000+ C_POP_0_5000*POP_0_5000+C_POP_5_10000*POP_5_10000+C_POP_25_75000*POP_25_75000+C_POP_75000*POP_75000+C_AUTOROUTE*AUTOROUTE+ C_DISTANCE*DISTANCE+C_RIVE_NORD*RIVE_NORD+C_RIVE_SUD*RIVE_SUD+C_LONGUEUIL*LONGUEUIL+C_LAVAL*LAVAL+C_MONTREAL*MONTREAL); Because I use an %include statement, I get the "truncated record" WARNING. I read that this happens when there is more than 250 characters et that the solution is to reduce the amount of characters. I guess I could divide this equation in 3 or 4 different, but I wonder if there is any other solution. Thanks, ... View more

Hi, I have a first dataset called "survieH" that looks like this: p1 p2 p3 p4 p5 p6 p7 p8 0,99805395 0,99972943 0,99978889 0,99983248 0,99986097 0,99988087 0,99989295 0,99989952 I have a second dataset called "survieF" that is similar to the first one: p1 p2 p3 p4 p5 p6 p7 p8 0,99829433 0,99976891 0,99982696 0,99986511 0,99989035 0,9999069 0,99991557 0,99992048 Finaly, I have the main database ("bd2006") that contains many observations (30000) and several variables, which "sex" (0-1). I want to create a new dataset that merges them under the condition that if sex=1 then variable I pick the p1-p8 variables in the survieF dataset and if sex=0, I pick the other one. I tried this, without succes: data work.bd2007; set work.bd2006; if _N_ EQ 1 and sex=0 then set survieH ;  if _N_ EQ 1 and sex=1 then set survieF ; I know I can do it by doing this, but I want to reduce the size of the dataset, so I don't think it's the best way. data survieH (keep ph1-ph8); set survieH; p1=ph1; ... p8=ph8; run; data work.bd2007; set work.bd2006; if _N_ EQ 1 then do set survieH; set survieF ; end; array ph ph1-ph8; array p p1-p8; do i=1 to 8; if sex=0 then p(i)=ph(i); end; drop ph1-ph8; run; ... View more

Hi, I have a macro who looks like this: %macro macr(years); %let number=500; ...many more lines... %mend; Instead of "500", I want to assign to %let number a value from a database in which the first column corresponds to the parameter of the macro, i.e. Years Number 2006 3454 2007 21321 2008 34324 2009 43 2010 4545 2011 4535 2012 435 2013 45 2014 3454 2015 65 How can I do that? Thanks, ... View more