I am trying to figure out what I did wrong. I used the if, then statements to create a new variable "pubertal".    libname hw5'\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Documents\Assignment 5'; data bone; set hw5.bone (where =(sex=1)); age = (dov-dob)/365.25; if tanner = '1' then pubertal = 0; else if tanner = '2' then pubertal = 0 or tanner = '3' then pubertal = 0; if tanner = '4' then pubertal = 1; else if tanner = '5' then pubertal = 1; run; 78 libname hw5'\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Documents\Assignment 5'; NOTE: Libref HW5 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Documents\Assignment 5 79 data bone; 80 set hw5.bone (where =(sex=1)); 81 age = (dov-dob)/365.25; 82 if tanner = '1' then pubertal = 0; 83 else if tanner = '2' then pubertal = 0 or tanner = '3' then pubertal = 0; ---- 388 202 ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored. 84 if tanner = '4' then pubertal = 1; 85 else if tanner = '5' then pubertal = 1; 86 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 82:13 83:18 83:52 84:13 85:18 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 11 variables. WARNING: Data set WORK.BONE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds ... View more

I am trying to input my data into SAS. But I keep getting blank space in my data file.  data hw4.bone; infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; input dob 1-10 dov 11-20 wt 21-26 ht 27-30 peri 31-35 endo 35-40 tibia 41-44 tanner $ 45 sex $ 46; age = (dov - dob)/365; logperi = log(peri); run; 206 infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; 207 input dob 1-10 dov 11-20 wt 21-26 ht 27-30 peri 31-35 208 endo 35-40 tibia 41-44 tanner $ 45 sex $ 46; 209 age = (dov - dob)/365; 210 logperi = log(peri); 211 run; NOTE: The infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt" is: Filename=\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt, RECFM=V,LRECL=32767,File Size (bytes)=37854, Last Modified=04Oct2022:16:09:23, Create Time=04Oct2022:16:09:23 NOTE: Invalid data for dob in line 1 1-10. NOTE: Invalid data for dov in line 1 11-20. NOTE: Invalid data for wt in line 1 21-26. NOTE: Invalid data for peri in line 1 31-35. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9-- 1 11MAR1975 19MAR2004 55.7 167.8333 67.722 35.05 392 5 2 54 dob=. dov=. wt=. ht=67.8 peri=. endo=67.722 tibia=35 tanner=0 sex=5 age=. logperi=. _ERROR_=1 _N_=1 NOTE: Invalid data for dob in line 2 1-10. NOTE: Invalid data for dov in line 2 11-20. NOTE: Invalid data for ht in line 2 27-30. NOTE: Invalid data for endo in line 2 35-40. 2 11OCT1978 29MAR2004 61.93333 160.8667 75.179 31.42 370 5 2 58 dob=. dov=. wt=61.933 ht=. peri=60.86 endo=. tibia=0.179 tanner= sex=3 age=. logperi=4.1085761445 _ERROR_=1 _N_=2 NOTE: Invalid data for dob in line 3 1-10. NOTE: Invalid data for dov in line 3 11-20. NOTE: Invalid data for wt in line 3 21-26. NOTE: Invalid data for peri in line 3 31-35. 3 25JAN1975 16AUG2004 85.5 188.4333 78.923 42.373 451 5 1 55 dob=. dov=. wt=. ht=88.4 peri=. endo=78.923 tibia=42 tanner=3 sex=7 age=. logperi=. _ERROR_=1 _N_=3 NOTE: Invalid data for dob in line 4 1-10. NOTE: Invalid data for dov in line 4 11-20. NOTE: Invalid data for wt in line 4 21-26. NOTE: Invalid data for peri in line 4 31-35. 4 17APR1978 26OCT2004 58.3 160.4333 65.595 32.551 353 5 2 55 dob=. dov=. wt=. ht=60.4 peri=. endo=65.595 tibia=32 tanner=5 sex=5 age=. logperi=. _ERROR_=1 _N_=4 NOTE: Invalid data for dob in line 5 1-10. NOTE: Invalid data for dov in line 5 11-20. NOTE: Invalid data for ht in line 5 27-30. NOTE: Invalid data for endo in line 5 35-40. 5 21FEB1978 18NOV2004 59.13334 160.0333 63.761 38.858 351 5 2 59 dob=. dov=. wt=59.133 ht=. peri=60.03 endo=. tibia=0.761 tanner= sex=3 age=. logperi=4.0948444373 _ERROR_=1 _N_=5 NOTE: Invalid data for dob in line 6 1-10. NOTE: Invalid data for dov in line 6 11-20. NOTE: Invalid data for ht in line 6 27-30. NOTE: Invalid data for endo in line 6 35-40. 6 24AUG1977 29NOV2004 70.63333 184.7667 80.437 33.072 406 5 1 59 dob=. dov=. wt=70.633 ht=. peri=84.76 endo=. tibia=0.437 tanner= sex=3 age=. logperi=4.4398237334 _ERROR_=1 _N_=6 NOTE: Invalid data for dob in line 7 1-10. NOTE: Invalid data for dov in line 7 11-20. NOTE: Invalid data for ht in line 7 27-30. NOTE: Invalid data for endo in line 7 35-40. 7 28OCT1973 03JAN2005 64.36667 171.7333 66.205 35.9 382 5 2 57 dob=. dov=. wt=64.366 ht=. peri=71.73 endo=. tibia=0.205 tanner= sex=3 age=. logperi=4.2729090701 _ERROR_=1 _N_=7 NOTE: Invalid data for dob in line 8 1-10. NOTE: Invalid data for dov in line 8 11-20. NOTE: Invalid data for wt in line 8 21-26. NOTE: Invalid data for peri in line 8 31-35. 8 04JAN1981 09MAR2005 93.3 187.4667 79.986 35.279 421 5 1 55 dob=. dov=. wt=. ht=87.4 peri=. endo=79.986 tibia=35 tanner=2 sex=7 age=. logperi=. _ERROR_=1 _N_=8 NOTE: Invalid data for dob in line 9 1-10. NOTE: Invalid data for dov in line 9 11-20. NOTE: Invalid data for wt in line 9 21-26. NOTE: Invalid data for peri in line 9 31-35. 9 19SEP1970 06APR2005 81.4 185.7667 80.011 47.433 412 5 1 55 dob=. dov=. wt=. ht=85.7 peri=. endo=80.011 tibia=47 tanner=4 sex=3 age=. logperi=. _ERROR_=1 _N_=9 NOTE: Invalid data for dob in line 10 1-10. NOTE: Invalid data for dov in line 10 11-20. NOTE: Invalid data for wt in line 10 21-26. NOTE: Invalid data for peri in line 10 31-35. 10 06OCT1979 07APR2005 86.1 177.5667 73.965 33.133 377 5 1 55 dob=. dov=. wt=. ht=77.5 peri=. endo=73.965 tibia=33 tanner=1 sex=3 age=. logperi=. _ERROR_=1 _N_=10 NOTE: Invalid data for dob in line 11 1-10. NOTE: Invalid data for dov in line 11 11-20. NOTE: Invalid data for wt in line 11 21-26. NOTE: Invalid data for peri in line 11 31-35. 11 21MAR1975 08APR2005 77.5 187.3333 79.986 38.468 439 5 1 55 dob=. dov=. wt=. ht=87.3 peri=. endo=79.986 tibia=38 tanner=4 sex=6 age=. logperi=. _ERROR_=1 _N_=11 NOTE: Invalid data for dob in line 12 1-10. NOTE: Invalid data for dov in line 12 11-20. NOTE: Invalid data for ht in line 12 27-30. NOTE: Invalid data for tibia in line 12 41-44. 12 29OCT1970 08JUN2005 70.23333 172.4 83.708 45.794 400 5 1 56 dob=. dov=. wt=70.233 ht=. peri=72.4 endo=83.7 tibia=. tanner= sex=7 age=. logperi=4.2822062994 _ERROR_=1 _N_=12 NOTE: Invalid data for dob in line 13 1-10. NOTE: Invalid data for dov in line 13 11-20. NOTE: Invalid data for wt in line 13 21-26. NOTE: Invalid data for endo in line 13 35-40. 13 26NOV1975 25JUN2005 90.1 175.1 76.557 36.84 390 5 1 51 dob=. dov=. wt=. ht=75.1 peri=76.5 endo=. tibia=0.84 tanner=3 sex=9 age=. logperi=4.3372907408 _ERROR_=1 _N_=13 NOTE: Invalid data for dob in line 14 1-10. NOTE: Invalid data for dov in line 14 11-20. NOTE: Invalid data for wt in line 14 21-26. NOTE: Invalid data for endo in line 14 35-40. NOTE: Invalid data for tibia in line 14 41-44. 14 30DEC1982 29JUL2005 56.4 164.3 67.2 27.385 372 5 2 50 dob=. dov=. wt=. ht=64.3 peri=67.2 endo=. tibia=. tanner=7 sex=2 age=. logperi=4.2076732475 _ERROR_=1 _N_=14 NOTE: Invalid data for dob in line 15 1-10. NOTE: Invalid data for dov in line 15 11-20. NOTE: Invalid data for wt in line 15 21-26. NOTE: Invalid data for peri in line 15 31-35. 15 16AUG1985 25JAN2002 59.6 155.1333 63.682 29.743 360 3 2 55 dob=. dov=. wt=. ht=55.1 peri=. endo=63.682 tibia=29 tanner=7 sex=4 age=. logperi=. _ERROR_=1 _N_=15 NOTE: Invalid data for dob in line 16 1-10. NOTE: Invalid data for dov in line 16 11-20. NOTE: Invalid data for ht in line 16 27-30. NOTE: Invalid data for endo in line 16 35-40. 16 25MAY1977 26AUG2005 70.96667 173.0333 72.815 37.274 402 5 1 59 dob=. dov=. wt=70.966 ht=. peri=73.03 endo=. tibia=0.815 tanner= sex=3 age=. logperi=4.2908703156 _ERROR_=1 _N_=16 NOTE: Invalid data for dob in line 17 1-10. NOTE: Invalid data for dov in line 17 11-20. NOTE: Invalid data for ht in line 17 27-30. NOTE: Invalid data for endo in line 17 35-40. 17 23NOV1988 08FEB2002 61.56667 157.2667 62.696 29.335 339 3 2 59 dob=. dov=. wt=61.566 ht=. peri=57.26 endo=. tibia=0.696 tanner= sex=2 age=. logperi=4.0476022997 _ERROR_=1 _N_=17 NOTE: Invalid data for dob in line 18 1-10. NOTE: Invalid data for dov in line 18 11-20. NOTE: Invalid data for wt in line 18 21-26. NOTE: Invalid data for peri in line 18 31-35. 18 18DEC1975 02NOV2005 71.7 167.3667 65.748 29.198 384 5 2 55 dob=. dov=. wt=. ht=67.3 peri=. endo=65.748 tibia=29 tanner=1 sex=9 age=. logperi=. _ERROR_=1 _N_=18 NOTE: Invalid data for dob in line 19 1-10. NOTE: Invalid data for dov in line 19 11-20. NOTE: Invalid data for wt in line 19 21-26. NOTE: Invalid data for peri in line 19 31-35. 19 19JAN1982 07NOV2005 73.3 180.3667 77.807 35.506 411 5 1 55 dob=. dov=. wt=. ht=80.3 peri=. endo=77.807 tibia=35 tanner=5 sex=0 age=. logperi=. _ERROR_=1 _N_=19 NOTE: Invalid data for dob in line 20 1-10. NOTE: Invalid data for dov in line 20 11-20. NOTE: Invalid data for wt in line 20 21-26. NOTE: Invalid data for peri in line 20 31-35. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 20 30NOV1969 08NOV2005 83.9 164.5667 66.129 33.163 411 5 2 55 dob=. dov=. wt=. ht=64.5 peri=. endo=66.129 tibia=33 tanner=1 sex=6 age=. logperi=. _ERROR_=1 _N_=20 NOTE: 665 records were read from the infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt". The minimum record length was 48. The maximum record length was 59. 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). 665 at 209:12 263 at 210:11 NOTE: The data set HW4.BONE has 665 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.09 seconds ... View more

