About KentaMURANAKA

KentaMURANAKA · ‎08-14-2021

data_null__-san & Tom-san: Thank you for quick reply. I said, this problem might be from the timing at which %PUT subimitted, but it was my mistake. I didn't notice CALL SYMPUTX stored macro variable at only DATA step end (maybe). In my actual case, I had used %DO loops in DATA step, and I wanted to display macro variable at each loop. And this issue occurred. Thanks anyway!

KentaMURANAKA · ‎08-14-2021

Hi, All: I have a question about how to display macro variable value. Example is below. %let val=100; data test; x=50; call symputx("val", x); %put NotUpdated? = &val.; run; %put Updated = &val.; In my actual situation, I want to display updated value to SAS log, before DATA step completed. I think, this problem is caused by the timing at which %PUT statement submitted, but I have no ideas to resolve. Any advice is welcome. Thanks in advance.

KentaMURANAKA · ‎04-22-2021

I do not know what structure your data have, but how about this? data test; length x $200.; input x $; datalines; taro01yamada gonbe02nanashi ; run; data test_1; set test; attrib first last id length=$200.; v=verify(x, "abccdefghijklmnopqrstuvwxyz"); first=substr(x, 1, verify(x, "abccdefghijklmnopqrstuvwxyz")-1); last=substr(substr(x, verify(x, "abccdefghijklmnopqrstuvwxyz")), verify(substr(x, verify(x, "abcdefghijklmnopqrstuvwxyz")), "0123456789")); id=substr(substr(x, verify(x, "abccdefghijklmnopqrstuvwxyz")), 1, verify(substr(x, verify(x, "abcdefghijklmnopqrstuvwxyz")), "0123456789")-1); run;

KentaMURANAKA · ‎10-08-2020

Hi, Kurt-san: Thank you for your advice. Now, I can load "table 1.1-1" data. Thank you!!

KentaMURANAKA · ‎10-08-2020

Hi, there: I am trying to load dataset from excel file, by using LIBNAME XLSX. This excel file "TEST.xlsx" has some sheets, which are named "table 1.1-1", "table11_1", etc. My code is below. %let test=C:\Users\XXXXX\Desktop\XXXXXXXXXX\test.xlsx; %put &test.; libname test xlsx "&test" access=readonly; data test; set test.table11_1; run; data test_; set test.table 1.1-1; run; data test_; set test.'table 1.1-1$'n; run; In library "test", there are something like SAS datasets, "TABLE 1.1-1" & "TABLE11_1". In library "work", I can find SAS dataset "test" with no errors & warnings. But I cannot find "test_" from spreadsheet "table 1.1-1" and SAS says "Syntax error, expecting one of the following ~" or "Couldn't find range or sheet in spreadsheet". I know SAS usually does not allow hypen or blank as data names. I would like to use data in sheet "table 1.1-1" using LIBNAME XLSX. Any advice is welcome. Thank you in advance.

KentaMURANAKA · ‎10-07-2020

Thank you, Reeza. I added following code to template "Stat.Lifetest.Graphics.ProductLimitFailure", and I think solved. DRAWRECTANGLE statement & DRAWTEXT statement (I do not change original label "At Risk", just overlapped rectangle and comment box lol) I have no ideas where to be customized template or ATRISK option in proc LIFETEST. Anyway, thank you!

KentaMURANAKA · ‎10-06-2020

About No.1 question, I deleted STRATA statement and solved. Sorry!! I want your answers about No.2 question.

KentaMURANAKA · ‎10-06-2020

Hello, All: I am trying to create Kaplan-Meier Failure Plot with proc LIFETEST. I have 2 questions about this. No.1 Sample code is below. data bmt; set sashelp.bmt(where=(group eq "AML-Low Risk")); run; options nonumber nodate papersize="A4" orientation=landscape; ods rtf style=journal; ods graphics / noborder; ods select failureplot; ods noproctitle; proc lifetest data=bmt plots=(survival(failure atrisk(maxlen=13))); time t*status(0); strata group; title " "; run; ods rtf close; About the output, I would like to delete 3 default titles, "The SAS System", "The LIFETEST Procedure", and "Stratum 1: Disease Group = AML-Low Risk". As you see my code, I used TITLE statement & ODS NOPROCTITLE, and deleted two, "The SAS System", "The LIFETEST Procedure", but the last one, "Stratum 1:~" is not. Do you have any ideas to delete the last one? No.2 I would like to customize default label, "At Risk", which expresses the label of # of subjects at risk. In order to solve these problems, I refered some papers (Kuhfeld WF, et al. -2014-, Geaty H -2015-, etc.) and tried to customize the template, "Stat.Lifetest.Graphics.ProductLimitFailure", but I have no ideas where should be changed. Thank you in advance.

