Dear all,   I have two matrices like this: DATA mydata ; INPUT ID Country $ value ; CARDS ; 1 CH 24 1 ES 55 1 EE 20 2 BR 10 2 CO 50 2 CH 10 ; RUN ; data supplement; input Country CH DE BR ES CU CO EE; cards; CH 1 0.4 0.5 0.6 0.7 0.8 0.9 DE 0.4 1 0.5 0.6 0.7 0.8 0.9 BR 0.4 0.5 1 0.6 0.7 0.8 0.9 ES 0.4 0.5 0.6 1 0.7 0.8 0.9 CU 0.4 0.5 0.6 0.7 1 0.8 0.9 CO 0.4 0.5 0.6 0.7 0.8 1 0.9 EE 0.4 0.5 0.6 0.7 0.8 0.9 1 ; run;   The second one can be understood as a correlation matrix (weights) between countries. For each ID in mydata, I want to have the weighted sum of the values, where the weights between two countries come from the data supplement. For example, for ID 1, I want to have 0.4*24*55+0.4* 24*20+0.9*55*20.  So in the output, I have two variables, the ID and the weighted sum.    I am guessing one can solve this problem with proc iml. But how can I do it?    Many many thanks for helping!! ... View more

Hi,   I am new to proc iml. I read that froot function could replicate excel sovler. I try to solve an equation towards the variable x, which is supposed to a number between -1 and 1,  but I got the error: invalid Operation. I am guessing I put in the wrong bound. Could someone please help me with this Problem?   Many thanks! Best data have; input D0 D1 D2 D3; ZERO = 0;   ID = _N_; datalines;   0.1 0.45 100 80 0.05 0.5 200 150 0.3 0.45 300 180 0.5 0.6 400 200 0.15 0.6 500 200 ; run; proc iml; start Func (x) global (D0, D1, D2, D3); return ((CDF('NORMAL',(Quantile('NORMAL',D1) + sqrt(x)*Quantile('NORMAL', .999))/sqrt(1-x), 0, 1)-D0)*D1*D2 - D3); finish; use have; read all var {D0 D1 D2 D3} into D; close; x=j(nrow(D),1); do i=1 to nrow(D); D0= D[i,1]; D1= D[i, 2]; D2 = D[i, 3]; D4 =D[i,4]; x[i]=froot("Func", {-1,1}); end; print x;     ... View more

Dear all   I have a problem importing numeric variable with different lengthes and decimal places with the format best. The variable X was not identified as numeric, so I used put(X, best.) to convert it into a numeric variable. Since the original data in excel have different lengthes and decimal places, some numbers that I read into SAS were wrong (like originally 0.00225 was imported as 2.25 etc.). How I can fix this problem?   Many thanks in advance!    Best regards Xiao ... View more

Good morning I want to get an triangle matrix from a column like this: data have; input i column; cards; 1 0.5 2 0.6 3 0.7 4 0.8 ; run; data want; input i col1 col2 col3 col4; cards; 1 0.5 0.5 0.5 0.5 2 .     0.6 0.6 0.6 3 .     .    0.7 0.7 4 .    .     . 0.8 ; run; Any help is appreciated! BR  Dingdang ... View more

Hi, I have a dataset which looks like: data have; infile datalines; input numbers; datalines; 1 1 . 2 3 4 . 5 5 6 7 7 ; In case the previous obervation is not . and the present observation equals to the previous value, then i would like to set the current value to . So what I would like to have is data want; infile datalines; input numbers; datalines; 1 . . 2 3 4 . 5 . 6 7 . ; Can someone help me solve this problem? Many thanks in advance! BR  Dingdang ... View more

Hi, I wanted to use a macro variable &var in the imagename like this: ods graphics on / reset=all imagename="ROC_&var"; I got this warning from log WARNING: The IMAGENAME option or the output name contains invalid characters. ROC_interestrate will be used as the image name           prefix. ROC_interestrate is the name that I wanted for my graph. So this warning didnt really affect my result. But I am curious where I did sth. wrong. Can someone please help me? Thank you very much in advance! BR  Ding ... View more