About fengyuwuzu

fengyuwuzu · ‎10-14-2016

Thank you. I got your idea. Right now the order is wrong because DAY8 was ranked the last, but I will try to figure it out.

fengyuwuzu · ‎10-14-2016

have want CYCLE1 DAY1 1011 CYCLE1 DAY8 1012 CYCLE1 DAY15 1013 CYCLE1 DAY22 1014 CYCLE1 DAY29 1015 CYCLE1 DAY36 1016 CYCLE2 DAY1 1021 CYCLE2 DAY8 1022 CYCLE2 DAY15 1023 CYCLE2 DAY22 1024 CYCLE2 DAY29 1025 CYCLE2 DAY36 1026 CYCLE3 DAY1 1031 CYCLE3 DAY8 1032 CYCLE3 DAY15 1033 CYCLE3 DAY22 1034 CYCLE3 DAY29 1035

fengyuwuzu · ‎10-14-2016

that is all the data I have. my code is like this but there are errors. can anyone help me improve the code? data out; set in; i=1; do while (i <10); if i=input(substr(avisit, 6, 1),1.) then do; if 'DAY1' in avisit then avisitn='10'||put(i,1.)||'1'; if 'DAY8' in avisit then avisitn='10'||put(i,1.)||'2'; if 'DAY15' in avisit then avisitn='10'||put(i,1.)||'3'; if 'DAY22' in avisit then avisitn='10'||put(i,1.)||'4'; if 'DAY29' in avisit then avisitn='10'||put(i,1.)||'5'; if 'DAY36' in avisit then avisitn='10'||put(i,1.)||'6'; end; i=i+1; end; run

fengyuwuzu · ‎10-14-2016

I have data with the right column, "CYCLE1 DAY1" etc, and want to recode into the left column. I am thinking about a do loop but not sure how to do it. Can anyone help? Thanks 1011 CYCLE1 DAY1 1012 CYCLE1 DAY8 1013 CYCLE1 DAY15 1014 CYCLE1 DAY22 1015 CYCLE1 DAY29 1016 CYCLE1 DAY36 1021 CYCLE2 DAY1 1022 CYCLE2 DAY8 1023 CYCLE2 DAY15 1024 CYCLE2 DAY22 1025 CYCLE2 DAY29 1026 CYCLE2 DAY36 1031 CYCLE3 DAY1 1032 CYCLE3 DAY8 1033 CYCLE3 DAY15 1034 CYCLE3 DAY22 1035 CYCLE3 DAY29 1041 CYCLE4 DAY1 1042 CYCLE4 DAY8 1043 CYCLE4 DAY15 1044 CYCLE4 DAY22 1045 CYCLE4 DAY29 1051 CYCLE5 DAY1 1053 CYCLE5 DAY15 1055 CYCLE5 DAY29 1051 CYCLE6 DAY1 1063 CYCLE6 DAY15 1065 CYCLE6 DAY29 1071 CYCLE7 DAY1 1073 CYCLE7 DAY15 1075 CYCLE7 DAY29 1081 CYCLE8 DAY1 1083 CYCLE8 DAY15 1085 CYCLE8 DAY29 1091 CYCLE9 DAY1 1093 CYCLE9 DAY15 1095 CYCLE9 DAY29 1101 CYCLE10 DAY1 1103 CYCLE10 DAY15 1105 CYCLE10 DAY29

fengyuwuzu · ‎10-08-2016

Hi Reeza I have another question. in your code, the values of Y are "A", ... "F". In my data, the values of the doses are "7.5 mg/26-37Kg", etc. So, do I have to first convert my data to a format with Doses values of "A", "B", ... "F" to use this format to control output order?

fengyuwuzu · ‎10-08-2016

Right. You are right I did not run the format correctly.

fengyuwuzu · ‎10-08-2016

I used your code, which works. But in the output it is the "A"...."D" that are listed in order, not the actual doses. Is there a way to replace the "A" to "D" with the actual doses? Thanks

fengyuwuzu · ‎09-30-2016

I want to list the output with 7.5 dose as the first one, but using the following code I still got 7.5 dose as the last one. What is wrong here? PROC FORMAT ; VALUE $ trtfmt 'A'='7.5 mg/26-37Kg ' 'B'='10.0 mg/38-50Kg ' 'C'='12.5 mg/51-62Kg ' 'D'='15.0 mg/63-75Kg ' 'E'='17.5 mg/76-87Kg ' 'F'='20.0 mg/88-111Kg'; RUN; proc freq data=mydata ORDER=FORMATTED; tables trtcat1 * AGEGRP /nocol ; format trtcat1 $trtfmt.; run;

