1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 /* Generated Code (IMPORT) */
70 /* Source File: SBP_n13.csv */
71 /* Source Path: /home/u44908311/food_crossover_project */
72 /* Code generated on: 9/27/24, 11:38 AM */
73
74 %web_drop_table(WORK.IMPORT);
NOTE: Table WORK.IMPORT has been dropped.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 205.25k
OS Memory 24484.00k
Timestamp 09/27/2024 10:44:10 AM
Step Count 69 Switch Count 2
Page Faults 0
Page Reclaims 14
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
75
76
77 FILENAME REFFILE '/home/u44908311/food_crossover_project/SBP_n13.csv';
78
79 PROC IMPORT DATAFILE=REFFILE
80 DBMS=CSV
81 OUT=WORK.IMPORT;
82 GETNAMES=YES;
83 RUN;
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
84 /**********************************************************************
85 * PRODUCT: SAS
86 * VERSION: 9.4
87 * CREATOR: External File Interface
88 * DATE: 27SEP24
89 * DESC: Generated SAS Datastep Code
90 * TEMPLATE SOURCE: (None Specified.)
91 ***********************************************************************/
92 data WORK.IMPORT ;
93 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
94 infile REFFILE delimiter = ',' MISSOVER DSD firstobs=2 ;
95 informat Subject best32. ;
96 informat Gender $1. ;
97 informat BMI best32. ;
98 informat Age best32. ;
99 informat Sequence $2. ;
100 informat Period best32. ;
101 informat Treatment $1. ;
102 informat Baseline best32. ;
103 informat After best32. ;
104 informat Difference best32. ;
105 format Subject best12. ;
106 format Gender $1. ;
107 format BMI best12. ;
108 format Age best12. ;
109 format Sequence $2. ;
110 format Period best12. ;
111 format Treatment $1. ;
112 format Baseline best12. ;
113 format After best12. ;
114 format Difference best12. ;
115 input
116 Subject
117 Gender $
118 BMI
119 Age
120 Sequence $
121 Period
122 Treatment $
123 Baseline
124 After
125 Difference
126 ;
127 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
128 run;
NOTE: The infile REFFILE is:
Filename=/home/u44908311/food_crossover_project/SBP_n13.csv,
Owner Name=u44908311,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Sep2024:15:42:38,
File Size (bytes)=887
NOTE: 26 records were read from the infile REFFILE.
The minimum record length was 26.
The maximum record length was 31.
NOTE: The data set WORK.IMPORT has 26 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 9295.50k
OS Memory 31260.00k
Timestamp 09/27/2024 10:44:10 AM
Step Count 70 Switch Count 2
Page Faults 0
Page Reclaims 138
Page Swaps 0
Voluntary Context Switches 15
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
26 rows created in WORK.IMPORT from REFFILE.
NOTE: WORK.IMPORT data set was successfully created.
NOTE: The data set WORK.IMPORT has 26 observations and 10 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
user cpu time 0.03 seconds
system cpu time 0.01 seconds
memory 9295.50k
OS Memory 31520.00k
Timestamp 09/27/2024 10:44:10 AM
Step Count 70 Switch Count 8
Page Faults 0
Page Reclaims 1367
Page Swaps 0
Voluntary Context Switches 75
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 320
129
130 PROC CONTENTS DATA=WORK.IMPORT; RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.02 seconds
user cpu time 0.03 seconds
system cpu time 0.00 seconds
memory 1750.96k
OS Memory 26028.00k
Timestamp 09/27/2024 10:44:10 AM
Step Count 71 Switch Count 0
Page Faults 0
Page Reclaims 95
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 3
Block Input Operations 0
Block Output Operations 8
131
132
133 %web_open_table(WORK.IMPORT);
134
135 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
145 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 Data CrossOver;
70 infile "/home/u44908311/food_crossover_project/FoodCrossOverExample.sas";
71 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference;
72 run;
NOTE: The infile "/home/u44908311/food_crossover_project/FoodCrossOverExample.sas" is:
Filename=/home/u44908311/food_crossover_project/FoodCrossOverExample.sas,
Owner Name=u44908311,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=27Sep2024:11:43:57,
File Size (bytes)=814
NOTE: Invalid data for Subject in line 1 1-4.
NOTE: Invalid data for BMI in line 2 3-8.
NOTE: Invalid data for Age in line 2 10-75.
NOTE: Invalid data for Period in line 3 9-15.
NOTE: Invalid data for Baseline in line 3 24-24.
NOTE: Invalid data for After in line 3 26-28.
NOTE: Invalid data for Difference in line 3 30-32.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
3 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference; 89
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=CrossOve BMI=. Age=. Sequence=input Period=. Treatment=Gender Baseline=. After=. Difference=. _ERROR_=1 _N_=1
NOTE: Invalid data for Subject in line 4 1-4.
NOTE: Invalid data for BMI in line 6 6-10.
NOTE: Invalid data for Age in line 6 12-15.
NOTE: Invalid data for Period in line 6 19-28.
NOTE: Invalid data for Baseline in line 9 1-4.
NOTE: Invalid data for After in line 9 6-10.
NOTE: Invalid data for Difference in line 9 12-15.
9 Proc Mixed data = CrossOver; 28
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=proc BMI=. Age=. Sequence== Period=. Treatment=run; Baseline=. After=. Difference=. _ERROR_=1 _N_=2
NOTE: Invalid data for Subject in line 10 3-7.
NOTE: Invalid data for BMI in line 10 17-22.
NOTE: Invalid data for Age in line 10 24-31.
NOTE: Invalid data for Period in line 10 40-49.
NOTE: Invalid data for Baseline in line 11 9-18.
NOTE: Invalid data for After in line 11 20-20.
NOTE: Invalid data for Difference in line 11 22-27.
11 model Difference = Gender BMI Age Period Treatment Baseline; 62
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=Subject BMI=. Age=. Sequence=Period Period=. Treatment=model Baseline=. After=. Difference=. _ERROR_=1 _N_=3
NOTE: Invalid data for Subject in line 12 3-8.
NOTE: Invalid data for BMI in line 13 3-9.
NOTE: Invalid data for Age in line 13 11-19.
NOTE: Invalid data for Period in line 13 23-28.
NOTE: Invalid data for Baseline in line 17 1-4.
NOTE: Invalid data for After in line 17 6-22.
NOTE: Invalid data for Difference in line 18 3-8.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
18 infile "CrossOverMissing"; 28
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=Subject; BMI=. Age=. Sequence=/ Period=. Treatment=run; Baseline=. After=. Difference=. _ERROR_=1 _N_=4
NOTE: Invalid data for Subject in line 19 3-7.
NOTE: Invalid data for BMI in line 19 17-22.
NOTE: Invalid data for Age in line 19 24-24.
NOTE: Invalid data for Period in line 19 30-32.
NOTE: Invalid data for Baseline in line 19 43-43.
NOTE: Invalid data for After in line 19 45-50.
NOTE: Invalid data for Difference in line 19 52-60.
19 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference; 89
Subject=. Gender=Subject BMI=. Age=. Sequence=BMI Period=. Treatment=Sequence Baseline=. After=. Difference=. _ERROR_=1 _N_=5
NOTE: Invalid data for Subject in line 20 1-4.
NOTE: Invalid data for BMI in line 22 6-10.
NOTE: Invalid data for Age in line 22 12-15.
NOTE: Invalid data for Period in line 22 19-35.
NOTE: Invalid data for Baseline in line 25 1-4.
NOTE: Invalid data for After in line 25 6-10.
NOTE: Invalid data for Difference in line 25 12-15.
25 Proc Mixed data = CrossOverMissing; 35
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=proc BMI=. Age=. Sequence== Period=. Treatment=run; Baseline=. After=. Difference=. _ERROR_=1 _N_=6
NOTE: Invalid data for Subject in line 26 3-7.
NOTE: Invalid data for BMI in line 26 17-22.
NOTE: Invalid data for Age in line 26 24-31.
NOTE: Invalid data for Period in line 26 40-49.
NOTE: Invalid data for Baseline in line 27 9-18.
NOTE: Invalid data for After in line 27 20-20.
NOTE: Invalid data for Difference in line 27 22-27.
27 model Difference = Gender BMI Age Period Treatment Baseline; 62
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=Subject BMI=. Age=. Sequence=Period Period=. Treatment=model Baseline=. After=. Difference=. _ERROR_=1 _N_=7
NOTE: Invalid data for Subject in line 28 3-8.
NOTE: Invalid data for BMI in line 29 3-9.
NOTE: Invalid data for Age in line 29 11-19.
NOTE: Invalid data for Period in line 29 23-28.
NOTE: LOST CARD.
NOTE: Invalid data errors for file '"/home/u44908311/food_crossover_project/FoodCrossOverExample.sas"' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
Subject=. Gender=Subject; BMI=. Age=. Sequence=/ Period=. Treatment=run; Baseline=. After=. Difference=. _ERROR_=1 _N_=8
NOTE: 34 records were read from the infile "/home/u44908311/food_crossover_project/FoodCrossOverExample.sas".
The minimum record length was 0.
The maximum record length was 89.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.CROSSOVER has 7 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 789.03k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 58 Switch Count 2
Page Faults 0
Page Reclaims 87
Page Swaps 0
Voluntary Context Switches 15
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 288
73
74 proc print data = CrossOver;
75 run;
NOTE: There were 7 observations read from the data set WORK.CROSSOVER.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1230.03k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 59 Switch Count 0
Page Faults 0
Page Reclaims 63
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 8
76
77 Proc Mixed data = CrossOver;
78 class Subject Gender Sequence Period Treatment;
79 model Difference = Gender BMI Age Period Treatment Baseline;
80 random Subject;
81 lsmeans treatment / pdiff;
82 run;
ERROR: Invalid or missing data.
NOTE: PROCEDURE MIXED used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 786.81k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 60 Switch Count 0
Page Faults 0
Page Reclaims 89
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
83
84
85 Data CrossOverMissing;
86 infile "CrossOverMissing";
87 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference;
88 run;
ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/CrossOverMissing.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CROSSOVERMISSING may be incomplete. When this step was stopped there were 0 observations and 10
variables.
WARNING: Data set WORK.CROSSOVERMISSING was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 677.78k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 61 Switch Count 0
Page Faults 0
Page Reclaims 55
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
89
90 proc print data = CrossOverMissing;
91 run;
NOTE: No observations in data set WORK.CROSSOVERMISSING.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 635.15k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 62 Switch Count 0
Page Faults 0
Page Reclaims 50
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
92
93 Proc Mixed data = CrossOverMissing;
94 class Subject Gender Sequence Period Treatment;
95 model Difference = Gender BMI Age Period Treatment Baseline;
96 random Subject;
97 lsmeans treatment / pdiff;
98 run;
ERROR: Invalid or missing data.
NOTE: PROCEDURE MIXED used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 595.15k
OS Memory 25256.00k
Timestamp 09/27/2024 10:44:00 AM
Step Count 63 Switch Count 0
Page Faults 0
Page Reclaims 59
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
99
100
101
102
103
104
105 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
115
... View more