Yes of course, you will find attached a sample including : The Data imported The data seen in the sas GUI and expected. The data after export. Basically the program import the data and run som procedure to calculte the amount displayed. The matter is within the "TrimCptbl" column that i have created in SAS. However After using the proc export or a print export the blank is erased. Thank you in Advance PROC SQL;
CREATE TABLE WORK.BEN_CONSO_FAMILLE_02 AS
SELECT DISTINCT t1.AnneeSurv,
t1.College,
t1.Couverture,
t1.Garantie,
t1.TypeBenef,
t1.Famille,
/* AnneeCptbl */
(FLOOR(t1.MIN_of_AnneeTrimCptbl/10)) AS AnneeCptbl,
/* TrimCptbl */
(" T" || put( MOD(t1.MIN_of_AnneeTrimCptbl, 10) , 1.)) AS TrimCptbl, /* NbBenefConso */
(COUNT(t1.'Id Beneficiaire'n)) AS NbBenefConso,
/* MntRC */
(SUM(t1.SUM_of_MntRC)) FORMAT=COMMAX8.2 AS MntRC,
/* NbActes */
(SUM(t1.SUM_of_NbActes)) FORMAT=BEST12. AS NbActes,
/* NbActesOptions */
(SUM(t1.SUM_of_NbActesOptions)) FORMAT=BEST12. AS NbActesOptions
FROM WORK.BEN_CONSO_FAMILLE_01 t1
WHERE t1.SUM_of_NbActes NOT = 0 OR t1.SUM_of_NbActesOptions NOT = 0
GROUP BY t1.AnneeSurv,
t1.College,
t1.Couverture,
t1.Garantie,
t1.TypeBenef,
t1.Famille,
(CALCULATED AnneeCptbl),
(CALCULATED TrimCptbl);
QUIT;
... View more