Not understanding the errors in this datastep. Please help!   data hw4.bone; infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; input dob 1-10 dov 11-20 wt $ 21-26 ht 27-30 $ peri $ 31-35 endo $ 35-40 tibia $ 41-44 tanner 45 sex 46; age = (dov - dob)/365 logperi = log(peri); run; 71 data hw4.bone; 72 infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; 73 input dob 1-10 dov 11-20 wt $ 21-26 ht 27-30 $ peri $ 31-35 - 22 ERROR 22-322: Expecting a name. 74 endo $ 35-40 tibia $ 41-44 tanner 45 sex 46; 75 age = (dov - dob)/365 76 logperi = log(peri); ------- 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 77 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 76:15 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set HW4.BONE may be incomplete. When this step was stopped there were 0 observations and 11 variables. WARNING: Data set HW4.BONE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.01 seconds ... View more

I am trying to create a new permanent SAS data set with the following variables.  data bone; infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; input @1 dob 1-10. @11 dov 11-20. @21 wt $ 21-26. @27 ht 27-30. @31 peri $ 31-35. endo $ 35-40 tibia $ 41-44 tanner 45 sex 46; age = (dov - dob)/365; logperi = log(peri); run; 181 data bone; 182 infile "\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4\bone.txt"; 183 input @1 dob 1-10. @11 dov 11-20. @21 wt $ 21-26. @27 ht 27-30. @31 peri $ 31-35. --- --- 22 22 ERROR: Invalid decimal specification. 183 input @1 dob 1-10. @11 dov 11-20. @21 wt $ 21-26. @27 ht 27-30. @31 peri $ 31-35. --- 22 ERROR 22-322: Expecting an integer constant. ERROR: The ending column position 1 is before the starting column position 11. ERROR: Invalid decimal specification. 183 input @1 dob 1-10. @11 dov 11-20. @21 wt $ 21-26. @27 ht 27-30. @31 peri $ 31-35. --- 22 ERROR 22-322: Expecting an integer constant. ERROR: The ending column position 1 is before the starting column position 21. ERROR: Invalid decimal specification. ERROR: The ending column position 1 is before the starting column position 27. ERROR: Invalid decimal specification. 183 input @1 dob 1-10. @11 dov 11-20. @21 wt $ 21-26. @27 ht 27-30. @31 peri $ 31-35. --- 22 ERROR 22-322: Expecting an integer constant. 184 endo $ 35-40 tibia $ 41-44 tanner 45 sex 46; ERROR: The ending column position 1 is before the starting column position 31. ERROR: Invalid decimal specification. 185 age = (dov - dob)/365; 186 logperi = log(peri); 187 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 186:15 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 11 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.03 seconds   ... View more

