The retain statement holds a value/variable over to the next observation of processing: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214163.htm The docs have examples and such like. ... View more

@navinrraj wrote: but 12 prints entire column i want print 12 value for paritcular row only balls=compress('12(','('); is not working for tat balls 12 12 12 12 12 12 its print like this HOW are you "printing"? "Particular row" how do you identify the "particular row". There is nothing in your (very incomplete) code that restricts this to any specific row. ... View more

"What the extension of excel file" - File extensions tell the operating system and other tools what the file is.  It doesn't necessarily need to match the file type, however it really isn't very good if it doesn't.  Excel has a few different file extensions, XLS is the old binary file format, XLSX is the new Open Office file format.  CSV is not an Excel file format, it is plain text with data delimited by comma's, Excel can however read an parse this file type. "How convert to sas" - this depends on several factors.  What exactly is the file type you are trying to import, is it a CSV file?   "And dbms value" - DBMS value indicates to SAS what type of file you are trying to import.  Again, I do not know what you have, is it a CSV file, is it an XLSX file?   If its a csv file then: proc import datafile="/home/naveence0/food2.csv" out=indata dbms=csv replace; run; ... View more

You can simplify your code by using informats with a colon, and formatting price in the same step: input items :$20. price description :$85. calorieskl; format price dollar10.2; The length statements can now be omitted. ... View more