how to use informat for a external file having 2 different format of data in same file ?

[MG18]

Hi all, 

we have one external file in which one of numeric column has the two different type of data as shown in below :-

Country   Revenue 

India        2000

Nepal      2000 

USA        $2,000 

Canada  $300

AUS       $2005

how to write code for above scenario and Dataset output should look like :-

Country   Revenue 

India        2000

Nepal      2000 

USA        2000 

Canada  300

AUS       2005

[s_lassen]

The COMMA. informat (alias DOLLAR.) will read values with (and without) dollar sign in front and comma as thousands separator:

data x;
  informat revenue comma.;
  input country $ revenue;
cards;
India 2000
Nepal 2000
USA $2,000
Canada $300
AUS $2005
;run;

[PeterClemmensen]

Use Comma Informat