Date:         Thu, 25 May 2006 15:58:52 -0500
Reply-To:     Jiann-Shiun Huang <Jiann-Shiun.Huang@AMERUS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jiann-Shiun Huang <Jiann-Shiun.Huang@AMERUS.COM>
Subject:      Re: make a data set from an empty data?
Comments: To: Ya Huang <ya.huang@AMYLIN.COM>
Content-Type: text/plain; charset=US-ASCII

Ya:

  I believe this is how data step works:  If end of dataset is reached,
the data step ends.  Hence in your case, the data step ends before it
reaches *a='abc';*.

J S Huang
1-515-557-3987
fax 1-515-557-2422

>>> Ya Huang <ya.huang@AMYLIN.COM> 05/25/06 3:52 PM >>>
proc sql;
create table tmplt
(a char(5),
 b char(10),
 c num);

data xx;
 set tmplt;
a='abc';
b='xyz';
d=a||b;
output;
run;

OK, so I have a empty data with the structure I needed created by
proc sql. I then use a data step to fill in the records, and some
new variables. I got an empty data xx, even though I have
the output statement there.

Am I missing some obvious stuff? What should I do to make something
(one record) out of nothing (the original empty data)?

Thanks

Ya