Obs   drug      placebo     total   col0                 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. ... View more

Hi Guys,    using the code* below I obtain this:                             Obs race     sex  count                              1 black   female  1                              2 black   male    2                              3 latin   female  1                              4 latin   male    2                              5 oriental male    1 code*: ------------------------------------------------------- data have; length  subno 4 race $10 sex $10; input subno race  sex ; datalines; 1  black male 2  black female 3  latin male 4 latin male 5 black male 6 latin female 7 oriental male ; run; proc sql; create table race as   select race,  sex                   ,count(distinct subno) as count     from have     group by race, sex; quit; proc print data=race; run; ------------------------------------------------------ Anyone can help me to get the final table below using proc sql?....note: (please I know how to get the final table using proc transpose, but I would like to know how to do it with proc sql), thanks. Final table: race            male   female     total black              2      1             3 latin                2      1             3      oriental           1       0             1 V. ... View more

Hi, I would like to summary the variable treatment: drug, placebo of the next dataset have: subjid  treatment 1             drug 2             placebo 3              drug 4            drug 5           placebo using this syntax: proc sql; select treatment, count (distinct subjid) as count from have; quit; I will get : placebo   2 drug       3 But my idea is using proc sql , i will keep these values 2, and 3 in diffrent macrovariables using proc sql with the option (into), but i need the syntax to do it. Any help: Thanks in advance. V variabels ... View more

Hi to everyone, in order to understand the way to mix different kind of charater data, numerical data, and informat data as date, this input is reading correctly, but I would like someone can explain me the role of the colon and ampersand in this code, necessary to make it works. Thanks, V. data new3; format dat date9. date mmddyy10.; input obs subjid pp ae: & $14. dat: date9. trt: $10. date: mmddyy10. treatment $10.; datalines;   1       1000000134     0  headache       23jan63       placebo   10/10/2005  drug   1       1000000234     0  lung left pain       23jan34       placebo   10/10/1995  drug   1       1000000134     0  headache       23jan63       placebo   10/10/2005  drug ; run; ... View more

Hi everyone, how can I remove a) the first leading zero: 0 b) the two leading zeros: 00 of the character variable subjid: data new; input subjid $; datalines; x-001 x-0023 x-0056 x-00123 x-00234 x-00255 ; Thanks in advance. V. ... View more

Hi guys, can anyone help me to use the function verify to extract the number for the character variable code? data new; input code $; datalines; agsadg1 iuyasd2 flgdfe3 gttret4 hgtmgt5 gftfrg6 frgdf11 ewtdf54 ltrgr230 tyuf546 ffr1345 fgh5890 lko9999 ; run; the idea is, generate a variable coden with  the values: 1 2 3 4 5 6 11 54 230 546 1345 5890 9999 and I would like to use the function verify to do this. Thanks in advance.                                     V ... View more