06-10-2019
J_hoon
Calcite | Level 5
Member since
03-06-2019
- 7 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by J_hoon
Subject Views Posted 551 05-21-2019 09:31 PM 1135 04-14-2019 09:23 PM 4621 03-20-2019 03:24 AM 805 03-14-2019 08:39 PM 621 03-13-2019 04:21 AM 1221 03-12-2019 03:47 AM 515 03-06-2019 03:27 AM -
Activity Feed for J_hoon
- Posted Don't want to cut a table in ods rft on SAS Programming. 05-21-2019 09:31 PM
- Posted merging data in proc sql on SAS Programming. 04-14-2019 09:23 PM
- Posted remove period in numeric format on SAS Programming. 03-20-2019 03:24 AM
- Posted How to add superscript in sas? on SAS Programming. 03-14-2019 08:39 PM
- Posted Same ID has same data use do loop on SAS Programming. 03-13-2019 04:21 AM
- Posted ods pdf on SAS Data Management. 03-12-2019 03:47 AM
- Posted ods rtf, MS word table on New SAS User. 03-06-2019 03:27 AM
05-21-2019
09:31 PM
Hi there. I'm create tables using proc report, and extract it for ods rtf. But, When I use cellheight= option in style(column), the table was cut. Like this !! this is a part of my code. options orientation=landscape;
ods listing close ;
ods escapechar='^';
ods rtf file="&Save\Table.rtf"
style=journal BODYTITLE STARTPAGE=YES;
title1 font='Times new roman' height=12pt "Table";
title2 font='Times new roman' height=12pt "Population: Safety Analysis Set";
proc report data=final ls=200 nowd headline headskip formchar (2)="_" spacing=1 split='|' missing out=out
style(report)=[outputWidth=100%]
style(header column lines)=[vjust=c fontsize=10pt font_face='Times New Roman' color=black]
style(header) =[just=c font_weight=medium cellheight=0.97cm font_face='Times New Roman' font_style= ROMAN bordertopcolor=black borderbottomcolor=black bordertopwidth=0.5pt borderbottomwidth=0.5pt background=#BFBFBF]
style(column) =[just=c cellheight=0.6cm]; How can I solve this Problem??? Please, Answer Me 🙂 Thank you.
... View more
04-14-2019
09:23 PM
Hi I have some problem in proc sql when I merge two data sets. test1 test2 When I merge these two data sets, I want this data set res (This result made by merge options in DATA) But Using proc sql, It print wrong data set. Wrong res (This result made by proc sql) This is my proc sql codes. data test1;
input id$ id2 var1 var2;
cards;
A01 12 221 42
A02 15 947 79
A02 15 837 19
A03 21 217 12
A04 23 612 79
A04 23 182 25
A04 23 352 81
A05 30 797 42
;
run;
/* missing이 있는 data set */
data test2;
input id$ id2 var3$ var4;
cards;
A01 12 QP 96
A02 15 IM 81
A02 15 CB 81
A03 21 NR 71
A04 23 WV .
A04 23 DO .
A04 23 GV .
A05 30 MS .
;
run;
proc sql noprint;
create table All1_2 as
select *
from test1, test2
where test1.id=test2.id and test1.id2=test2.id2;
quit; Please help me!!!
... View more
03-20-2019
03:24 AM
Hello When I coding, I have problem. I load excel file in sas. When I load excel file, the data set present period (.) in blank cell. But I want to remove this period. How can I remove period in numeric format?? Please, Help me. Everyone~~
... View more
03-14-2019
08:39 PM
Hi, everybody. I want to add superscript in label. so, I wrote code like this label CBC_RBC='RBC (10^{super 6}/mm³)'; but superscript dose not apply. What should I do??
... View more
03-13-2019
04:21 AM
Hi I want to fill the data. The same IDs have the same value. For example, See under table. I want to fill 12th row in Dose Group '10 mg' using do loop becaues, 11th row and 12th row are same Subject Number. Likewise, 13th row and 14th row, 15th row and 16th row has same value. How can I do that? Please help me.
... View more
03-12-2019
03:47 AM
Hi, I have one question. I using ods pdf for save my data set. But, It has problem. My data has many columns, so pdf file show two pages. Not one pages. Then, I want to fix my first column for second page. like this pdf view <Now pdf file> ID Age Weight Height ...... <- 1st page 1 15 157 58 .......... . . BMI ..... <- 2nd page 23 <I want this pdf file> ID Age Weight Height ...... <- 1st page 1 15 157 58 .......... . . ID BMI ..... <- 2nd page 1 23 How do I solve this problem? please Help Me!
... View more
03-06-2019
03:27 AM
Hello! everybody!! I have one question. I make MS word table, using ods rtf . But my data set have many columns, so the table of MS word is the table divided two!!! Like this It does not matter if the letter is small. Just want to make the table one!!! Please, Help me!!!!
... View more