I am trying to apply the smoking and treatment format to the smoker and treatment variable.  proc freq data=fit1; table smoke tx_status; format smoke CSfmt. tx_status txfmt.; run; 79 libname hw4 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4'; NOTE: Libref HW4 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4 80 data fit1; 81 set hw4.fit1; 82 run; NOTE: There were 5813 observations read from the data set HW4.FIT1. NOTE: The data set WORK.FIT1 has 5813 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 83 proc format; 84 value $CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; NOTE: Format $CSFMT is already on the library WORK.FORMATS. NOTE: Format $CSFMT has been output. 85 value $txfmt 1 = "treatment" 0 = "Placebo"; NOTE: Format $TXFMT is already on the library WORK.FORMATS. NOTE: Format $TXFMT has been output. 86 value $bmifmt 25-HIGH ="overweight" LOW -< 25="normal"; NOTE: 25 is a numeric field and a character format is defined. NOTE: Format $BMIFMT is already on the library WORK.FORMATS. NOTE: Format $BMIFMT has been output. 87 value $bmigrp LOW -< 18= 'underweight' 18 - 25 = 'normal' 25 <- HIGH = 'normal'; NOTE: 18 is a numeric field and a character format is defined. NOTE: Format $BMIGRP is already on the library WORK.FORMATS. NOTE: Format $BMIGRP has been output. 88 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 89 proc means data =fit1 p25; NOTE: There were 5813 observations read from the data set WORK.FIT1. NOTE: PROCEDURE MEANS used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 90 proc format; 91 value cobmdfmt 0.5450000-HIGH = 'Above'; NOTE: Format COBMDFMT is already on the library WORK.FORMATS. NOTE: Format COBMDFMT has been output. 92 value blbmdfmt LOW -< 0.5420000 = 'less'; NOTE: Format BLBMDFMT is already on the library WORK.FORMATS. NOTE: Format BLBMDFMT has been output. 93 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 94 data fit1tmp; 95 set hw4.fit1; 96 run; NOTE: There were 5813 observations read from the data set HW4.FIT1. NOTE: The data set WORK.FIT1TMP has 5813 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 97 proc print data=fit1(obs=5); 98 var dob dov; 99 format dob dov mmddyy10.; 100 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 101 proc freq data=fit1; 102 table smoke tx_status; 103 format smoke $CSfmt. tx_status $txfmt.; ERROR: You are trying to use the character format $TXFMT with the numeric variable tx_status in data set WORK.FIT1. 104 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

