About J_hoon

J_hoon · ‎05-21-2019

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.

J_hoon · ‎04-14-2019

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!!!

J_hoon · ‎03-20-2019

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~~

J_hoon · ‎03-14-2019

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??

J_hoon · ‎03-13-2019

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.

J_hoon · ‎03-12-2019

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!

J_hoon · ‎03-06-2019

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!!!!

Online Status	Offline
Date Last Visited	‎06-10-2019 07:08 AM

Don't want to cut a table in ods rft

merging data in proc sql

remove period in numeric format

How to add superscript in sas?

Same ID has same data use do loop

ods pdf

ods rtf, MS word table