topic Re: Informats & Formats on Numeric variables in SAS Programming https://communities.sas.com/t5/SAS-Programming/Informats-Formats-on-Numeric-variables/m-p/123562#M25358 <HTML><HEAD></HEAD><BODY><P>Is this what you are after?</P><P></P><P>data test;</P><P>infile cards dsd;</P><P>informat money comma20.;</P><P>input money;</P><P>cards;</P><P>$1000.00</P><P>2500.00</P><P>"4200.00"</P><P>;</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 28 Aug 2013 13:37:46 GMT Haikuo 2013-08-28T13:37:46Z Informats & Formats on Numeric variables https://communities.sas.com/t5/SAS-Programming/Informats-Formats-on-Numeric-variables/m-p/123561#M25357 <HTML><HEAD></HEAD><BODY><P>Hi, I came from BI Admin background and a newbie for SAS.</P><P></P><P>I have a sample Input file</P><P></P><P>Data SampleDataSet;</P><P>Infile 'D:\Samples\SampleDataSet.csv' dlm = ",";</P><P>Informat&nbsp; --- ;</P><P>Type CustID $ Name $ Age Amount;</P><P>Format&nbsp; --- ;</P><P>Run;</P><P></P><P>In raw data set; Amount is in this format: $1000.00, 2500.00, "4200.00", $5000.00, "5400.00".</P><P>Can any please let me know how to use Informat &amp; Format for the numeric variable shown above.</P><P></P><P>Thanks in advance</P><P>Raj</P></BODY></HTML> Wed, 28 Aug 2013 04:28:51 GMT https://communities.sas.com/t5/SAS-Programming/Informats-Formats-on-Numeric-variables/m-p/123561#M25357 raj_sree216 2013-08-28T04:28:51Z Re: Informats & Formats on Numeric variables https://communities.sas.com/t5/SAS-Programming/Informats-Formats-on-Numeric-variables/m-p/123562#M25358 <HTML><HEAD></HEAD><BODY><P>Is this what you are after?</P><P></P><P>data test;</P><P>infile cards dsd;</P><P>informat money comma20.;</P><P>input money;</P><P>cards;</P><P>$1000.00</P><P>2500.00</P><P>"4200.00"</P><P>;</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 28 Aug 2013 13:37:46 GMT https://communities.sas.com/t5/SAS-Programming/Informats-Formats-on-Numeric-variables/m-p/123562#M25358 Haikuo 2013-08-28T13:37:46Z