Not sure what his error code is showing me.  error code  11 data fram_merge; 12 merge fram1_temp fram2_temp; 13 by subjid; 14 age = (vdate-bdate)/365.25; 15 diff_tchol = totchol2 - totchol; 16 if diff_tchol > 1 then ch_tchol > 1; -------- 180 17 else if diff_tchol < 1 then ch_tchol < 1; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 18 if diff_tchol = 0 then chtchol = 0; 19 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.FRAM_MERGE may be incomplete. When this step was stopped there were 0 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds   proc sort data=fram1_temp; by subjid; proc sort data=fram2_temp; by subjid; data fram_merge; merge fram1_temp fram2_temp; by subjid; age = (vdate-bdate)/365.25; diff_tchol = totchol2 - totchol; run; data fram_merge; if diff_tchol > 1 then ch_tchol > 1; else if diff_tchol < 1 then ch_tchol < 1; if diff_tchol = 0 then ch_tchol = 0; run; Here is what I am trying to answer Create a variable called ch_tchol which equals –, 0, or + depending on whether diff_tchol is negative, zero, or positive in value respectively.   ... View more

New to Sas and I am trying to figure out how to format the data from long to wide.    data muscatine_wide; by id; set hw7.muscatine; array y[3] o1 o2 o3; array age[3] a1 a2 a3; y[occasion] = obese; retain o1 -o2; a[occasion] = age; if first.id = 1 then delete; run; This is the error code I am getting. However, I don't know if the sas code (above) is accomplishing what I am trying to do.    1 libname hw7 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Homework 7'; NOTE: Libref HW7 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Homework 7 2 run; 3 data glow_combined; 4 set hw7.glow1 5 hw7.glow2 6 hw7.glow3 7 hw7.glow4 8 hw7.glow5 9 hw7.glow6; 10 run; NOTE: There were 107 observations read from the data set HW7.GLOW1. NOTE: There were 90 observations read from the data set HW7.GLOW2. NOTE: There were 65 observations read from the data set HW7.GLOW3. NOTE: There were 36 observations read from the data set HW7.GLOW4. NOTE: There were 120 observations read from the data set HW7.GLOW5. NOTE: There were 82 observations read from the data set HW7.GLOW6. NOTE: The data set WORK.GLOW_COMBINED has 500 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds 11 data glow_combined; 12 set hw7.glow1(in= glow1) 13 hw7.glow2 (in=glow2) 14 hw7.glow3 (in=glow3) 15 hw7.glow4 (in=glow4) 16 hw7.glow5 (in=glow5) 17 hw7.glow6 (in=glow6); 18 if glow1 then site_id = 1; 19 if glow2 then site_id = 2; 20 if glow3 then site_id = 3; 21 if glow4 then site_id = 4; 22 if glow5 then site_id = 5; 23 if glow6 then site_id = 6; 24 run; NOTE: There were 107 observations read from the data set HW7.GLOW1. NOTE: There were 90 observations read from the data set HW7.GLOW2. NOTE: There were 65 observations read from the data set HW7.GLOW3. NOTE: There were 36 observations read from the data set HW7.GLOW4. NOTE: There were 120 observations read from the data set HW7.GLOW5. NOTE: There were 82 observations read from the data set HW7.GLOW6. NOTE: The data set WORK.GLOW_COMBINED has 500 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.03 seconds 25 data glow_cleaned; 26 set glow_combined; 27 array miss[3] age weight height; 28 do i = 1 to 3; 29 if miss [i] = 999 then miss[i] = .; 30 drop i; 31 end; 32 run; NOTE: There were 500 observations read from the data set WORK.GLOW_COMBINED. NOTE: The data set WORK.GLOW_CLEANED has 500 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 33 data glow; 34 set glow_cleaned; 35 array miss_char[3] momfrac raterisk priorfrac; 36 do i = 1 to 3; 37 if miss_char[i] in ('NA') then miss_char[i] = " "; 38 end; 39 drop i; 40 run; NOTE: There were 500 observations read from the data set WORK.GLOW_CLEANED. NOTE: The data set WORK.GLOW has 500 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 41 data glow; 42 set glow_cleaned; 43 bmi = weight/((height/100)**2); 44 if age<=65 and (bmi<18 or bmi>25) then age_bmicat=1; 45 else if age<=65 and (18 <= bmi <= 25) then age_bmicat = 2; 46 if age>65 and (bmi<25 or bmi>30)then age_bmicat=3; 47 else if age>65 and (25 <= bmi <= 30) then age_bmicat=4; 48 run; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 81 at 43:13 100 at 43:22 NOTE: There were 500 observations read from the data set WORK.GLOW_CLEANED. NOTE: The data set WORK.GLOW has 500 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 49 proc sort data=glow; by descending priorfrac descending fracture; NOTE: There were 500 observations read from the data set WORK.GLOW. NOTE: The data set WORK.GLOW has 500 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 50 proc freq data=glow order=data; where priorfrac ne 'NA'; 51 table priorfrac*fracture/chisq relrisk; 52 run; NOTE: Writing HTML Body file: sashtml.htm NOTE: There were 400 observations read from the data set WORK.GLOW. WHERE priorfrac not = 'NA'; NOTE: PROCEDURE FREQ used (Total process time): real time 0.43 seconds cpu time 0.31 seconds 53 proc logistic data=glow descending; where priorfrac ne 'NA'; 54 class priorfrac (param=ref ref="No"); 55 model fracture = priorfrac/clodds=wald; 56 run; NOTE: PROC LOGISTIC is modeling the probability that fracture='1'. NOTE: Convergence criterion (GCONV=1E-8) satisfied. NOTE: There were 400 observations read from the data set WORK.GLOW. WHERE priorfrac not = 'NA'; NOTE: PROCEDURE LOGISTIC used (Total process time): real time 0.87 seconds cpu time 0.40 seconds 57 proc logistic data=glow descending; 58 class age_bmicat (param=ref ref='1'); 59 model fracture = age_bmicat/clodds=wald; NOTE: PROC LOGISTIC is modeling the probability that fracture='1'. NOTE: Convergence criterion (GCONV=1E-8) satisfied. NOTE: There were 500 observations read from the data set WORK.GLOW. NOTE: PROCEDURE LOGISTIC used (Total process time): real time 41.10 seconds cpu time 1.70 seconds 60 data muscatine_wide(keep=(id o1 o2 o3 a1 a2 a3 gender)); - 214 23 ERROR 214-322: Variable name ( is not valid. ERROR 23-7: Invalid value for the KEEP option. 61 by id; ERROR: No SET, MERGE, UPDATE, or MODIFY statement is present. 62 set hw7.muscatine; 63 array y[3] o1 o2 o3; - 124 ERROR 124-185: The variable y has already been defined. 64 array age[3] a1 a2 a3; --- 124 ERROR 124-185: The variable age has already been defined. 65 y[occasion] = obese; ERROR: Undeclared array referenced: Y. ERROR: Variable Y has not been declared as an array. 66 retain o1 -o2; 67 a[occasion] = age; ERROR: Undeclared array referenced: a. ERROR: Variable a has not been declared as an array. 68 if first.id = 1 then delete; 69 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds ... View more

I am using a proc freq to get a table with relative risk and odd ratios. However I have a 3x2 table. So I wanted to know if there was a way to remove 'N/A' out of my table.  Sas Code:    proc sort data=glow; by descending priorfrac descending fracture; proc freq data=glow order=data; table priorfrac*fracture/chisq relrisk; run; This is what the output looks like         ... View more

Not sure how to write this code. I am trying to answer this question:  Remove from the data set any observations where the date of delivery was recorded as before the date of admission to the hospital or after the date of discharge from the hospital. When I use this code it says I have no observations: date2 = date of delivery  date1 = date of admission to the hospital  dod = date of discharge data dil_merge; merge hw6.dil1 hw6.dil2_temp; by MEDRNO; if xwtgainlb > 60 then delete; if xwtgainlb < 60 then delete; if date2 < date1 then delete; if date2 > dod then delete; run;   ... View more

I want to create an indicator variable for 'male' sex. However, I do not have gender or sex as variables in my data set. I have two different data sets (data set for males) and (data set for females). I am trying to combine the two data sets which is why I need help with this.    libname hw6 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Desktop\Assignment 6'; data hw6.sex_f_temp(rename=(subj_id_char=number) drop=subj_id); set hw6.sex_f; subj_id_char = input(subj_id, 4.); run; proc sort data=hw6.sex_f_temp; by number; proc sort data=hw6.sex_m; by number; data pbc; set hw6.sex_f_temp hw6.sex_m; by number; logALBUMIN=log(ALBUMIN); if male = 1 then sex = 1; if female = 1 then sex=0; run; ... View more

I am trying to turn the variable 'number' into a character variable then rename it to 'subj_id'. However, it keeps telling me that that subj_id is both character  and numeric. I don’t understand how that is possible if I changed it the variable to character.    Ultimately this is what I am trying to do: interleave the data sets sex_f and sex_m from library hw6 such that the data set pbc is sorted by subject ID (number). Then we wish to create the new variable logalbu, which should be log transformed albumin, and an indicator variable for male sex.   libname hw6 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Desktop\Assignment 6'; data hw6.sex_m_temp; set hw6.sex_m (rename=(number=subj_id)); number= input(number,8.); run; proc sort data=hw6.sex_f; by subj_id; proc sort data=hw6.sex_m_temp; by subj_id; data pbc; set hw6.sex_f hw6.sex_m_temp; by subj_id; logalb=log(alb); if male = 1 then sex = 1; if female = 1 then sex=0; run; 40 libname hw6 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Desktop\Assignment 6'; NOTE: Libref HW6 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Desktop\Assignment 6 41 data hw6.sex_m_temp; 42 set hw6.sex_m (rename=(number=subj_id)); 43 number= input(number,8.); 44 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 43:15 NOTE: There were 276 observations read from the data set HW6.SEX_M. NOTE: The data set HW6.SEX_M_TEMP has 276 observations and 26 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.03 seconds 45 46 47 48 proc sort data=hw6.sex_f; by subj_id; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 49 proc sort data=hw6.sex_m_temp; by subj_id; NOTE: There were 276 observations read from the data set HW6.SEX_M_TEMP. NOTE: The data set HW6.SEX_M_TEMP has 276 observations and 26 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.00 seconds 50 data pbc; 51 set hw6.sex_f hw6.sex_m_temp; ERROR: Variable subj_id has been defined as both character and numeric. 52 by subj_id; 53 logalb=log(alb); 54 if male = 1 then sex = 1; 55 if female = 1 then sex=0; 56 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.PBC may be incomplete. When this step was stopped there were 0 observations and 31 variables. WARNING: Data set WORK.PBC was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.00 seconds ... View more

I am trying to correct the code but I am unsure of what I am doing wrong.    libname HwQuest3'\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Homework 5'; data bone2(drop=sex rename=(tempvar=sex)); set hw5.bone2; tempvar2 = input(sex,1.); run; data bone5(drop=sex rename=(tempvar=sex)); set hw5.bone5; tempvar5 = input(sex,1.); run; data bone; set bone1 bone2(in=intanner2) bone3 bone4(rename=(gender=sex) in=intanner4) bone5; if intanner1 = 1 then tanner=1; if intanner2 = 1 then tanner=2; if intanner3 = 1 then tanner=3; if intanner4 = 1 then tanner=4; if intanner5 = 1 then tanner=5; age = (dov-dob)/365.25; run; 144 * Question 3; 145 libname HwQuest3'\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Homework 5'; NOTE: Libref HWQUEST3 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Homework 5 NOTE: PROCEDURE GLM used (Total process time): real time 0.10 seconds cpu time 0.09 seconds 146 data bone2(drop=sex rename=(tempvar=sex)); 147 set hw5.bone2; ERROR: File HW5.BONE2.DATA does not exist. 148 tempvar2 = input(sex,1.); 149 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 148:18 WARNING: The variable tempvar in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BONE2 may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.BONE2 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 150 data bone5(drop=sex rename=(tempvar=sex)); 151 set hw5.bone5; ERROR: File HW5.BONE5.DATA does not exist. 152 tempvar5 = input(sex,1.); 153 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 152:18 WARNING: The variable tempvar in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BONE5 may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.BONE5 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 154 data bone; 155 set bone1 156 bone2(in=intanner2) 157 bone3 158 bone4(rename=(gender=sex) in=intanner4) 159 bone5; ERROR: File WORK.BONE1.DATA does not exist. ERROR: File WORK.BONE3.DATA does not exist. ERROR: File WORK.BONE4.DATA does not exist. 160 if intanner1 = 1 then tanner=1; 161 if intanner2 = 1 then tanner=2; 162 if intanner3 = 1 then tanner=3; 163 if intanner4 = 1 then tanner=4; 164 if intanner5 = 1 then tanner=5; 165 age = (dov-dob)/365.25; 166 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BONE may be incomplete. When this step was stopped there were 0 observations and 17 variables. WARNING: Data set WORK.BONE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

I keep getting this error but I don't understand why. I formatted  the variables beforehand so I should be able to do a procprint using those formatted variables.  libname hw4 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4'; data fit1; set hw4.fit1; run; *Question (i-iv); proc format; value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; value txfmt 1 = "treatment" 0 = "Placebo"; value bmifmt 25-HIGH ="overweight" LOW -< 25="normal"; value bmigrp LOW -< 18= 'underweight' 18 - 25 = 'normal' 25 <- HIGH = 'normal'; run; proc means data =fit1 p25; *Quesition 1(v-vi); proc format; value cobmdfmt 0.545-HIGH = 'Above'; value blbmdfmt LOW -< 0.542 = 'less'; run; *Question 1(c); data fit1tmp; set hw4.fit1; run; *Question 1c(ii); proc print data=fit1(obs=5); var dob dov; format dob dov mmddyy10. smoker CSfmt. tx_status txfmt.; run; *Question 1c(iii); proc print data=fit1(obs=5); var dob dov Csfmt. txfmt.; run; NOTE: Libref HW4 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4 179 data fit1; 180 set hw4.fit1; 181 run; ERROR: You cannot open WORK.FIT1.DATA for output access with member-level control because WORK.FIT1.DATA is in use by you in resource environment ViewTable Window. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.01 seconds 182 *Question (i-iv); 183 proc format; 184 value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; NOTE: Format CSFMT is already on the library WORK.FORMATS. NOTE: Format CSFMT has been output. 185 value txfmt 1 = "treatment" 0 = "Placebo"; NOTE: Format TXFMT is already on the library WORK.FORMATS. NOTE: Format TXFMT has been output. 186 value bmifmt 25-HIGH ="overweight" LOW -< 25="normal"; NOTE: Format BMIFMT is already on the library WORK.FORMATS. NOTE: Format BMIFMT has been output. 187 value bmigrp LOW -< 18= 'underweight' 18 - 25 = 'normal' 25 <- HIGH = 'normal'; NOTE: Format BMIGRP is already on the library WORK.FORMATS. NOTE: Format BMIGRP has been output. 188 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 189 proc means data =fit1 p25; 190 *Quesition 1(v-vi); NOTE: There were 5813 observations read from the data set WORK.FIT1. NOTE: PROCEDURE MEANS used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 191 proc format; 192 value cobmdfmt 0.545-HIGH = 'Above'; NOTE: Format COBMDFMT is already on the library WORK.FORMATS. NOTE: Format COBMDFMT has been output. 193 value blbmdfmt LOW -< 0.542 = 'less'; NOTE: Format BLBMDFMT is already on the library WORK.FORMATS. NOTE: Format BLBMDFMT has been output. 194 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 195 *Question 1(c); 196 data fit1tmp; 197 set hw4.fit1; 198 run; ERROR: You cannot open WORK.FIT1TMP.DATA for output access with member-level control because WORK.FIT1TMP.DATA is in use by you in resource environment ViewTable Window. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 199 *Question 1c(ii); 200 proc print data=fit1(obs=5); 201 var dob dov; 202 format dob dov mmddyy10. smoker CSfmt. tx_status txfmt.; 203 run; NOTE: There were 5 observations read from the data set WORK.FIT1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 204 *Question 1c(iii); 205 proc print data=fit1(obs=5); 206 var dob dov Csfmt. txfmt.; ------ 22 201 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, /, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 201-322: The option is not recognized and will be ignored. 207 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds ... View more