About lc7033907

lc7033907 · ‎05-30-2021

@Ksharp thanks. I understand now.

lc7033907 · ‎05-29-2021

@Ksharp I understand your ideas. But I found your path_in and path_out are exactly the same, so I get a little bit confused. As I stated libraries for xpt files and sas datasets that I want to save, should I put %let path_in=C:\statdata\onco\datasets\sdtmdata\validation\xpt_new; %let path_out=C:\statdata\onco\datasets\sdtmdata\output; Thanks.

lc7033907 · ‎05-29-2021

@Sajid01 Thanks. It's really helpful.

lc7033907 · ‎05-28-2021

Hello all, I have a question about converting xpt files to sas datasets. I have a folder containing a couple of xpt files. now I want to convert them to sas datasets. Of course I can use proc copy inlib= outlib= ; run; to convert one by one. However, if I have hundreds of xpt files, it's obviously time-consuming. So I am thinking to do this job with a macro or a loop. But I don't know how to do it. Any suggestion is welcome. Thanks. xpt files saved under libname xfolder "C:\statdata\onco\datasets\sdtmdata\validation\xpt_new"; output datasets want to save under libname sfolder "C:\statdata\onco\datasets\sdtmdata\output";

lc7033907 · ‎04-23-2021

@Reeza Thanks for your sharing. I searched them online several times, but never got specific definitions. Maybe the reason is what you explained. Thanks a lot.

lc7033907 · ‎04-23-2021

Hello all, I came across utility macros and standard macros when reading pharmaceutical papers. But I never heard of them before. Any share is welcome. Thanks.

lc7033907 · ‎03-13-2021

Thank you so much @PaigeMiller . Your code is exactly the same as what I did on my own. Since I got the same values on SE, I thought I was wrong. Thank you once again.

lc7033907 · ‎03-12-2021

@PaigeMiller Thank you. Now let me modify my real problem and I hope to get some hints. The following is data that I have data have; input subjid $2. Avisitc $3-10 trt $ CHG; datalines; 1 week 12 A 3.7 1 week 16 A 4.8 2 week 12 B -2 2 week 16 B -2.2 3 week 12 A -3 3 week 16 A -2.5 4 week 12 B 2.8 4 week 16 B 3.0 5 week 12 A 7.0 5 week 16 A 7.1 6 week 12 B 6.4 6 week 16 B 6.8 7 week 12 A -5 7 week 16 A -5.4 8 week 12 B 10 8 week 16 B 11 9 week 12 B -6.4 9 week 16 B -7.1 10 week 12 A 6.3 10 week 16 A 6.9 ; I want to get a report in the following: Now I have trouble on the last column, because I never use proc mixed before. Any hints are appreciated. Thanks.

lc7033907 · ‎03-12-2021

Hi @PaigeMiller , anyway to correct it, because I guess those numbers should not be equal. Thanks.

lc7033907 · ‎03-12-2021

Hello all, I want to use sashelp.class as an example to get mean and SE (standard error) values of height by proc mixed and I like to save these values in a dataset. I found all the SE values are the exactly the same. This is my first time to touch proc mixed, so I really get confused. Anyone can give me some explanation? Thanks. proc mixed data=sashelp.class(where=(Age in (14,15))); class Sex Age; model Height = Sex Age; lsmeans Sex Age; run; Here is output:

lc7033907 · ‎03-08-2021

Thank you so much Reeza. I will try now.

lc7033907 · ‎03-08-2021

Hello all, I am learning how to graph Kaplan-Meier Curve. I used sashelp.bmt as an example to practice. I know how to get the graph with proc lifetest or proc sgplot. But now I want to add stats (Median time, log-rank p-value, 95% CI) on the graph, putting them on the topright. I appreciate any suggestions. PS.: I like legend arranged in the following. ALL AML-Low Risk AML-High Risk Median time XXX XXX XXX 95% CI log-rank P-value

lc7033907 · ‎02-21-2021

Thank you so much, KurtBremser. I'll try your both ways.

lc7033907 · ‎02-21-2021

Hello everyone, I have a question about executing macro which is stored in an excel file. For example, here is my macro: %macro ttl_fnt; title1 "Table 1" ; title2 "for height and weight of each group"; footnote1 j=left "Study program 1" j=right "Page 1 of 10"; footnote2 j=left "Version &sysver" j=right "Date: &sysdate9"; %mend ttl_fnt; It's saved in excel and then I want to execute it in programming with base SAS. How to do it? I don't want to just put titles and footnotes in my sas, because I have several projects with same titles and footnotes except title1. Any suggestion is appreciated.

lc7033907 · ‎01-26-2021

Yes, you are right. I made a stupid error. I thought x1 and x2 are those numbers in the above, but actually they are returned values. Thanks.

Online Status	Offline
Date Last Visited	‎06-08-2021 06:07 PM

Re: convert xpt files to sas datasets

Re: convert xpt files to sas datasets

Re: convert xpt files to sas datasets

convert xpt files to sas datasets

Re: utility macro and standard maco

utility macro and standard maco

Re: proc mixed to get mean and SE

Re: proc mixed to get mean and SE

Re: proc mixed to get mean and SE

proc mixed to get mean and SE

Re: Kaplan-Meier Curve

Re: macro parameter

Re: macro parameter

Re: macro parameter

Re: macro parameter

Re: convert xpt files to sas datasets

Re: convert xpt files to sas datasets

Re: convert xpt files to sas datasets

convert xpt files to sas datasets

Re: utility macro and standard maco

utility macro and standard maco

Re: proc mixed to get mean and SE

Re: proc mixed to get mean and SE

Re: proc mixed to get mean and SE

proc mixed to get mean and SE

Re: Kaplan-Meier Curve

Kaplan-Meier Curve

Re: write a macro in excel and execute it in base sas

write a macro in excel and execute it in base sas

Re: NMISS function