Help using Base SAS procedures

proc sql insert new record

Accepted Solution Solved
Reply
Super Contributor
Posts: 301
Accepted Solution

proc sql insert new record

                1           14.76% 00.00% 12.50%Latin
                2 13   61.90%11   57.89%24   60.00%Caucasian
                7   33.33% 7   36.84%14   35.00%Black
                00.00% 15.26% 12.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.


Accepted Solutions
Solution
‎06-19-2012 11:59 AM
Respected Advisor
Posts: 4,173

Re: proc sql insert new record

What about

proc sql;

*Add new record;

insert into have

set col0='Race'

;

quit;

View solution in original post


All Replies
Solution
‎06-19-2012 11:59 AM
Respected Advisor
Posts: 4,173

Re: proc sql insert new record

What about

proc sql;

*Add new record;

insert into have

set col0='Race'

;

quit;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 159 views
  • 0 likes
  • 2 in conversation