fengyuwuzu · ‎09-27-2016

My start row starting row 9 and names are in row 8. using the code below I got : 1794 namerow=8; ------- 180 1795 datarow=9; ------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. proc import out= work.spadfw datafile= "D:\Projects\Myfile.xlsx" dbms=excel replace; *range="sheet1$"; getnames=yes; namerow=8; datarow=9; *mixed=no; *scantext=yes; *usedate=yes; *scantime=yes; RUN; Any hints? Thanks in advance.

fengyuwuzu · ‎09-27-2016

I have data like below : ID visit m1 m2 m3 m4 1 week1 10 1 week1 13 1 week1 15 1 week1 14 2 week2 12 2 week2 11 2 week2 14 2 week2 13 3 week3 13 3 week3 10 3 week3 11 3 week3 12 And I want to have data like : ID visit m1 m2 m3 m4 1 week1 10 13 15 14 2 week2 12 11 14 13 3 week3 13 10 11 12 One way is to output 4 data for m1, m2, m3 and m4 and then merge. I wonder if there is a simpler way to do it? Thanks

fengyuwuzu · ‎09-22-2016

Thank you, both of you. Both worked.

fengyuwuzu · ‎09-22-2016

I have data as below: ID visit measure Measure_Type 1 1 12 A 2 1 13 A 2 2 14 A 3 1 15 A 1 1 12 B 2 1 13 B 2 2 14 B 3 1 15 B 1 1 12 C 2 1 13 C 2 2 14 C 3 1 15 C The ID 2 has two visits, and I only want to select the second visit and delete the first visit. I tried with the following code but it does not work: data want; set have; by measure_type descending visit id; if first.id; run; any hints? Thanks

fengyuwuzu · ‎09-01-2016

proc sql; create table new_sample as select a.* from total_sample as a, selected_3000 where a.ID in (select ID from selected_3000 ); quit; Total_sample has 79 million data rows, from 79,000 unique IDs. File size 90G. selected_3000 only has 3000 rows with 3000 unique IDs. Now I want to select those whose IDs are in selected_3000 from the total_sample, using the above proc sql code. However, it generated a huge file >200G and I had to terminate the procedure. I checked the output huge file and found the same row was repeated so many times. What could be the problem in this proc sql code?

fengyuwuzu · ‎09-01-2016

The "outall" option is really great. I was thinking to merge back to create such an indicator variable.

fengyuwuzu · ‎08-31-2016

I need to select 3000 cases from about 63000 cases, by stratefying 3 variables: age: continuous. what to have similar mean/std in the selected 3000 and the total sample. gender: binary. want to have similar percentages in the selected 3000 and in the total sample location: binary. two levels. what to have similar percentage in selected 3000 and in the total. I am not sure if the following code is right or not. Can I use both categorical and numeric variables for strata ? proc surveyselect data = total_sample out = selected_3000 method = srs n=3000 seed = 9876; strata gender age location; run;

Online Status	Offline
Date Last Visited	‎08-14-2024 10:40 PM

calculated estimated survival rate at a certain time point (say, 18 mo...

Stratified analysis in non ITT population

Re: Proc import: how to add back blank values due to the same values a...

Proc import: how to add back blank values due to the same values as pr...

Re: Puzzled: Hazard ratio is 0 when both arms have events

Puzzled: Hazard ratio is 0 when both arms have events

Re: median survival not reached in proc lifetest when there are only 2...

Re: median survival not reached in proc lifetest when there are only 2...

Re: median survival not reached in proc lifetest when there are only 2...

median survival not reached in proc lifetest when there are only 2 pat...

Re: count events in one dataset between two visits in another dataset

Re: count events in one dataset between two visits in another dataset

Re: count events in one dataset between two visits in another dataset

Re: separate a string into two variables

Re: separate a string into two variables

ERROR: Some character data was lost during transcoding

hide the time and date on the rtf generated by ODS

proc sort and dupout: how to get the pairs of duplicates

converting numeric to character by put statement: how to avoid "." for...

Re: LOCF with visit missing in the data set

Re: how to code this efficiently?

Re: how to code this efficiently?

Re: how to code this efficiently?

how to code this efficiently?

Re: proc freq with format to re-order output

Re: proc freq with format to re-order output

Re: proc freq with format to re-order output

proc freq with format to re-order output

import excel from , skipping first 7 lines

change data format from multiple rows per id to one row per id

Re: Retaining only last patient visit data

Retaining only last patient visit data

Anything wrong with this simple proc sql code?

Re: random selecting cases by stratifying 3 variables (2 binary and on...

random selecting cases by stratifying 3 variables (2 binary and one co...