Seperating the numbers in a single variable

[Sowmya12]

Suppose if dataset contains

Id         ict
102     4
103      5,7
;
run;



The output dataset should be

Id       ict
102    4
103     5
103      7


Suggest me how can I get the output as mentioned above

[japelin]

How about this code?

data have;
  length Id 8 ict $8;
  infile datalines dlm=' ';
  input id ict;
datalines;
102 4
103 5,7
;
run;

data want;
  set have;
  tmp_cnt=count(ict,',')+1;
  tmp_ict=ict;
  do i=1 to tmp_cnt;
    ict=scan(tmp_ict,i,',');
    output;
  end;
 
  drop tmp_: i;
run;

(modified.) 

[Kurt_Bremser]

You can simplify this with the use of dataset options and use of the COUNTW function in the DO statement:

data want;
set have (rename=(ict=_ict));
do i = 1 to countw(_ict,",");
  ict = scan(_ict,i,",");
  output;
end;
drop i _ict;
run;

[Kurt_Bremser]

PS if you want numbers, add an INPUT function:

data want;
set have (rename=(ict=_ict));
do i = 1 to countw(_ict,",");
  ict = input(scan(_ict,i,","),32.);
  output;
end;
drop i _ict;
run;