Hello Experts,   My data is very huge, it takes 5 hours to run the code. Do you know some tricks to avoid this please ? My code is :   proc sql; create table event2020 as select * from pkt.event where year(datepart(d_compta)) >= 2019 and year(datepart(d_compta)) <= 2020; quit; Thank you very muche for your help !     ... View more

Hello Experts,   I can't resolve the error in "case" of proc sql. My code seems to be correct : %let mois=10; %let jour=10; %let annee_20=2020; %let annee_21=2021; proc sql; create table Prestations_RT as select distinct is_contrat, datepart(d_eff_sin) as date_sinistre format = ddmmyy10., year(datepart(d_bilan)) as annee_bilan, sum(mt_brut_prest * (cd_dossier = "DCASS")) as Mt_DC, sum(mt_brut_prest * (cd_dossier = "DCCCS")) as Mt_DC_rentes, sum(mt_brut_prest * (cd_dossier = "RT")) as Mt_RT, sum(mt_brut_prest * (cd_dossier = "RTCCS")) as Mt_RT_rentes, Case when (mdy(01,01,2020) <= datepart(date_sinistre) <= mdy(&mois.,&jour.,&annee_20.) then "T1_2020") when (mdy(01,01,2021) <= datepart(date_sinistre) <= mdy(&mois.,&jour.,&annee_21.) then "T1_2021") end as Trimestre from Table where /*substr(is_contrat,1,4) in &Liste_produits. and */(mdy(01,01,2020) < (datepart(date_sinistre)) < mdy(&mois..,&jour.,&annee_20.)) and (mdy(01,01,2021) < (datepart(date_sinistre)) < mdy(&mois.,&jour.,&annee_21.)) group by is_contrat, year(datepart(d_bilan)); quit; I have this error all time, I don't know why. I attached the data.   Thank you for your help ! ... View more

Hello Experts,   I'm wondering how to create a macro variable with spaces : %let Feuille = Villes et rues I would like to use this macro varaible in proc export's sheet statement : ..... dbms=xlsx replace; sheet="&Feuille ."; .....   Thank you for your help !     ... View more

Hello Experts,   I'm wondering how to hold the spaces while using the compress function. The values of my variable is X='TYPE 1 INDEX 2'.  When I use compress(X||' '||'P3') I have 'TYPE1INDEX2 P3', I would like to have TYPE 1 INDEX 2 P3   There is some option for compress function please or, in this case, the STRIP function is better ? Thank you for helping !     ... View more

Hello Experts,   Do you know please how to convert this column to numeric without passing by "substr" function ?     Thank you for help ! ... View more

Hello Experts,   I'm wondering if there is an easiest method to convert the character data to numeric (without applying the substr function). The data is:     Thank you very much for your help !   ... View more

Hello Experts,   My data is :  I would like to extract the name from first row and put it as coulumn name. I would like to do that with proc contents and after do the set of two tables. Maybe you know the easiest method ?    Thank you for your help ! ... View more