Why 999's order number is 2 ? Aren't you count it from past to the future? Data have; format date date9.; input ID appidentity date :date9. ; format date date9.; cards; 1 123 05FEB2026 2 123 05FEB2026 1 999 25JAN2025 2 999 25JAN2025 1 456 01JAN2026 2 678 05JAN2025 2 777 17DEC2025 ; Run; proc freq data=have noprint; table appidentity*id/out=id nopercent; run; data new_id; do until(last.appidentity); set id(keep=appidentity id); by appidentity; length new_id $ 100; new_id=catx('|',new_id,id); end; drop id; run; proc sql; create table have2 as select * from have natural left join new_id order by new_id,date,appidentity; quit; data want; set have2; by new_id date; if first.new_id then order=0; if first.date then order+1; run; ... View more

You want this ?   proc tabulate data=sashelp.heart(obs=1000); class status bp_status sex; var ageatstart; table status bp_status all='Total', ALL="Total" *ageatstart=" "*(sum="py"*f=8.0 colpctsum="%"*f=8.1) sex="exposure"*ageatstart=" "*(sum="py"*f=8.0 pctsum<status bp_status sex>="%"*f=8.1) ; keylabel sum=' '; run;   ... View more

Thanks Warren.K for writing so many words to explain this issue more details. According to SAS Doc , VVN=ANY is only tested under SAS/Base and SAS/Stat, not at other module's side. Whereas SAS suggested us not to use this option at other modules like OR ,IML , QC .... ... View more

Maybe the reference level is different for this kind of scenario. Try REF= option: class usubjid trt01pn(ref='1') avisitn(ref='1') ; class usubjid trt01p(ref='Placebo') avisitn(ref='Week1') ; About your questions: "When using PROC MIXED, is it preferable to use numeric or character variables in the CLASS statement?" No. I don't think so. Both could be accepted . The different thing might be the reference level of CLASS variable. "Does the sorting order of class variables affect the analysis results?" Yes. that might lead to the different reference level, you can make some data to test it is right or not. ... View more

Yes. I think so. XLSX engine is designed by SAS. EXCEL engine is designed by Microsoft. Since both are the most recent engine, I think you could read in this large excel file. ... View more

VALIDVARNAME=V7 could apply to all the module of SAS. But VALIDVARNAME=ANY is only available to SAS/Base and SAS/Stat. If you are using other module like SAS/OR , SAS/IML that might generate some error info. ... View more

Here is IML code/solution if you need it.   libname x v9 'C:\Users\xiakeshan\Documents\Downloads'; proc iml; use x._t_mm_temp_coll_n(keep=off_max_ct:); read all var _num_ into off_max_ct[c=vname]; close; use x._t_mm_temp_coll_n; read all var {xahead}; close; parameters=j(nrow(xahead),2,.); /*Save Intercept and Slope parameter estimator*/ t_off_max_ct=t(off_max_ct); x=j(nrow(t_off_max_ct),1,1)||t(inputn(scan(vname,-1,'_'),'best.')); do i=1 to ncol(t_off_max_ct); y=t_off_max_ct[,i]; parameters[i,]=t(solve(x`*x,x`*y)); end; create want from xahead parameters[c={'xahead' 'Intercept' 'Slope'}]; append from xahead parameters; close; quit; ... View more

You want this ?   Data tbl1; input application_number ID_number; cards; 123 033948333 123 041876222 456 051222222 789 718888888 ; Run; Data tbl2; input ID_number client_number; cards; 033948333 1 033948333 3 041876222 1 041876222 4 051222222 5 ; Run; proc sql; create table want as select a.*,client_number from tbl1 as a inner join tbl2 as b on a.ID_number=b.ID_number group by application_number,client_number having count(distinct ID_number)= (select count(distinct ID_number) from tbl1 where application_number=a.application_number); quit; ... View more

PROC REPORT would be the best PROC for your this question.   data have; input Quarter :$2. IceCream :$12. Sales :comma. Concession :comma.; format Sales Concession dollar6.2; cards; Q1 Chocolate $30 $5 Q2 Vanilla $25 $15 Q3 Butterscotch $50 $10 Q4 Strawberry $80 $3 Q1 Chocolate $30 $2 Q2 Vanilla $25 $10 Q3 Butterscotch $50 $20 Q4 Strawberry $80 $9 ; proc report data=have nowd; column Quarter IceCream Sales Concession pct; define Quarter/display; define Sales/display; define Concession/display; define pct/computed format=percent8.2; compute pct; pct=Concession/Sales; endcomp; run;   ... View more

Here are two ways you can use to get these parameter estimator within a data set.   libname x v9 'C:\Users\xiakeshan\Documents\Downloads'; data x; set x._t_mm_temp_coll_n; array _x{*} off_max_ct_: ; do i=1 to dim(_x); y=_x{i}; x=input(scan(vname(_x{i}),-1,'_'),best.); output; end; keep x y xahead; run; ods select none; ods output ParameterEstimates= ParameterEstimates2; proc reg data=x ; by xahead; model y=x; quit; ods select all;   libname x v9 'C:\Users\xiakeshan\Documents\Downloads'; data x; set x._t_mm_temp_coll_n; array _x{*} off_max_ct_: ; do i=1 to dim(_x); y=_x{i}; x=input(scan(vname(_x{i}),-1,'_'),best.); output; end; keep x y xahead; run; ods select none; proc reg data=x outest=ParameterEstimates; by xahead; model y=x; quit; ods select all; ... View more

Here is an example: data dattrmap; input id $ value :$20. linecolor $ linethickness linepattern :$20.; cards; id IBM red 2 dot id Intel green 4 dash id Microsoft blue 8 solid ; proc sgplot data=sashelp.stocks dattrmap=dattrmap; series x=date y=close /group=stock attrid=id; run;   ... View more

Yes. I think so. Check SAS Doc. ... View more

Once you get these start and end date like the following, that would be very easy thing.   data start_end; do start=date()-1000 to date() by 15; end=start+14; output; end; format start end date9.; run; ... View more