Thanks everyone for your responses.   To give a background, i am doing a data clean up of the columns - Customer complaint and Status. When there is a word speed in the customer complaint i would want to mark it as speed issues and when there is poor customer service i would want to mark it as service issue etc.  rest of the complaints would be miscellaneous.   Other than the SQL method is there anyother way that i can replace the data in the file. Attaching the file for your reference and the working SQL query.    FILENAME REFFILE "/home/u44638328/Comcast.csv"; proc import datafile=REFFILE DBMS=CSV OUT=work.Comcast replace; getnames=YES; run; proc sql; select * , case when customer_complaint like '%Speed%' then 'Speed' when customer_complaint like '%speed%' then 'Speed' when customer_complaint like '%Service%' then 'Service' when customer_complaint like '%service%' then 'Service' when customer_complaint like '%Data%' then 'Data' when customer_complaint like '%data%' then 'Data' when customer_complaint like '%billing%' then 'Billing' when customer_complaint like '%Billing%' then 'Billing' when customer_complaint like '%Price%' then 'Pric' when customer_complaint like '%Outage%' then 'Outage' when customer_complaint like '%outage%' then 'Outage' else 'Miscellaneous' end as Customer_Complaint1, Case when status like '%end%' then 'Open' when status like '%ved%' then 'Closed' when status like 'Closed' then 'Closed' when status like 'Open' then 'Open' end as Status_1 from work.comcast; quit;     ... View more

Thanks Paige . The solution has been arrived. However would like to know if there is an alternate way of replacing the data in the file other than the sql method.  ... View more

Thank you Kruger. That helped a lot . Am able to update the values in both the columns.   However one more doubt, is there any other alternate way to update the values in the columns when importing or reading the file using replace ?         ... View more