Thank you very much! I forgot I had the quotes in the macro expression - too much staring at code..! 😃 ... View more

To deal with blanks in values, you either need fixed columns, or enclose the fields containing blanks in quotes, or use a field separator other than a blank (eg .csv file with commas as separator). Everything else needs lots of programming effort to determine which "words" belong into one column. @ramya_sahu wrote:   Thanks. for below file format is it possible?   ID Orderdate Model Quantity 287 15OCT03 Delta Breeze 15 287 15OCT03 Santa Ana 15 274 16OCT03 Jet Stream 1 174 17OCT03 Santa Ana 20 174 17OCT03 Nor'easter 5 174 17OCT03 Scirocco 1 347 18OCT03 Mistral 1 287 21OCT03 Delta Breeze 30 287 21OCT03 Santa Ana 25       ... View more

HI Team, As per Arthur's solutions the below code will fetch what i want /*Collapse the modified data*/ proc summary data=need nway;   var amount;   class pol_id;   output out=want (drop=_:)sum=; run; But the output contains only pol_id and amount variable, I would like to have all the variable Add & Delete the Duplicate records ... View more