Hi all, i'm writing a script for data step. the raw file is like this: (dlm=,) ID,visit_freq,sales1,sales2,sales3,sales4 A,3,2,3, B,4,1,,2,4 C,2,1,2 output should be like this: ID sales A 2 A 3 A . B 1 B . B 2 B 4 C 1 C 2 i have used do while but the output is a bit different: data sales1; infile ' data path' dlm=',' missover; input ID$ visit_freq @; do until (visit_freq=0); visit_freq=visit_freq-1; input sales @; output; end; drop visit; run; finally i got the output is different the expected (problem of observation B)... may anyone help on this???? Thanks in advance!!
... View more