Date:         Wed, 8 Feb 2006 02:24:29 -0800
Reply-To:     Ganesh <ganesh.makireddy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ganesh <ganesh.makireddy@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Replacing variable values with proc sql
Comments: To: sas-l@uga.edu
In-Reply-To:  <200602080816.k186aBcS010531@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Hi Hadassa Brunschwig.

Here is the SQL code for replacing data


data test;
infile cards missover;
input id name$ city$ ;
cards;
1 A YN
2 B BK
3 C IN
4 D
5 Y   ;RUN;

proc sql;
create table test as
select id, name, coalesce(city,'No Info')
 from test;
quit;