1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
data a;
adresse2_d="2 RUE CHARLES DE GAULLE";
adresse3_d="RES DES FFL";
adresse4_d="BAT VERCORS";
adresse5_d="AA888 VILLE DES FRANCAIS LIBRES";
run;
data aa;
set a;
LENGTH PR_MAILING $200. ;
/*** PR_MAILING ***/
PR_MAILING=compbl(ADRESSE2_D)!!'0A'x!!compbl(ADRESSE3_D)!!'0A'x !!compbl(ADRESSE4_D)!!'0A'x!!compbl(ADRESSE5_D);
if substr(PR_MAILING,1,1) ='0A'x then PR_MAILING=substr(PR_MAILING,2);
if substr(PR_MAILING,1,1) ='0A'x then PR_MAILING=substr(PR_MAILING,2);
if substr(PR_MAILING,1,1) ='0A'x then PR_MAILING=substr(PR_MAILING,2);
if substr(PR_MAILING,length(PR_MAILING)-1,1)='0A'x then PR_MAILING1=substr(PR_MAILING,1,length(compbl(PR_MAILING)-2));
run;
DATA aa2; SET aa;
PR_MAILING_HEXA=PUT(PR_MAILING,$HEX1000.);
RUN;
PROC PRINT DATA =aa2;
VAR PR_MAILING PR_MAILING_HEXA ;
RUN; |
Partager