Hello Everyone,   Can someone please guide me how to proceed with the below issue. I want to minimize a value by changing coefficients of an equation. The coefficients of equation are first assigned a random number but should change later after optimization. Changing these coefficients should result in minimizing -- minimize_error I understand the values are already assigned as macro variables--w1-w8 & b1-b3 but I am fine with corresponding new macro variables.   Using solver in excel is just a few clicks. Want to explore equivalent of it in SAS.   Please advise. Thank You %macro weight(neuron=,hidden_layer=2); %let nos_weight=%sysevalf(((&neuron./2)**2)+(&neuron.)); %put &=nos_weight; data rand_data; call streaminit(0); do i = 1 to &nos_weight.; u=rand("Uniform"); output; end; run; %do i = 1 %to &nos_weight.; %global w&i.; %end; proc sql noprint; select u into :w1-:w&nos_weight. from rand_data ;quit; %do i = 1 %to &nos_weight.; %global w&i.; %put w&i.=&&w&i.; %end; %let bias=%eval(&hidden_layer.+1); data rand_data; call streaminit(0); do i = 1 to &bias.; u=rand("Uniform"); output; end; run; %do i = 1 %to &bias.; %global b&i.; %end; proc sql noprint; select u into :b1-:b&bias. from rand_data ;quit; %do i = 1 %to &bias.; %put b&i.=&&b&i.; %end; %mend weight; %weight(neuron=4,hidden_layer=2); data equation; input y m x c; datalines; 14 9 1 5 851 9 94 5 473 9 52 5 635 9 70 5 518 9 57 5 257 9 28 5 383 9 42 5 428 9 47 5 356 9 39 5 68 9 7 5 257 9 28 5 248 9 27 5 194 9 21 5 86 9 9 5 761 9 84 5 284 9 31 5 653 9 72 5 356 9 39 5 320 9 35 5 ;run; data equation2; set equation; n1h1=x*&w1.-&b1.; n2h1=x*&w2.-&b1.; n1h2=(n1h1*&w3.)+(n2h1*&w4.); n2h2=(n1h1*&w5.)+(n2h1*&w6.); output_network=(n1h2*&w7.)+(n2h2*&w8.); sq_diff=(y-output_network)**2; run; /*I want to minimize value of minimize_error by changing values w1-w8 and b1-b3*/ proc sql; select sum(sq_diff) format=best19.5 into: minimize_error from equation2 ;quit; %put &=minimize_error; ... View more

Please run the below code and check for dataset have2 Why do I get value of flag as "2<1" when all values in nos2 is > nos1? What am I missing?   Please advise. Thanks   PROC FORMAT; VALUE rvsd_format 5000-10000="5000-10000" 10000-25000="10000-25000" ; run; data have; input nos1 nos2; datalines ; 9544.59 10605.10 8588.00 10781.20 9029.48 11061.31 9831.00 10158.70 9454.00 13380.18 9504.00 15888.00 8400.00 12728.80 6672.00 16516.00 7595.12 14062.24 9951.13 10780.39 ; run; data have2; set have; fmt_nos1=put(nos1,rvsd_format.); fmt_nos2=put(nos2,rvsd_format.); if fmt_nos2=fmt_nos1 then flag="Equal"; else if fmt_nos2>fmt_nos1 then flag="2>1"; else flag="2<1"; run; ... View more

Hello,   I am trying to create formats using a dataset. I want to use Low and High as to accomodate extreme values. But at the same time, i want dot(.) in its own category of missing.   Having issue doing that. I get error like this: ERROR: Cannot mix missing and nonmissing values in the same range: 180-..   Please help. data ctrl2; input start :$8. end :$8.; datalines; 0 0 1 12 13 23 24 24 25 35 36 36 37 47 48 48 49 59 60 60 61 71 72 72 73 108 109 180 180 high ; run; data ctrl; set ctrl2 end=last; retain fmtname 'fmt_name_user' eexcl 'N'; Label = strip(strip(Start)||"-"||strip(end)); output; if last then do; hlo='O'; label='Missing'; output; end; run; proc format cntlin=ctrl; run;     ... View more

Hello,   How to get the lower and upper boundary limits of the bucket inside a dataset that is result of proc HPBIN?   proc hpbin data=sashelp.cars numbin=10 output=out_bin quantile ; input mpg_city; id mpg_city; run; If you run the above code you will get the below in results:   I want the Range in a dataset. How can i do that?   ... View more