I'm working on a class project. Attached is the XLSX file I am working with. On the first project, I wrote the following code: LIBNAME Check XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx";
LIBNAME Check CLEAR;
LIBNAME CoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx";
DATA CoImpt.Poverty;
SET CoImpt.Poverty;
RUN;
PROC TRANSPOSE DATA=CoImpt.Poverty OUT=CoImpt.tPOVERTY;
RUN;
PROC PRINT
DATA = CoImpt.Poverty;
RUN;
PROC CONTENTS DATA=coimpt.tPoverty;
RUN; And here is the log for this code: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 LIBNAME Check XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx";
NOTE: Libref CHECK was successfully assigned as follows:
Engine: XLSX
Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/poverty.xlsx
70 LIBNAME Check CLEAR;
NOTE: Libref CHECK has been deassigned.
71
72 LIBNAMECoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx";
NOTE: Libref COIMPT was successfully assigned as follows:
Engine: XLSX
Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/poverty.xlsx
73
74 DATA CoImpt.Poverty;
75 SET CoImpt.Poverty;
76 RUN;
NOTE: The import data set has 0 observations and 1 variables.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
NOTE: The data set COIMPT.Poverty has 0 observations and 1 variables.
NOTE: The export data set has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
user cpu time 0.05 seconds
system cpu time 0.01 seconds
memory 7988.53k
OS Memory 27756.00k
Timestamp 11/05/2023 02:37:31 AM
Step Count 39 Switch Count 1
Page Faults 0
Page Reclaims 2782
Page Swaps 0
Voluntary Context Switches 41
Involuntary Context Switches 0
Block Input Operations 128
Block Output Operations 184
77 PROC TRANSPOSE DATA=CoImpt.Poverty OUT=CoImpt.tPOVERTY;
78 RUN;
NOTE: No variables to transpose.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
NOTE: The data set COIMPT.tPOVERTY has 0 observations and 1 variables.
NOTE: The export data set has 0 observations and 1 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.06 seconds
user cpu time 0.05 seconds
system cpu time 0.00 seconds
memory 7977.31k
OS Memory 28012.00k
Timestamp 11/05/2023 02:37:32 AM
Step Count 40 Switch Count 1
Page Faults 0
Page Reclaims 2378
Page Swaps 0
Voluntary Context Switches 41
Involuntary Context Switches 0
Block Input Operations 176
Block Output Operations 176
78 !
79
80 PROC PRINT
81 DATA = CoImpt.Poverty;
82 RUN;
NOTE: Access by observation number not available. Observation numbers will be counted by PROC PRINT.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: No observations in data set COIMPT.Poverty.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
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 3986.59k
OS Memory 23028.00k
Timestamp 11/05/2023 02:37:32 AM
Step Count 41 Switch Count 0
Page Faults 0
Page Reclaims 783
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 48
Block Output Operations 0
83
83 ! PROC CONTENTS DATA=coimpt.tPoverty;
84 RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.03 seconds
user cpu time 0.02 seconds
system cpu time 0.01 seconds
memory 5223.06k
OS Memory 24056.00k
Timestamp 11/05/2023 02:37:32 AM
Step Count 42 Switch Count 0
Page Faults 0
Page Reclaims 1037
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
85
86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
96 This worked fine until now, and for some reason, now nothing is showing up in the output data. In the current project, I wrote this code: PROC PRINT DATA = CoImpt.Poverty;
RUN;
PROC TRANSPOSE DATA = CoImpt.Poverty;
RUN;
PROC PRINT DATA = CoImpt.Poverty;
RUN; And here is the log for this code: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 PROC PRINT DATA = CoImpt.Poverty;
70 RUN;
NOTE: Access by observation number not available. Observation numbers will be counted by PROC PRINT.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: No observations in data set COIMPT.Poverty.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
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 3992.46k
OS Memory 26052.00k
Timestamp 11/05/2023 02:37:37 AM
Step Count 48 Switch Count 0
Page Faults 0
Page Reclaims 956
Page Swaps 0
Voluntary Context Switches 13
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
71
72 PROC TRANSPOSEDATA = CoImpt.Poverty;
73 RUN;
NOTE: No variables to transpose.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
NOTE: The data set WORK.DATA3 has 0 observations and 1 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.01 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 4362.15k
OS Memory 26312.00k
Timestamp 11/05/2023 02:37:37 AM
Step Count 49 Switch Count 2
Page Faults 0
Page Reclaims 734
Page Swaps 0
Voluntary Context Switches 17
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
74
75 PROC PRINT DATA = CoImpt.Poverty;
76 RUN;
NOTE: Access by observation number not available. Observation numbers will be counted by PROC PRINT.
NOTE: The import data set has 0 observations and 1 variables.
NOTE: No observations in data set COIMPT.Poverty.
NOTE: There were 0 observations read from the data set COIMPT.Poverty.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 3992.46k
OS Memory 26052.00k
Timestamp 11/05/2023 02:37:37 AM
Step Count 50 Switch Count 0
Page Faults 0
Page Reclaims 664
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
77
78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
88 It was also working earlier, and now it is not. I don't know why it stopped working, and I don't know how to fix it. There are no errors or messages in the log for either section of code. I was working on removing the word "FIPS" from each observation after it is transposed, but I am not sure how to do that with a base xlsx file. Any help greatly appreciated.
... View more
