@FreelanceReinh  has already given you the GRAYCODE() solution. But I would suggest to use a more sophisticated solution SAS/OR and calling @RobPratt    The following code is for your first record 's solution . and I found 3 solutions: And I believe @RobPratt  could give you better code , the condition is you have SAS/OR software.   data have; input v $ Column1; cards; var1 -2000 var2 10000 var3 3000 var4 7000 var5 12000 var6 30 ; proc optmodel; set idx ; str var{idx}; num x{idx}; var v{idx} binary; read data have into idx=[_n_] var=v x=Column1 ; con con1:sum{i in idx} v[i]*x[i]=10000 ; solve with clp/findallsolns; create data want from [solution index]={s in 1.._NSOL_,i in idx} vname=var[i] value=x[i] flag=v[i].sol[s]; quit; proc print;run;   ... View more

Did you try to use PROC COPY instead of PROC SQL? proc sql; create table dbx.test as select * from test; run; ------------> proc copy in=work out=dbx; select test; run;   ... View more

SAS do allow #rrggbb to be right color. Did you try an example for it ?   proc sgplot data=sashelp.class; scatter x=weight y=height/markerattrs=(color='#FF0000' symbol=circlefilled); run;   ... View more

1) If you "need to pick the best /most optimum imputed dataset" ,there has nothing to do with PROC MIANALYZE. PROC MIANALYZE is just combining these 50 imputed datasets into ONE model. If you want to pick up the best imputed dataset, why not running your model(e.g. PROC MIXED) on these 50 datasets and found out the smallest AIC,BIC of model ? 2) For this scenario, you need to put this variable in CLASS statement to let PROC MI know it is a category variable not a continuous variable. ... View more

It is a small data, you could use PROC SQL to get job done. ... View more

Tom, Thumbs up! This SQL solution is only suited for small data. For big table, it would run into ages . That is reason that picking up a right tool is so important. ... View more

If your dataset is not big, that would be very easy by using SQL. Otherwise, you need to resort to use other skills.   Data loans_tbl; format date_Loan ddmmyy10.; Input CUSTID date_Loan :date9. Loan_Amnt; cards; 111 08JUL2025 30000 222 17JUL2025 15000 222 20JUL2025 10000 333 28JUL2025 17000 444 02JUL2025 5000 444 03JUL2025 12000 444 29JUL2025 18000 555 14JUL2025 38000 555 15JUL2025 30000 555 27JUL2025 18000 555 01JUL2025 100000 ; Run; Data offers_tbl; format date_offer ddmmyy10.; Input CUSTID date_offer :date9. Offer_Amnt; cards; 111 02JUL2025 20000 111 05JUL2025 20000 111 06JUL2025 40000 111 09JUL2025 8000 111 28JUL2025 15000 222 15JUL2025 15000 222 18JUL2025 40000 333 22JUL2025 20000 444 02JUL2025 7000 444 28JUL2025 50000 555 05JUL2025 50000 555 09JUL2025 48000 555 10JUL2025 55000 555 14JUL2025 38000 555 22JUL2025 20000 555 27JUL2025 18000 ; Run; proc sort data=loans_tbl; by CUSTID date_Loan; run; proc sort data=offers_tbl; by CUSTID date_offer; run; data have ; merge loans_tbl(rename=(date_Loan=date)) offers_tbl(rename=(date_offer=date)); by CUSTID date; run; proc sql; create table want as select *,case when not missing(Loan_Amnt) then (select max(Offer_Amnt) from have where CUSTID=a.CUSTID and date between a.date-7 and a.date) else . end as Relevant_off_to_loan from have as a ; quit; ... View more

If you only consider about DATE, that would be very easy. CODE EDITED.   Data loans_tbl; format date_Loan ddmmyy10.; Input CUSTID date_Loan :date9. Loan_Amnt; cards; 111 08JUL2025 30000 222 17JUL2025 15000 222 20JUL2025 10000 333 28JUL2025 17000 444 02JUL2025 5000 444 03JUL2025 12000 444 29JUL2025 18000 ; Run; Data offers_tbl; format date_offer ddmmyy10.; Input CUSTID date_offer :date9. Offer_Amnt; cards; 111 02JUL2025 20000 111 05JUL2025 20000 111 06JUL2025 40000 111 09JUL2025 8000 111 28JUL2025 15000 222 15JUL2025 15000 222 18JUL2025 40000 333 22JUL2025 20000 444 28JUL2025 50000 ; Run; data have ; merge loans_tbl(rename=(date_Loan=date)) offers_tbl(rename=(date_offer=date)); by CUSTID date; run; data temp; set have; by CUSTID; if first.CUSTID then seq=0; if first.CUSTID or lag(Loan_Amnt) ne . then seq+1; run; proc sql; create table want as select *,case when sum(Loan_Amnt)=. then . else seq end as new_seq from temp group by CUSTID,seq order by CUSTID,date; quit;   ... View more

As others said, in SAS world, proc sql is not right tool to process this kind of question. Pick up the right tool like data step or proc univariate. Anyway, here is an example SQL to solve this question.   data have; set sashelp.baseball; keep name salary; run; proc sql; select distinct a.* from have as a,have as b where a.salary < b.salary group by a.salary having count(distinct b.salary)=2; quit; /*Check the result is right or not*/ ods select ExtremeValues; proc univariate data=have nextrval=3; var salary; run;     ... View more

1)Try this:  CODE EDITED(try to make only one bookmarker). ods document name=testAW(write); proc sgplot data=sashelp.class; scatter x=weight y=height/group=sex datalabel=name; run; ods document close; proc document name=testAW; list/ levels=all; run; quit; proc document name=testAW2(write); setlabel \work.testAW\SGPlot#1\SGPlot#1 "Can I set or customize proctitle for PROC SGRENDER/SGPLOT"; copy \work.testAW\SGPlot#1\SGPlot#1 to ^; run; list/ levels=all; run; quit; title; proc document name=work.testAW2; ods pdf file="c:\temp\twolevels.pdf" startpage=no ; * Save this graphic into a PDF file named twolevels.pdf; replay ; run; ods pdf close; quit;         2)Or try this: ods pdf file='c:\temp\temp.pdf'; ods proclabel='Can I set or customize proctitle for PROC SGRENDER/SGPLOT '; proc sgplot data=sashelp.class; scatter x=weight y=height/group=sex datalabel=name; run; ods pdf close;   ... View more

As Linus pointed out, proc compare does not compare flat txt file,it just compare sas dataset. So firstly you need to change these txt file into sas dataset and then invoke PROC COMPARE.   data a; infile 'path1/output/HyFIPrems202501.txt' length=len; input x $varying200. len; run; data b; infile 'path2/output/HyFIPrems202501.txt' length=len; input x $varying200. len; run; proc compare base=a compare=b transpose brief; run; ... View more

Freelance, Sorry , I have no idea about this either. The only ERROR looks like in OP code is that unbalanced expression, so I suggested OP to fixed it by my code. ... View more

Adding the following two rows at the top of your code. But that would cost you lots of storage at SAS service side, due to not delete the temporary datasets produced by your sas code. libname x '.'; options user=x ; ... View more