I create a repport with a stored process. I use SQL. I run this process with reports on in sas add-in for Excel. In this reports are numbers beginnen with zero, like 000048383. I will keep this zeros. I think i should slove this in the stored proces tab "Data Sources and Targets. But I do'nt know how. My code is like this. VESTIGINGSNR is like 000047178622 format $12. PROC SQL; SELECT DISTINCT FORMULE.HANDELSNAAM label="Handelsnaam", FORMULE.NAW label="Adres", FORMULE.VESTIGINGSNUMMER AS VESTIGINGSNR label="Vestigingsnummer" FROM AIDDWH.REF_FORMULEBEDRIJF AS FORMULE ; QUIT;
... View more