Hello Experts,   I would like to taste if my rate (Taux) is equal +/- 5%. My code is  : proc means data=RP_EA7 noprint; class cle; var Taux; output out=RP_EA7_STAT stddev=stddev; run; data RP_EA8_STAT; length Commentaire $50; set RP_EA7_STAT; if _type_=0 then delete; if stddev<0.05 then Commentaire='Taux égaux'; else if stddev=. then Commentaire='Une seule valeur'; else Commentaire='Valeurs ne sont pas égaux’; run; But I think that STDDEV is not a good indicator (I would like to have a value +- 5%).  Do you know, please, another way to do this selection?   Thank you! ... View more

Hello Experts,   I have a question : if my date is, for example, '15Jan2021:0:0:0'dt, and I would like to find the last friday before this date, there is some function in SAS ?   Thank you very much ! ... View more

Hello Experts, My Date_1 < Date_2 so I would like to get only the observation with 7 days diffrence. Could you tell me if my code is right : proc sql; create table Result as select a.*, b.* from total_RE as a left join SUP as b on a.pers=b.pers and intck('day',b.D_1, a.D_2)<7; quit; Thank you !     ... View more

Hello Experts,   I have a data ID_F and F (in numeric format), I would like to put the ID_F in format 0000 and F in 000 format. Do you know how to do it easily beacause I apply Repet function with IF THEN ELSE condition. Maybe there is some format statement ? I joined the data. Thank you for your help !   ID_F (numeric) F (numeric) ID_F-F (character) 73 1 0073-001 83 2 0083-002 45 4 0045-004 1 23 0001-023 453 23 0453-023 ... View more