About desireatem

desireatem · ‎01-16-2014

Thanks .This is what I have: %macro pat(patt=); %do pt=1 %to &patt; data Pattern_&pt; age=0; output; run; %end; %mend pat; %MACRO DO_BRANCH(replicates=); %do u=1 %to &replicates; proc surveyselect data=new method = urs sampsize = 141 OUTHITS reps=1 seed=1234100 out=new_&u; run; %pat(patt=2); ods trace on /listing; ods graphics on; ods output ParameterEstimates=CPHH_&u; proc phreg data=new_&u ; model monset*obs(0)=age; *baseline out=survs survival= survival; baseline covariates=Pattern_&pt out=survs_&u survival= survival; run; CODES>>>>>>> %end; %MEND DO_BRANCH; This does not work %DO_BRANCH(replicates=2);

desireatem · ‎01-16-2014

%let pt=pt; %macro pat(patt=); %do &pt=1 %to &patt; /*** I NEED THE BASELINE COVARIATE FOR AGE=0, So for each data below new_1, new_2, I want the first to set the covariates=Pattern_1, covariates=Pattern_2*/ data Pattern_&pt; age=0; output; run; %end; %mend pat; %MACRO DO_BRANCH(replicates=); %do u=1 %to &replicates; proc surveyselect data=new method = urs sampsize = 141 OUTHITS reps=1 seed=1234100 out=new_&u; run; %pat(patt=2); ods trace on /listing; ods graphics on; ods output ParameterEstimates=CPHH_&u; proc phreg data=new_&u ; model monset*obs(0)=age; *baseline out=survs survival= survival; baseline covariates=Pattern_&pt out=survs_&u survival= survival; /* THe issue is that SAS doesnot seem to understand that I want covariates=pattern_1 when running the data set new_1 and covariates=pattern_2 for new_2*/ run; ods trace off; %end; %MEND DO_BRANCH; %DO_BRANCH(repli cates=2);

desireatem · ‎01-16-2014

Thanks; I ran the code but surveyselect created just new_1 and no data from new_2 to new_20 I ran the code: %MACRO DO_BRANCH; %do u=1 %to 20; proc surveyselect data=test method = urs sampsize = 141 OUTHITS reps=1 seed=1234100 out=new_&u; run; CODES..... %end; %MEND DO_BRANCH; %DO_BRANCH;

desireatem · ‎01-16-2014

I put it in a macro it runs but no data is created. The data set test is real data that I want to do random sample with replacement. I can not use the option in proc surveyselec that does not require macro because of some computations that were performed in the code data test; set test; run; %MACRO DO_BRANCH; %do u=1 %to 20; proc surveyselect data=test method = urs sampsize = 141 OUTHITS reps=1 seed=1234100 out=new_&u; run; ERROR: The %DO statement is not valid in open code. CODES.......... %end; %MEND DO_BRANCH;

desireatem · ‎01-16-2014

Hello, How can I fix this by maintaining %do u=1 %to 20; .........%end data new; set new; run; %do u=1 %to 20; proc surveyselect data=new method = urs sampsize = 141 OUTHITS reps=1 seed=1234100 out=new_&u; run; ERROR: The %DO statement is not valid in open code. CODES.......... %end;

desireatem · ‎01-12-2014

data Pattern; Age=0; output; run; ods trace on /listing; ods output ParameterEstimates=CPHH; proc phreg data=new ; model monset*obs(0)= age; baseline covariates=Pattern out=survs survival= survival; run; ods trace off;

desireatem · ‎01-12-2014

Hi the code below gives the s_(t)=[s_(0)]^esp(beta *Av(age3)). How do I modify the code to get the baseline survival at age3=0, that is just s_(0). Below is the code that need to be fixed ods trace on /listing; ods output ParameterEstimates=CPHH; proc phreg data=new ; model monset*obs(0)= age3; baseline out=survs survival= survival; run; ods trace off;

desireatem · ‎01-10-2014