KentaMURANAKA · ‎09-28-2020

Thank you, Reeza. From your ideas, the last one, I read whole the blog. It was interesitng. I solved my problem using OUTBOX= option in proc BOXPLOT & proc MEANS. Thank you!!

KentaMURANAKA · ‎09-28-2020

Hi, All: I would like to create box-whisker plot and reference dataset, which includes summary statistics for displaying this plot. In proc SGPLOT, are there any options for this objective? or I have to calculate them using other procedure like proc UNIVARIATE? Thank you in advance! (example code is below) data lft; input test $ A B @@; datalines; ALAT 1.05198 0.97755 ASAT 0.78177 0.59554 ALKPH 0.20475 0.20589 BILTOT 0.12868 0.10760 ALAT 1.00211 1.19132 ASAT 1.07368 0.85466 ALKPH 0.69033 0.56213 BILTOT 0.38943 0.50285 ALAT 0.63396 0.53781 ASAT 0.05348 0.14887 ALKPH 0.75340 0.07973 BILTOT 0.87345 0.44291 ALAT 0.70381 0.81970 ASAT 1.03230 0.83068 ALKPH 0.42431 1.05635 BILTOT 0.14320 0.54282 ALAT 0.23767 0.62809 ASAT 1.90154 1.76075 ALKPH 0.41850 0.28345 BILTOT 0.54899 0.32524 ALAT 0.70693 0.89745 ASAT 0.30255 0.47380 ALKPH 0.13230 0.28027 BILTOT 0.81690 0.14692 ALAT 0.12827 0.37964 ASAT 0.80481 0.03603 ALKPH 0.18448 0.53166 BILTOT 1.19420 0.35609 ALAT 0.82422 0.85656 ASAT 0.03430 1.25747 ALKPH 0.21351 0.17765 BILTOT 0.32556 0.49431 ALAT 1.06820 0.28720 ASAT 0.95546 1.11008 ALKPH 0.03092 1.04798 BILTOT 0.57001 0.03822 ALAT 0.23055 0.77542 ASAT 0.10612 1.29305 ALKPH 0.03577 0.10963 BILTOT 0.79160 0.28032 ALAT 0.78603 0.45259 ASAT 0.24872 0.96720 ALKPH 0.50077 0.55558 BILTOT 0.38930 0.03795 ALAT 0.54711 2.20000 ASAT 2.11348 0.77847 ALKPH 0.31640 0.04882 BILTOT 0.12872 0.48268 ALAT 0.78600 0.46686 ASAT 0.24883 0.49811 ALKPH 0.03704 0.25468 BILTOT 0.12923 0.17796 ALAT 0.48393 0.45078 ASAT 1.56288 1.35533 ALKPH 0.43352 0.66135 BILTOT 1.06012 0.85799 ALAT 0.46068 0.25030 ASAT 1.56448 0.52508 ALKPH 1.00876 0.57161 BILTOT 0.44817 0.19389 ALAT 1.06331 0.00000 ASAT 1.38521 0.19008 ALKPH 0.35466 0.61868 BILTOT 1.24180 0.04822 ALAT 0.48065 0.40992 ASAT 1.05618 0.78853 ALKPH 0.19355 0.66358 BILTOT 0.73715 0.09852 ALAT 1.21493 0.64416 ASAT 0.70453 2.51609 ALKPH 0.26489 0.33604 BILTOT 0.72164 0.33025 ALAT 1.04961 0.97218 ASAT 0.32183 1.35889 ALKPH 0.03934 0.41986 BILTOT 0.20788 0.12524 ALAT 0.11145 0.80421 ASAT 0.29223 0.94908 ALKPH 0.00864 0.05148 BILTOT 0.08176 0.00000 ALAT 0.54881 0.48289 ASAT 0.23306 0.33808 ALKPH 0.58716 1.01387 BILTOT 0.73317 0.01936 ALAT 0.70290 0.42668 ASAT 0.60399 1.09609 ALKPH 0.27376 0.00000 BILTOT 0.17014 0.16435 ALAT 0.90385 1.06340 ASAT 0.00000 1.04065 ALKPH 0.19284 0.27968 BILTOT 0.02284 0.10508 ALAT 0.77662 0.27623 ASAT 0.79289 0.78862 ALKPH 0.24560 0.33058 BILTOT 0.44045 0.52485 ALAT 1.15780 0.11335 ASAT 0.96932 0.84560 ALKPH 0.07827 0.29355 BILTOT 0.13112 1.50000 ALAT 0.50103 0.61329 ASAT 1.11541 0.08967 ALKPH 0.74840 0.43341 BILTOT 0.47621 0.85664 ALAT 0.36086 0.50746 ASAT 2.03550 1.30451 ALKPH 0.56854 0.43620 BILTOT 0.09094 1.26472 ALAT 0.95770 0.63754 ASAT 2.03683 1.83280 ALKPH 1.40042 0.12018 BILTOT 0.22545 0.43027 ALAT 0.32817 0.50025 ASAT 2.60000 0.24234 ALKPH 0.13532 0.21778 BILTOT 0.55075 0.48568 ALAT 0.26668 0.45166 ASAT 1.06058 0.83500 ALKPH 0.22807 0.62830 BILTOT 0.46843 0.16910 ALAT 0.28617 0.55219 ASAT 0.30707 0.52809 ALKPH 0.55278 0.04707 BILTOT 0.06412 0.37335 ALAT 0.28907 0.14920 ASAT 0.10258 0.75400 ALKPH 0.00730 0.10016 BILTOT 0.47780 0.23071 ALAT 1.16461 0.92092 ASAT 0.80571 0.22561 ALKPH 0.17983 0.62150 BILTOT 0.53452 0.77714 ALAT 0.05326 0.51731 ASAT 1.09366 1.67147 ALKPH 0.56498 0.30936 BILTOT 0.07047 0.34371 ALAT 1.05258 0.05138 ASAT 0.15650 0.38367 ALKPH 0.09618 0.50434 BILTOT 0.59625 1.44028 ALAT 0.10204 0.33631 ASAT 0.95273 0.15079 ALKPH 0.70621 0.06809 BILTOT 0.37559 0.92632 ALAT 0.76055 0.72907 ASAT 1.36379 0.12393 ALKPH 0.03081 2.00000 BILTOT 0.92652 0.19981 ALAT 0.95481 0.32130 ASAT 0.75320 2.50581 ALKPH 0.23371 1.17739 BILTOT 0.30880 0.22500 ALAT 1.96947 0.05734 ASAT 2.58784 0.21524 ALKPH 0.76119 0.48148 BILTOT 0.25826 0.52166 ALAT 1.03068 0.14734 ASAT 2.44450 0.48403 ALKPH 0.34170 0.34804 ; run; proc transpose data=lft out=lft2(rename=col1=value) name=drug; var a b; by test notsorted; run; title 'Distribution of Maximum Liver Function Test Values by Treatment'; proc sgplot data=lft2; vbox value / category=test group=drug; xaxis label="Treatment"; keylegend / title="Drug Type"; run;

