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.
What about
proc sql;
*Add new record;
insert into have
set col0='Race'
;
quit;
What about
proc sql;
*Add new record;
insert into have
set col0='Race'
;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.