data CP; input time A B; cards; 1 . . 2 0 .1 2 .4 .7 3 .3 .5 5 .9 0 6 .3 .33 ; I want to create a third and fourth variable calle Asum and Bsum where Asum= .+0+.4+.3+.9+.3 data CP; input time A B Asum Bsum; cards; 1 . . .+0+.4+.3+.9+.3 .+.1+.7+.5+0+.33 2 0 .1 0+.4+.3+.9+.3 1+.7+.5+0+.33 2 .4 .7 .4+.3+.9+.3 .7+.5+0+.33 3 .3 .5 .3+.9+.3 .5+0+.33 5 .9 0 .9+.3 0+.33 6 .3 .33 .3 .33 ;

desireatem · ‎01-10-2014

Data A ; Input a b; Cards; 2 .9 4 .8 9 .3 Data b Input c; Input a; Cards; 1.9 4.7 8.8; Merge them to have: 1.9 . 2 .9 4 .8 4.7 . 8.8 . 9 .3 Thanks

desireatem · ‎01-10-2014

Tanks DBailey

desireatem · ‎01-10-2014

Great response Sir

desireatem · ‎01-10-2014

This is not what I want. I want two variable; In the second variable I am adding Last observation(8)-first observation (1)/n=5, the second I am adding 2 * Last observation(8)-first observation (1)/n=5. etc. So I will have two variables, where the second is a a series

desireatem · ‎01-10-2014

Hello , I have this data; data a input b; cards; 1 3 4 5 8; run; I want to create a second variable were I add this term to the first variable: Last observation(8)-first observation (1)/n, the to the second 2*( last observation(8)-first observation (1)/n) to the third 3*( last observation(8)-first observation (1)/n) where n=total number of observation. I wish to do this within a simulation so will love to have it like this: Last observation-First observation/ n. I will know n but not Last observation and First observation. data a input b t; cards; 1 1+Last observation(8)-first observation (1)/n=5=1.4 3 1+ 2(1.4) 4 1+ 3(1.4) 5 1+4(1.4) 8 1+5(1.4); run;

desireatem · ‎01-10-2014

Hi There, what is wrong with this code? proc iml; use kaplan; read all var{monset Survival survival1} into DM; close; Survival1 = DM[,3]; Survival = DM[,2]; monset = DM[,1]; /*Survivalival is second column*/ /*monset is first column*/ n = nrow(DM); /*number of rows in the dataset = obs*/ /*THE N DOESNT NEED TO BE FIXED*/ segment = J(nrow(DM),1,1); *print segment; do i = 2 to nrow(DM); if monset=monset[i+1] then survival1=survival1[i+1]; if monset[i-1]=monset then survival1[i-1]=survival1; if monset=monset[i-1] then survival1=survival1[i-1]; end; create Mkaplan var{monset Survival survival1}; append; quit; ERROR: (execution) Invalid subscript or subscript out of range. operation : [ at line 872 column 20 operands : monset, _TEM1002 MONSET 141 rows 1 col (numeric) _TEM1002 1 row 1 col (numeric) 142

desireatem · ‎01-09-2014

you are correct. Thanks

Online Status	Offline
Date Last Visited	‎07-27-2024 12:54 AM

Re: Compute length of stay from 17 character date

Re: Compute length of stay from 17 character date

Re: Compute length of stay from 17 character date

Compute length of stay from 17 character date

Re: Checking if two points agree or disagree in data

Re: Checking if two points agree or disagree in data

Re: Checking if two points agree or disagree in data

Re: Checking if two points agree or disagree in data

Re: Checking if two points agree or disagree in data

Checking if two points agree or disagree in data

Re: Checking if two points agree or disagree in data

Re: Coefficient plots

Re: Plot of sample size versus year

Re: Manipulation with data and time

Re: Manipulation with data and time

Re: SAS Macro

Re: Transforming data long to wide, issue with code

Re: Using Substr function

Re: ERROR: An exception has been encountered. What type of error is t...

Re: How do I automatically clear log and output

Re: PHREG baseline survival estimates.

PHREG baseline survival estimates.

Re: ERROR: The %DO statement is not valid in open code.

Re: ERROR: The %DO statement is not valid in open code.

ERROR: The %DO statement is not valid in open code.

Re: baseline survival function in the cox model with covariates set to...

baseline survival function in the cox model with covariates set to zer...

SUM statement

merging ?

Re: Create an evenly space variable

Re: Create an evenly space variable

Re: Create an evenly space variable

Create an evenly series variable

ERROR: (execution) Invalid subscript or subscript out of range.

Re: How to sum element from n and below