I need help identifying why I keep getting an error message. libname hw4 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4'; data fit1; set hw4.fit1; run; 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; var cobmd blbmd; format cobmd cobmdfmt. blbmd blbmd.; run;   NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M6) Licensed to GEORGE WASHINGTON UNIVERSITY - SFA T&R, Site 70139329. NOTE: This session is executing on the X64_DSRV19 platform. NOTE: Analytical products: SAS/STAT 15.1 SAS/ETS 15.1 SAS/IML 15.1 SAS/QC 15.1 NOTE: Additional host information: X64_DSRV19 WIN 10.0.17763 Server NOTE: SAS initialization used: real time 3.53 seconds cpu time 1.07 seconds 1 proc means data =fit1 p25; ERROR: File WORK.FIT1.DATA does not exist. 2 var cobmd blbmd; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 3 format cobmd cobmdfmt. blbmd blbmdfmt.; 4 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 5 libname hw4 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4'; NOTE: Libref HW4 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4 6 data fit1; 7 set hw4.fit1; 8 run; NOTE: There were 5813 observations read from the data set HW4.FIT1. NOTE: The data set WORK.FIT1 has 5813 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 9 proc format; 10 value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; NOTE: Format CSFMT has been output. 11 value txfmt 1 = "treatment" 0 = "Placebo"; NOTE: Format TXFMT has been output. 12 value $bmifmt 25-HIGH ="overweight" LOW -< 25="normal"; NOTE: 25 is a numeric field and a character format is defined. NOTE: Format $BMIFMT has been output. 13 value $bmigrp LOW -< 18= 'underweight' 18 - 25 = 'normal' 25 <- HIGH = 'normal'; NOTE: 18 is a numeric field and a character format is defined. NOTE: Format $BMIGRP has been output. 14 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 15 proc means data =fit1 p25; 16 var cobmd blbmd; 17 format cobmd cobmdfmt. blbmd blbmdfmt.; ERROR: The format COBMDFMT was not found or could not be loaded. 18 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 19 proc means data =fit1 p25; 20 var cobmd blbmd; 21 run; NOTE: Writing HTML Body file: sashtml.htm NOTE: There were 5813 observations read from the data set WORK.FIT1. NOTE: PROCEDURE MEANS used (Total process time): real time 0.45 seconds cpu time 0.23 seconds ... View more