KentaMURANAKA · ‎12-05-2019

Hello, there: I want to generate macro variable, PARAMN1-PARAMN5, and I am trying to convert repeated structure of my code into macro. But can't get macro variables I want. Please let me know if you know why this problem happens and how to resolve. Thank you in advance. data test; do paramn=1 to 5 by 1; do subjid=1 to 5 by 1; output; end; end; run; * Separated SELECT Clause <-- n.p. ; proc sql noprint; select count(distinct subjid) into :_nobs_1 from work.test(where=(paramn eq 1)) ; select count(distinct subjid) into :_nobs_2 from work.test(where=(paramn eq 2)) ; quit; %put &_nobs_1.; %put &_nobs_2.; * in macro <-- Problem!! ; proc sql noprint; %macro gen_nobs(paramn=); select count(distinct subjid) into :_nobs_&paramn. from work.test(where=(paramn eq &paramn.)) ; %mend gen_nobs; %gen_nobs(paramn=1) %gen_nobs(paramn=2) %gen_nobs(paramn=3) %gen_nobs(paramn=4) %gen_nobs(paramn=5) quit; %put &_nobs_1.; %put &_nobs_2.; %put &_nobs_3.; %put &_nobs_4.; %put &_nobs_5.;

KentaMURANAKA · ‎10-17-2019

