Hi all,
Please can you advice.
/* When I execute the below code it errors , how can I avoid the below error through code . The below data is read externally and I have no control . However , can you suggest something to overcome the above issue programmatically . */
ERROR: The ID value "'Anti smoking prdcts Freq Buy Eve'n" occurs twice in the input data set.
data foo; infile datalines delimiter=','; input F1 $:100. no1 no2 ; datalines; Anti smoking prdcts Freq Buy Every 2 to 3 months,10,20 Anti smoking prdcts Freq Buy Every 4 to 6 months,30,40 Hair loss prev prod Freq Buy Every 2 to 3 months,40,50 Hair loss prev prod Freq Buy Every 4 to 6 months,60,70 run; proc transpose data=foo out=foo1; id f1; run;
... View more