I am trying to format a variable range. I know I am missing something. Not sure how to input into SAS.  libname hw4 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Assignment 4'; proc format; value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; value txfmt 1 = "treatment" 0 = "Placebo"; run; proc format; value $bmifmt -HIGH bmi> 25 = "overweight" LOW-0<bmi<= 25 = "normal"; run; ERROR: Unable to clear or re-assign the library HW4 because it is still in use. ERROR: Error in the LIBNAME statement. 26 proc format; 27 value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; NOTE: Format CSFMT is already on the library WORK.FORMATS. NOTE: Format CSFMT has been output. 28 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 29 proc format; 30 value CSfmt 1 = 'Current Smokers' 0 = 'Nonsmokers'; NOTE: Format CSFMT is already on the library WORK.FORMATS. NOTE: Format CSFMT has been output. 31 value txfmt 1 = "treatment" 0 = "Placebo"; NOTE: Format TXFMT has been output. 32 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 33 value $bmifmt bmi >25 = "overweight" 0<bmi<= 25 = "normal"; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 34 run; 35 value $bmifmt HIGH bmi> 25 = "overweight" 0<bmi<= 25 = "normal"; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 36 run; 37 proc format; 38 value $bmifmt HIGH bmi> 25 = "overweight" 0<bmi<= 25 = "normal"; ---- --- 22 76 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ;, (, LOW, OTHER. ERROR 76-322: Syntax error, statement will be ignored. ERROR 202-322: The option or parameter is not recognized and will be ignored. 38 ! value $bmifmt HIGH bmi> 25 = "overweight" 0<bmi<= 25 = "normal"; --- 22 NOTE: 25 is a numeric field and a character format is defined. ERROR 22-322: Syntax error, expecting one of the following: (, ',', -, =. NOTE: The previous statement has been deleted. 39 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 40 proc format; 41 value $bmifmt -HIGH bmi> 25 = "overweight" LOW-0<bmi<= 25 = "normal"; - - 22 200 200 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ;, (, LOW, OTHER. ERROR 200-322: The symbol is not recognized and will be ignored. 41 ! value $bmifmt -HIGH bmi> 25 = "overweight" LOW-0<bmi<= 25 = "normal"; - 22 NOTE: 25 is a numeric field and a character format is defined. ERROR: This range is repeated, or values overlap: 25-25. ERROR 22-322: Syntax error, expecting one of the following: (, ',', =. NOTE: The previous statement has been deleted. 42 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 43 proc format; 44 value $bmifmt -HIGH bmi> 25 = "overweight" LOW-0<bmi<= 25 = "normal"; - - 22 200 200 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ;, (, LOW, OTHER. ERROR 200-322: The symbol is not recognized and will be ignored. 44 ! value $bmifmt -HIGH bmi> 25 = "overweight" LOW-0<bmi<= 25 = "normal"; - 22 NOTE: 25 is a numeric field and a character format is defined. ERROR: This range is repeated, or values overlap: 25-25. ERROR 22-322: Syntax error, expecting one of the following: (, ',', =. NOTE: The previous statement has been deleted. 45 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. ... View more