Hi, KurtBremser-san: I think same as you. I almost always create macro variables in DATA step (or SQL step), so for me, your idea is eye-opener. Thank you !

KentaMURANAKA · ‎10-17-2019

Hi, Shmuel-san: Thank you, I understand!! In summary, KurtBremser-san's idea is..... %macro re(var=, txt=, rep=); %global &var.; %let &var.=; %do i=1 %to &rep.; %let &var.=&&&var. &txt.; %end; %mend re; %re(var=re10, txt=WORD, rep=10) %put &re10.; and Shmuel-san's idea is..... %let txt=%str(WORD ); %macro re(max=); %global re&max.; data _null_; length re $2000.; re=repeat("&txt", &max.-1); call symputx("re&max.", strip(re)); run; %mend re; %re(max=7) %put &re7.; I think both ideas are wonderful. Thank you, Shmuel-san, KurtBremser-san!!

KentaMURANAKA · ‎10-17-2019

Hi, KurtBremser-san: Thank you for your kind advice. I understand now! Regarding to "%let &var.=&&&var.. &txt.", first "&var." means variable name, and second "&&&var.." means, not variable name, it means variable content. Thank you!!

KentaMURANAKA · ‎10-17-2019

Hi, KurtBremser-san: Thank you for reply. Your code worked! Aha! %macro re(var=, txt=, rep=); %global &var.; %let &var.=; %do i=1 %to &rep.; %let &var.=&&&var. &txt.; %end; %mend re; %re(var=re10, txt=WORD, rep=10) %put &re10.; I think three ampersands are important (I do not understand why). Anyway, thank you, KurtBremser-san, Shmuel-san!!

Online Status	Offline
Date Last Visited	‎04-20-2022 01:31 AM

Re: How Can I Display Updated Macro Variable Value, Earlier

How Can I Display Updated Macro Variable Value, Earlier

Re: want to create three variable

Re: How Can I Load Excel Sheet Using LIBNAME XLSX

How Can I Load Excel Sheet Using LIBNAME XLSX

Re: How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

Re: How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

Re: How can I output dataset used to display graph in proc SGPLOT?

How can I output dataset used to display graph in proc SGPLOT?

Re: How to export output from SAS On demand to Excel or word ?

How to export output from SAS On demand to Excel or word ?

Re: Power calculation for proportions

Re: How Can I Display Updated Macro Variable Value, Earlier

Re: How Can I Display Updated Macro Variable Value, Earlier

Re: How can I output dataset used to display graph in proc SGPLOT?

Re: How Can I delete Un-needed Blank in Front of Header when Using PRO...

Re: How Can I Make Header Justified Left Partially by Using PROC REPOR...

Re: Assign unique id

Re: Formatting dataset by start and end dates

Re: How Can I Display Updated Macro Variable Value, Earlier

How Can I Display Updated Macro Variable Value, Earlier

Re: want to create three variable

Re: How Can I Load Excel Sheet Using LIBNAME XLSX

How Can I Load Excel Sheet Using LIBNAME XLSX

Re: How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

Re: How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

How Can I Customize Kaplan-Meier Failure Plot with proc LIFETEST?

Re: How can I output dataset used to display graph in proc SGPLOT?

How can I output dataset used to display graph in proc SGPLOT?

How Can I Generate Macro Variables in proc SQL appropriately?

Re: How Can I Generate MACRO VARIABLE That Includes Same Text Strings ...

Re: How Can I Generate MACRO VARIABLE That Includes Same Text Strings ...

Re: How Can I Generate MACRO VARIABLE That Includes Same Text Strings ...

Re: How Can I Generate MACRO VARIABLE That Includes Same Text Strings ...