Hello,   First, I want to bring the last day of the month as format of YYYYMMDD (Example : 20151130) but it should also be previous month of the current date. After that, I need to bring the week number of the year. To Illustrate; I should see the macro as ‘201545’,’201546’,201547’,’201548’. Is there anyone who can help me write the macros which I mentioned (above).   Here is my tries;   %let P1_EOM_YYYYMMDD      = %substr(%sysfunc(intnx(month,&today,-1,end),yymmddn8.),1,8); %put &P1_EOM_YYYYMMDD ;   http://support.sas.com/kb/24/619.html   My desired macro result should be -> %put &LastMonth = 20151231 %put &WeeksOfLastMonth = ‘201549’,’20150’,201551’,’201552’,2015532'   Thank you   ... View more

Hello everyone,   I’m on a project now which is related to pharmaceutical industry. I’m trying to change the legend label of the PROC LIFETEST procedure’s graph result. As you can see the following image, the legend labels seem as Kras=-1 Kras=0 Kras=1 however I need to see the reports as  Unknown(Kras=-1), Negative(Kras=0)  and Positive(Kras=1). I prepared a sample data set that does not express anything and I’m sharing with you that sample data set as below. How can I see the legend label’s as Unknown , Negative and Positive. Does anybody can lead me, please ?   DATA Have; Length AVAL 8 KRAS 8; Infile Datalines Missover; Input AVAL KRAS ; Datalines; 80 1 34 1 391 1 221 0 362 0 219 0 113 0 48 1 105 1 18 1 54 1 333 1 172 -1 235 0 81 0 ; Run; PROC LIFETEST DATA=Have ALPHA=0.05 METHOD=LIFE INTERVALS= 30 60 90 120 150 180 PLOTS(ONLY)=SURVIVAL ( STRATA=UNPACK );; STRATA KRAS; TIME AVAL; RUN;       Thank you. ... View more

Hello everyone,   I'm trying to sort the variable ReferenceID. This variable includes both character and numeric datas. Type of ReferenceID is character. When I sort this variable , double-digit values come before one-digit values. I would like to sort this variable according to numeric values. I shared a basic data as below and desired output. I'm not sure is it possible. Does anybody has knowledge about this case ?    Data Have; Length ReferenceID $ 10; Infile Datalines Missover; Input ReferenceID; Datalines; Tur1 Tur2 Tur10 Tur11 Tur5 Tur6 Tur9 Tur14 Tur15 Tur7 Tur8 Tur12 Tur13 Tur3 Tur4 ; Run; Proc Sort Data=Have; By ReferenceID; Run; Thank you. ... View more

Hello everyone,   I created a sample data set and code as below. If I reach my aim , the following code can meet my requirement. I prepared a canard score calculation. My main question is how can I multiplex the Score variable for each Questionnaire variables. I shared the desired output as below. I also wonder , is there any other methods which is more easier to get &Mylist's macro without any Transpose step. If you find out more shorter methods on my code, could you tell me and share me the shorter methods, please ? And let's move over the my sample,please !   DATA Have; LENGTH ID $ 15 Questionnaire1 8 Questionnaire2 8 Questionnaire3 8 Value 8; INFILE DATALINES MISSOVER; INPUT ID Questionnaire1 Questionnaire2 Questionnaire3 Value; DATALINES; TUR1 7 6 7 2 TUR5 9 4 3 3 TUR10 8 3 9 1 ; RUN; /*I did this TRANSPOSE step because I need to take all Questionnaire variables in one macro variable Is there any shorter method ???*/ PROC TRANSPOSE DATA=Have OUT=Intermediate Name=Variable; ID ID; VAR Questionnaire1 Questionnaire2 Questionnaire3; RUN; QUIT; PROC SQL NOPRINT; SELECT Variable INTO : Mylist Separated By ' ' FROM Intermediate; QUIT; %PUT &Mylist; %LET Word_Cnt=%SYSFUNC(countw(&Mylist)); %PUT &Word_Cnt; /*My purpose is to multiplex to Score variable for each Questionnaire variables*/ %MACRO Have(Var); PROC SQL; CREATE TABLE Want(DROP=Sum&Var.) AS SELECT *, SUM(&Var) AS Sum&Var., Calculated Sum&Var. *Value AS Score FROM Have; QUIT; %MEND Have; %MACRO Loop; %DO i=1 %TO &Word_Cnt; %Have(%scan(&Mylist.,&i.,%STR( )));; %END; %MEND Loop; %Loop; ... View more