I am trying to create a temporary data set with smokers only (currentsmoker) in it. It says no observations so I know the code is not correct.    libname hw3 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Week 3'; data fit1temp; set hw3.fit2; if upcase(compress(smoke)) = "CURRENTSMOKER" then currentsmoker = 1; else if upcase(compress(smoke)) = "NONSMOKER" or upcase(compress(smoke)) = "FORMERSMOKER" then currentsmoker = 0; if blvfx = "yes" or blnspfx = "yes" then any_base_frac = 1; else if blvfx = "no" and blnspfx = "no" then any_base_frac = 0; if newvfx = "yes" and newnspfx = "yes" then any_new_frac = 1; else if newvfx = "no" and newnspfx = "no" then any_new_frac = 0; if bmi > 25 then bmi2 = "overweight"; else if 0 < bmi <= 25 then bmi2 = "normal"; if 0 < bmi <= 18 then bmi3 = "underweight"; else if 18 < bmi <= 25 then bmi3 = "normal"; else if bmi > 25 then bmi3 = "overweight"; bmi1_ind = (bmi > 25); bmi2_ind = (18 < bmi <= 25); bmi3_ind = (0 < bmi <= 18); i_tx = (tx = "Alendronate"); diff_bmd = cobmd-blbmd; age = (dov - dob)/365.25; run; proc sgplot data=fit1temp; vbox cobmd/group=tx; run; proc means data=fit1temp mean median std p25 p75; class tx; var cobmd; run; proc ttest data=fit1temp; class tx; var cobmd; run; data fit1tmp_smoke; set hw3.Fit2; if CURRENTSMOKER = 1; run; proc sgplot data=fit1tmp_smoke; vbox cobmd/group=tx; run; 120 libname hw3 '\\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Week 3'; NOTE: Libref HW3 was successfully assigned as follows: Engine: V9 Physical Name: \\apporto.com\dfs\GWU\Users\kennedyhinnant_gwu\Downloads\Week 3 121 data fit1temp; 122 set hw3.fit2; 123 if upcase(compress(smoke)) = "CURRENTSMOKER" then currentsmoker = 1; 124 else if upcase(compress(smoke)) = "NONSMOKER" or 125 upcase(compress(smoke)) = "FORMERSMOKER" then currentsmoker = 0; 126 if blvfx = "yes" or blnspfx = "yes" then any_base_frac = 1; 127 else if blvfx = "no" and blnspfx = "no" then any_base_frac = 0; 128 if newvfx = "yes" and newnspfx = "yes" then any_new_frac = 1; 129 else if newvfx = "no" and newnspfx = "no" then any_new_frac = 0; 130 if bmi > 25 then bmi2 = "overweight"; 131 else if 0 < bmi <= 25 then bmi2 = "normal"; 132 if 0 < bmi <= 18 then bmi3 = "underweight"; 133 else if 18 < bmi <= 25 then bmi3 = "normal"; 134 else if bmi > 25 then bmi3 = "overweight"; 135 bmi1_ind = (bmi > 25); 136 bmi2_ind = (18 < bmi <= 25); 137 bmi3_ind = (0 < bmi <= 18); 138 i_tx = (tx = "Alendronate"); 139 diff_bmd = cobmd-blbmd; 140 age = (dov - dob)/365.25; 141 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). 189 at 139:17 NOTE: There were 5580 observations read from the data set HW3.FIT2. NOTE: The data set WORK.FIT1TEMP has 5580 observations and 22 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds 142 proc sgplot data=fit1temp; 143 vbox cobmd/group=tx; 144 run; NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.17 seconds cpu time 0.07 seconds NOTE: There were 5580 observations read from the data set WORK.FIT1TEMP. 145 proc means data=fit1temp mean median std p25 p75; 146 class tx; 147 var cobmd; 148 run; NOTE: There were 5580 observations read from the data set WORK.FIT1TEMP. NOTE: PROCEDURE MEANS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 149 proc ttest data=fit1temp; 150 class tx; 151 var cobmd; 152 run; NOTE: PROCEDURE TTEST used (Total process time): real time 1.25 seconds cpu time 0.76 seconds 153 data fit1tmp_smoke; 154 set hw3.Fit2; 155 if CURRENTSMOKER = 1; 156 run; NOTE: Variable CURRENTSMOKER is uninitialized. NOTE: There were 5580 observations read from the data set HW3.FIT2. NOTE: The data set WORK.FIT1TMP_SMOKE has 0 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 157 proc sgplot data=fit1tmp_smoke; 158 vbox cobmd/group=tx; 159 run; NOTE: There were 0 observations read from the data set. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   ... View more