https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439254#M109594 <P>The COMMA. informat (alias DOLLAR.) will read values with (and without) dollar sign in front and comma as thousands separator:</P><PRE><CODE class=" language-sas">data x; informat revenue comma.; input country $ revenue; cards; India 2000 Nepal 2000 USA $2,000 Canada $300 AUS $2005 ;run; </CODE></PRE> Thu, 22 Feb 2018 12:45:02 GMT s_lassen 2018-02-22T12:45:02Z https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439235#M109586 <P>Hi all,&nbsp;</P><P>we have one external file in which one of numeric column has the two different type of data as shown in below :-</P><P>&nbsp;</P><P>Country&nbsp; &nbsp;Revenue&nbsp;</P><P>India&nbsp; &nbsp; &nbsp; &nbsp; 2000</P><P>Nepal&nbsp; &nbsp; &nbsp; 2000&nbsp;</P><P>USA&nbsp; &nbsp; &nbsp; &nbsp; $2,000&nbsp;</P><P>Canada&nbsp; $300</P><P>AUS&nbsp; &nbsp; &nbsp; &nbsp;$2005</P><P>&nbsp;</P><P>&nbsp;</P><P>how to write code for above scenario and Dataset output should look like :-</P><P>&nbsp;</P><P>Country&nbsp; &nbsp;Revenue&nbsp;</P><P>India&nbsp; &nbsp; &nbsp; &nbsp; 2000</P><P>Nepal&nbsp; &nbsp; &nbsp; 2000&nbsp;</P><P>USA&nbsp; &nbsp; &nbsp; &nbsp; 2000&nbsp;</P><P>Canada&nbsp; 300</P><P>AUS&nbsp; &nbsp; &nbsp; &nbsp;2005</P><P>&nbsp;</P> Thu, 22 Feb 2018 11:50:00 GMT https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439235#M109586 MG18 2018-02-22T11:50:00Z https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439254#M109594 <P>The COMMA. informat (alias DOLLAR.) will read values with (and without) dollar sign in front and comma as thousands separator:</P><PRE><CODE class=" language-sas">data x; informat revenue comma.; input country $ revenue; cards; India 2000 Nepal 2000 USA $2,000 Canada $300 AUS $2005 ;run; </CODE></PRE> Thu, 22 Feb 2018 12:45:02 GMT https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439254#M109594 s_lassen 2018-02-22T12:45:02Z https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439256#M109595 <P>Use <A href="http://documentation.sas.com/?docsetId=leforinforref&amp;docsetTarget=n1dvsmv8t9o60gn1dk1gkev91nan.htm&amp;docsetVersion=3.2&amp;locale=en" target="_self">Comma&nbsp;Informat</A></P> Thu, 22 Feb 2018 12:48:43 GMT https://communities.sas.com/t5/SAS-Programming/how-to-use-informat-for-a-external-file-having-2-different/m-p/439256#M109595 PeterClemmensen 2018-02-22T12:48:43Z