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 29 30 31 32 33 34 35 36 37
|
data base ;
input client var1$ var2$ var3$ ;
cards ;
1 1/2/3 oui 1/2/5
2 2/3 non 2/5
3 1/5 non 1/2/4
4 4/5 oui 5/6
; run ;
proc format;
value $colfmt
'1' = 'Appartement'
'2' = 'Maison'
'3' = 'Voiture'
'4' = 'Vélo'
'5' = 'Moto'
'6' = 'Magasin';
run;
data t1 (keep=client _:) ;
set base;
length _var1 $30. _var2 $10. _var3 $30. ;
nb1 = countc(var1, '/')+1 ;
nb3= countc(var3, '/')+1 ;
do i = 1 to nb1 ;
col = compress(scan(var1, i, '/'));
if i =1 then _var1=put(col, $colfmt.);
else _var1=cats(_var1, '/', put(col, $colfmt.)) ;
end;
_var2=var2 ;
do j = 1 to nb3 ;
col = compress(scan(var3, j, '/'));
if j =1 then _var3=put(col, $colfmt.);
else _var3=cats(_var3, '/', put(col, $colfmt.)) ;
end;
run; |
Partager