Supplier City Item Category Month Cost Revenue Unit Price Units Available Units Sold Bantam Books Annapolis Art & Architecture Jan $38,136 $47,760 $105.00 655 454 Bantam Books Annapolis Art & Architecture Feb $11,919 $56,785 $54.00 429 388 Bantam Books Annapolis Art & Architecture Mar $1,24,897 $98,586` $98.00 89 45 Hi All, I have an excel csv file, which has 9 variables and some 24 observations for each variable. The variables are in order they appear: 1. Supplier 2. City 3. Item Category 4. Month 5. Cost 6. Revenue 7. Unit Price 8. Units Available 9. Units Sold. The only confusion is:  Cost and Revenue has $ associated with it ($38,000 for example) and Unit Price as $105.00 . Not sure, how do I convert this to Numeric format. So, I wrote a code for this as: data get_data; infile " file location of the excel where it is located"; Length Supplier $20. City $20.  Item Category $20.; Input Supplier $ City $ Item Category $ Month $ Cost $ Revenue $ Unit Price $ Units Available Units Sold; numeric=input(Cost, 8.); numeric=input(Revenue, 10.); numeric=input(Unit Price, 8.); proc print; run; It gives an error for this code and the values are not read properly into SAS . It says no result to display. Please assist me in writing the right code. Regards, Mohammed Please assist ... View more