SAS Support Communities

thanks for your support.  ... View more

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

Hello, Apologies for the delayed response—I was on annual leave.   I’ve moved the files out of the sasuser folder as suggested and attempted to rename them. However, I am still unable to run the program. I’ve attached some screenshots for your reference.   Thank you for your continued support! ... View more

thank you for your help! ... View more

Noted. Thank you for your help! ... View more

Hi, thank you for your reply. Below please find the log:    1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 Data CrossOver; 70 infile "/home/u44908311/sasuser.v94/Cross Over.txt"; 71 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference; 72 run;   ERROR: Physical file does not exist, /home/u44908311/sasuser.v94/Cross Over.txt. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.CROSSOVER may be incomplete. When this step was stopped there were 0 observations and 10 variables. WARNING: Data set WORK.CROSSOVER 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 692.59k OS Memory 24232.00k Timestamp 09/10/2024 04:28:39 PM Step Count 148 Switch Count 0 Page Faults 0 Page Reclaims 92 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8     73 74 proc print data = CrossOver; 75 run;   NOTE: There were 3 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 1246.50k OS Memory 24232.00k Timestamp 09/10/2024 04:28:39 PM Step Count 149 Switch Count 0 Page Faults 0 Page Reclaims 75 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8     76 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 332.56k OS Memory 24232.00k Timestamp 09/10/2024 04:28:39 PM Step Count 150 Switch Count 0 Page Faults 0 Page Reclaims 49 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0   ERROR: Variable SEQUENCE not found. NOTE: The SAS System stopped processing this step because of errors. 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; 83 84     85 Data CrossOverMissing; 86 infile "/home/u44908311/sasuser.v94/Cross Over Missing.txt"; 87 input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference; 88 run;   ERROR: Physical file does not exist, /home/u44908311/sasuser.v94/Cross Over Missing.txt. 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 684.50k OS Memory 24232.00k Timestamp 09/10/2024 04:28:39 PM Step Count 151 Switch Count 0 Page Faults 0 Page Reclaims 66 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 24     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.00 seconds system cpu time 0.00 seconds memory 657.31k OS Memory 24232.00k Timestamp 09/10/2024 04:28:39 PM Step Count 152 Switch Count 0 Page Faults 0 Page Reclaims 52 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 1 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 780.06k OS Memory 24488.00k Timestamp 09/10/2024 04:28:39 PM Step Count 153 Switch Count 0 Page Faults 0 Page Reclaims 95 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

Thanks for you reply, Jackie.   I amended the infile name as follows: infile "/home/u44908311/sasuser.v94/Cross Over.txt"; input Subject Gender $ BMI Age Sequence $ Period Treatment $ Baseline After Difference; run;   However, I received the following errors:  Errors (4)  ERROR: Physical file does not exist, /home/u44908311/sasuser.v94/Cross Over.txt.  ERROR: Variable SEQUENCE not found.  ERROR: Physical file does not exist, /home/u44908311/sasuser.v94/Cross Over Missing.txt.  ERROR: Invalid or missing data. ... View more