Genetic Algorithm  is so sharp and powerful and almost be able to solve all kind of optimum problem.GA is a such powerful tool, you don't need OR any more. Just kidding. Which means You can solve all the optimum problems without any money if you have SAS University Edition.Code is written in IML. It is so amazing . I love it so much.   About problem : https://communities.sas.com/message/256779#256779           data have; input Player Position $  Points Price ; cards; 1 G 2 8000 2 D 4 7000 3 M 6 12000 4 A 8 10000 5 G 4 9000 6 A 9 14000 8 D 4 8000 9 M 6 4000 10 A 8 10000 12 A 9 14000 13 D 4 7000 14 M 6 12000 17 A 9 14000 18 G 2 8000 19 D 4 7000 20 M 6 12000 24 D 4 7000 25 M 6 12000 29 D 4 7000 30 M 6 7000 32 M 6 1000 36 D 4 7000 37 M 6 12000 42 D 4 7000 43 M 6 12000 45 G 4 9000 46 A 9 14000 47 D 4 7000 48 M 6 12000 55 D 4 7000 56 M 6 12000 60 D 4 6000 61 M 6 9000 63 M 6 2000 67 D 4 5000 68 M 6 9000 70 M 8 6000 ; run;   %macro createData(n=2); data have(drop=i rename=(count=player));     set have(drop=player); do i = 1 to &n;   count+1;   output; end; run; %mend createData; %createData()             options fullstimer; proc sort data=have;by Position Points ;run; proc sql noprint; select count(*) into : A from have where Position='A'; select count(*) into : D from have where Position='D'; select count(*) into : G from have where Position='G'; select count(*) into : M from have where Position='M'; quit; proc iml; use have; read all var _all_ where(Position='A'); Player_A=Player;Point_A=Points;Pice_A=Price; read all var _all_ where(Position='D'); Player_D=Player;Point_D=Points;Pice_D=Price; read all var _all_ where(Position='G'); Player_G=Player;Point_G=Points;Pice_G=Price; read all var _all_ where(Position='M'); Player_M=Player;Point_M=Points;Pice_M=Price; close have;     start football(x) global(Point_A,Pice_A,Point_D,Pice_D,Point_G,Pice_G,Point_M,Pice_M); points=sum(Point_A[x[1:2]],Point_D[x[3:6]],Point_G[x[7]],Point_M[x[8:11]]); sum_cost=sum(Pice_A[x[1:2]],Pice_D[x[3:6]],Pice_G[x[7]],Pice_M[x[8:11]]); if sum_cost>75000 | ncol(unique(x[8:11]))^=4  | ncol(unique(x[3:6]))^=4 | ncol(unique(x[1:2]))^=2  then points=1; return (points); finish;     id=gasetup(2,11,123); call gasetobj(id,1,"football"); call gasetcro(id,1.0,2); call gasetmut(id,0.2,2,1); call gasetsel(id,100,1,0.95); call gainit(id,10000,{1  1  1  1  1  1  1  1  1  1  1 ,                     &A &A &D &D &D &D &G &M &M &M &M }); niter = 100; summary = j(niter,2); mattrib summary [c = {"Max Points", "Avg Points"} l=""]; do i = 1 to niter; call garegen(id); call gagetval(value, id); summary[i,1] = value[1]; summary[i,2] = value[:]; end; call gagetmem(mem, value, id, 1); Players=Player_A[mem[1:2]]//Player_D[mem[3:6]]//Player_G[mem[7]]//Player_M[mem[8:11]]; sum_cost=sum(Pice_A[mem[1:2]],Pice_D[mem[3:6]],Pice_G[mem[7]],Pice_M[mem[8:11]]); print Players[ l="best member:"],       "Max Points: " value[l = ""],       "Total Cost:  " sum_cost[l = ""] ; iteration = t(1:niter); print iteration summary; call gaend(id); quit;                                                                       Xia Keshan ... View more

Hello, How can we calculate std on data that has an additional row each time. It is not a regular moving std , as the data window size increases each time. data available ; input dt y ; cards ; 1 80 2 20 3 40 4 60 ; run ; data wanted ; input dt std ; cards ; 1 80 . 2 20 42.426406871 3 40 30.550504633 4 60 25.819888975 ; run ; data calc ; x1 = 80 ; x2 = 20 ; x3 = 40 ; x4 = 60 ; new1 = std(x1,x2) ; *42.426406871 ; new2 = std(x1,x2,x3) ; *30.550504633 ; new3 = std(x1,x2,x3,x4) ;* 25.819888975 ; run ; Thanks ... View more

Recently in the SAS Community Library: SAS' @SophiaRowland spells out how SAS Model Manager's new model card works. Think of it like a "nutrition label" for AI models. ... View more

I’m currently working on integrating the OpenAI API into SAS using PROC HTTP . I’m attempting to make a POST request to the Chat Completions API but I consistently encounter a rate limit error (HTTP 429) on every single attempt.     /* Body of the POST request */ filename in temp; data _null_; file in; put '{"model": "gpt-3.5-turbo", "messages": [{"role": "user", "content": "' "&FinalPrompt." '"}]}'; run; /* Send the request */ filename resp temp; proc http method = "POST" url = "https://api.openai.com/v1/chat/completions" ct = "application/json" in = in out = resp; headers "Authorization" = "Bearer &api_key."; run; /* Print the response */ data _null_; infile resp; input; put _infile_; run; I always receive the following error, regardless of how infrequent or spaced out the requests are:   HTTP 429: Rate limit exceeded What I’ve Tried So Far: API Key: I’ve verified that my API key is working. Spacing Out Requests: Even when I run the requests manually with long delays in between, I still hit the rate limit on every attempt even though it is 3.5 and I have a paid subscription. Retry Logic: I attempted implementing retry logic with exponential backoff, but it hasn’t resolved the issue either. ... View more

Is it possible to ignore an error if I select a variable in proc sql that that does not exists? I'm running a loop over many years and in some years the variable exist in some it doesn't. ... View more