Thank you so much this worked! I am also facing another issue if you could advise. I have imported the excel sheet that i have, which consists of these fields . Here the discounted price shows as 176.63 However, in SAS it is different for some values - for example the same value is showing as Rs. 177663.00. It has not taken into account the 176.63. This is is the code i used - which includes compressing it to remove the rupee sign, changing it from char to num. data Amazon.Products_mod; set Amazon.Products_Nodup; A_Price= input(compress(actual_price, , 'kd'), comma10.); put "Actual Price (numeric):" A_Price comma10.; format A_Price currency_fmt.; D_Price= input(compress(discounted_price, , 'kd'), comma12.); put "Discounted Price (numeric):" D_Price comma12.; format D_Price currency_fmt.; rating_count_cmp = compress(rating_count); rating_count_new = input(rating_count_cmp, comma12.); * Dropping irrelevant values or old values that have been converted and replaced; drop discounted_price rating_count_cmp rating_count img_link product_link actual_price; run; * including the INR sign; proc format; picture currency_fmt (round) low-high = '₹' 00000009.00 (prefix='₹'); run; Any suggestion on what can be done here and how i can get the right number + a comma for ease of readability.
... View more