proc sql insert new record

[michtka]

	1	1	4.76%	0	0.00%	1	2.50%	Latin
	2	13   61.90%	11   57.89%	24   60.00%	Caucasian
	3	7   33.33%	7   36.84%	14   35.00%	Black
	4	0	0.00%	1	5.26%	1	2.50%	Asian

Hi guys, sorry for the mess of the table have, but i am interested in the last variable (col0) with the value (Latin, Cauc. Black and Asian), and

I am interesting to add a new record heading this table as:

col0='Race' , drug= ' ' , placebo=' ', total=' '

I try the next syntax using INSERT in proc sql (I want to do it in proc qsl) but it doesnt work...any help?

proc sql;

*Add new record;

insert into have

set col0='Race',

Drug=' ',

Placebo=' ',

from have ;

quit;

Thanks.

[Patrick · Accepted solution]

What about

proc sql;

*Add new record;

insert into have

set col0='Race'

;

quit;