topic PROC FACTOR "ERROR - All observations in dataset have missing values" in SAS Procedures

PROC FACTOR "ERROR - All observations in dataset have missing values"

mspswede — Wed, 14 Aug 2019 18:37:01 GMT

Hi, I'm working in SAS Studio trying to run a PROC FACTOR but keep getting this error message: "ERROR - All observations in dataset have missing values".

I know that my data file is working just fine, as I can run other PROCS on it, although I have gotten the response regarding a couple of columns "variable (name) not found".

data Telco2;
title 'Principal Component Analysis';
infile "/home/johnfranklin0/EPG194/data/Telco2.csv";
input Tenure Contract InternetService Contract
PaymentMethod MonthlyCharges;

proc factor data=Telco2 simple corr;
run;

I will appreciate any help anyone can offer!

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

PaigeMiller — Wed, 14 Aug 2019 18:50:36 GMT

@mspswede wrote:

Hi, I'm working in SAS Studio trying to run a PROC FACTOR but keep getting this error message: "ERROR - All observations in dataset have missing values".

I know that my data file is working just fine, as I can run other PROCS on it, although I have gotten the response regarding a couple of columns "variable (name) not found".

Honestly, the fact that other PROCs are not having problems is irrelevant here. You have to look at the data set TELCO (not the file Telco2.csv) and see the missings and variable names for yourself.

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

Reeza — Wed, 14 Aug 2019 18:56:58 GMT

@mspswede wrote:

Hi, I'm working in SAS Studio trying to run a PROC FACTOR but keep getting this error message: "ERROR - All observations in dataset have missing values".

I know that my data file is working just fine, as I can run other PROCS on it, although I have gotten the response regarding a couple of columns "variable (name) not found".

data Telco2;
title 'Principal Component Analysis';
infile "/home/johnfranklin0/EPG194/data/Telco2.csv";
input Tenure Contract InternetService Contract
PaymentMethod MonthlyCharges;

proc factor data=Telco2 simple corr;
run;

I will appreciate any help anyone can offer!

Post your log with the error from the code above. I'd be surprised to not see errors in the data step since you haven't specified any types or lengths. If all your variables are numeric that may have worked, but that's usually not the case.

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

mspswede — Wed, 14 Aug 2019 19:01:34 GMT

Thank you both...here's the (long) log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data Telco2;

74 title 'Principal Component Analysis';

75 infile "/home/johnfranklin0/EPG194/data/Telco2.csv";

76 input Tenure Contract InternetService Contract PaymentMethod MonthlyCharges;

NOTE: The infile "/home/johnfranklin0/EPG194/data/Telco2.csv" is:

Filename=/home/johnfranklin0/EPG194/data/Telco2.csv,

Owner Name=johnfranklin0,Group Name=UNKNOWN,

Access Permission=-rw-r--r--,

Last Modified=14Aug2019:08:32:44,

File Size (bytes)=404207

NOTE: Invalid data for Tenure in line 1 1-226.

NOTE: Invalid data for Contract in line 1 228-241.

NOTE: Invalid data for InternetService in line 1 243-243.

NOTE: Invalid data for Contract in line 1 245-256.

NOTE: Invalid data for PaymentMethod in line 1 258-264.

NOTE: Invalid data for MonthlyCharges in line 2 1-53.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

2 7590-VHVEG,1,0,1,0,1,0,2,1,0,1,0,0,0,0,0,1,0,30,30,0, 53

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=1

NOTE: Invalid data for Tenure in line 3 1-56.

NOTE: Invalid data for Contract in line 4 1-54.

NOTE: Invalid data for InternetService in line 5 1-56.

NOTE: Invalid data for Contract in line 6 1-54.

NOTE: Invalid data for PaymentMethod in line 7 1-55.

NOTE: Invalid data for MonthlyCharges in line 8 1-56.

8 1452-KIOVK,0,0,0,1,22,1,1,2,0,1,0,0,1,0,0,1,3,89,1949,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=2

NOTE: Invalid data for Tenure in line 9 1-55.

NOTE: Invalid data for Contract in line 10 1-57.

NOTE: Invalid data for InternetService in line 11 1-56.

NOTE: Invalid data for Contract in line 12 1-55.

NOTE: Invalid data for PaymentMethod in line 13 1-55.

NOTE: Invalid data for MonthlyCharges in line 14 1-57.

14 8091-TTVAX,0,0,1,0,58,1,1,2,0,0,1,0,1,1,1,0,3,100,5681,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=3

NOTE: Invalid data for Tenure in line 15 1-57.

NOTE: Invalid data for Contract in line 16 1-57.

NOTE: Invalid data for InternetService in line 17 1-57.

NOTE: Invalid data for Contract in line 18 1-56.

NOTE: Invalid data for PaymentMethod in line 19 1-57.

NOTE: Invalid data for MonthlyCharges in line 20 1-55.

20 4190-MFLUW,1,0,1,1,10,1,0,1,0,0,1,1,0,0,0,0,3,55,528,1, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=4

NOTE: Invalid data for Tenure in line 21 1-56.

NOTE: Invalid data for Contract in line 22 1-53.

NOTE: Invalid data for InternetService in line 23 1-55.

NOTE: Invalid data for Contract in line 24 1-53.

NOTE: Invalid data for PaymentMethod in line 25 1-56.

NOTE: Invalid data for MonthlyCharges in line 26 1-56.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

26 6322-HRPFA,0,0,1,1,49,1,0,1,1,1,0,1,0,0,0,0,3,60,2970,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=5

NOTE: Invalid data for Tenure in line 27 1-56.

NOTE: Invalid data for Contract in line 28 1-56.

NOTE: Invalid data for InternetService in line 29 1-53.

NOTE: Invalid data for Contract in line 30 1-56.

NOTE: Invalid data for PaymentMethod in line 31 1-56.

NOTE: Invalid data for MonthlyCharges in line 32 1-56.

32 3841-NFECX,1,1,1,0,71,1,1,2,1,1,1,1,0,0,2,1,3,96,6767,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=6

NOTE: Invalid data for Tenure in line 33 1-54.

NOTE: Invalid data for Contract in line 34 1-56.

NOTE: Invalid data for InternetService in line 35 1-53.

NOTE: Invalid data for Contract in line 36 1-53.

NOTE: Invalid data for PaymentMethod in line 37 1-57.

NOTE: Invalid data for MonthlyCharges in line 38 1-54.

38 6047-YHPVI,0,0,0,0,5,1,0,2,0,0,0,0,0,0,0,1,0,70,317,1, 54

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=7

NOTE: Invalid data for Tenure in line 39 1-56.

NOTE: Invalid data for Contract in line 40 1-57.

NOTE: Invalid data for InternetService in line 41 1-56.

NOTE: Invalid data for Contract in line 42 1-55.

NOTE: Invalid data for PaymentMethod in line 43 1-56.

NOTE: Invalid data for MonthlyCharges in line 44 1-55.

44 9867-JCZSP,1,0,1,1,17,1,0,0,2,2,2,2,2,2,1,0,1,21,418,0, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=8

NOTE: Invalid data for Tenure in line 45 1-56.

NOTE: Invalid data for Contract in line 46 1-55.

NOTE: Invalid data for InternetService in line 47 1-56.

NOTE: Invalid data for Contract in line 48 1-53.

NOTE: Invalid data for PaymentMethod in line 49 1-54.

NOTE: Invalid data for MonthlyCharges in line 50 1-56.

50 7639-LIAYI,0,0,0,0,52,1,1,1,1,0,0,1,1,1,2,1,3,80,4218,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=9

NOTE: Invalid data for Tenure in line 51 1-56.

NOTE: Invalid data for Contract in line 52 1-56.

NOTE: Invalid data for InternetService in line 53 1-56.

NOTE: Invalid data for Contract in line 54 1-56.

NOTE: Invalid data for PaymentMethod in line 55 1-54.

NOTE: Invalid data for MonthlyCharges in line 56 1-56.

56 4667-QONEA,1,1,1,1,60,1,0,1,1,1,1,1,0,1,1,1,3,75,4456,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=10

NOTE: Invalid data for Tenure in line 57 1-56.

NOTE: Invalid data for Contract in line 58 1-57.

NOTE: Invalid data for InternetService in line 59 1-57.

NOTE: Invalid data for Contract in line 60 1-55.

NOTE: Invalid data for PaymentMethod in line 61 1-57.

NOTE: Invalid data for MonthlyCharges in line 62 1-57.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

62 0434-CSFON,1,0,1,0,47,1,1,2,0,0,1,0,1,1,0,1,0,101,4707,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=11

NOTE: Invalid data for Tenure in line 63 1-56.

NOTE: Invalid data for Contract in line 64 1-56.

NOTE: Invalid data for InternetService in line 65 1-55.

NOTE: Invalid data for Contract in line 66 1-54.

NOTE: Invalid data for PaymentMethod in line 67 1-54.

NOTE: Invalid data for MonthlyCharges in line 68 1-56.

68 8627-ZYGSZ,0,0,1,0,47,1,1,2,0,1,0,0,0,0,1,1,0,79,3650,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=12

NOTE: Invalid data for Tenure in line 69 1-56.

NOTE: Invalid data for Contract in line 70 1-55.

NOTE: Invalid data for InternetService in line 71 1-55.

NOTE: Invalid data for Contract in line 72 1-53.

NOTE: Invalid data for PaymentMethod in line 73 1-56.

NOTE: Invalid data for MonthlyCharges in line 74 1-57.

74 1891-QRQSA,0,1,1,1,64,1,1,2,1,0,1,1,1,1,2,1,2,112,7099,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=13

NOTE: Invalid data for Tenure in line 75 1-56.

NOTE: Invalid data for Contract in line 76 1-54.

NOTE: Invalid data for InternetService in line 77 1-57.

NOTE: Invalid data for Contract in line 78 1-56.

NOTE: Invalid data for PaymentMethod in line 79 1-54.

NOTE: Invalid data for MonthlyCharges in line 80 1-56.

80 0191-ZHSKZ,0,1,0,0,30,1,0,1,1,1,0,0,1,1,0,1,0,75,2111,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=14

NOTE: Invalid data for Tenure in line 81 1-56.

NOTE: Invalid data for Contract in line 82 1-53.

NOTE: Invalid data for InternetService in line 83 1-55.

NOTE: Invalid data for Contract in line 84 1-54.

NOTE: Invalid data for PaymentMethod in line 85 1-57.

NOTE: Invalid data for MonthlyCharges in line 86 1-55.

86 0318-ZOPWS,1,0,1,0,49,1,0,0,2,2,2,2,2,2,2,1,2,20,973,0, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=15

NOTE: Invalid data for Tenure in line 87 1-54.

NOTE: Invalid data for Contract in line 88 1-56.

NOTE: Invalid data for InternetService in line 89 1-56.

NOTE: Invalid data for Contract in line 90 1-55.

NOTE: Invalid data for PaymentMethod in line 91 1-56.

NOTE: Invalid data for MonthlyCharges in line 92 1-56.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

92 4767-HZZHQ,0,0,1,1,30,1,0,2,0,1,1,0,0,0,0,0,2,82,2570,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=16

NOTE: Invalid data for Tenure in line 93 1-53.

NOTE: Invalid data for Contract in line 94 1-56.

NOTE: Invalid data for InternetService in line 95 1-57.

NOTE: Invalid data for Contract in line 96 1-57.

NOTE: Invalid data for PaymentMethod in line 97 1-55.

NOTE: Invalid data for MonthlyCharges in line 98 1-56.

98 9803-FTJCG,0,0,1,1,71,1,1,1,1,1,0,1,0,0,1,1,3,67,4749,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=17

NOTE: Invalid data for Tenure in line 99 1-54.

NOTE: Invalid data for Contract in line 100 1-56.

NOTE: Invalid data for InternetService in line 101 1-56.

NOTE: Invalid data for Contract in line 102 1-53.

NOTE: Invalid data for PaymentMethod in line 103 1-53.

NOTE: Invalid data for MonthlyCharges in line 104 1-56.

104 7123-WQUHX,0,0,0,0,38,1,1,2,0,0,1,1,1,0,1,0,2,95,3606,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=18

NOTE: Invalid data for Tenure in line 105 1-56.

NOTE: Invalid data for Contract in line 106 1-57.

NOTE: Invalid data for InternetService in line 107 1-54.

NOTE: Invalid data for Contract in line 108 1-57.

NOTE: Invalid data for PaymentMethod in line 109 1-55.

NOTE: Invalid data for MonthlyCharges in line 110 1-56.

110 8597-CWYHH,0,0,0,0,43,1,1,2,0,0,0,0,1,1,1,0,1,94,3921,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=19

NOTE: Invalid data for Tenure in line 111 1-56.

NOTE: Invalid data for Contract in line 112 1-56.

NOTE: Invalid data for InternetService in line 113 1-56.

NOTE: Invalid data for Contract in line 114 1-56.

NOTE: Invalid data for PaymentMethod in line 115 1-56.

NOTE: Invalid data for MonthlyCharges in line 116 1-56.

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

116 5256-SKJGO,1,0,1,1,64,0,2,1,0,1,0,1,1,1,2,1,0,55,3424,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=20

NOTE: LOST CARD.

NOTE: 7047 records were read from the infile "/home/johnfranklin0/EPG194/data/Telco2.csv".

The minimum record length was 21.

The maximum record length was 264.

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.TELCO2 has 1176 observations and 5 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 908.50k

OS Memory 36276.00k

Timestamp 08/14/2019 07:00:15 PM

Step Count 159 Switch Count 3

Page Faults 0

Page Reclaims 175

Page Swaps 0

Voluntary Context Switches 26

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

78 proc factor data=Telco2 simple corr;

79 run;

WARNING: 1176 of 1176 observations in data set WORK.TELCO2 omitted due to missing values.

ERROR: All observations in data set WORK.TELCO2 have missing values, or the sum of weights or frequencies is nonpositive.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE FACTOR used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 871.25k

OS Memory 36276.00k

Timestamp 08/14/2019 07:00:15 PM

Step Count 160 Switch Count 0

Page Faults 0

Page Reclaims 138

Page Swaps 0

Voluntary Context Switches 10

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 8

81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

PaigeMiller — Wed, 14 Aug 2019 19:06:10 GMT

As I suspected, the log shows that you are not properly reading telco2.csv into a SAS data set TECLO. The log is showing "invalid data" and so the resulting SAS data set named TELCO has lots of (maybe 100%) missings.

And so, if you had looked at data set TELCO, you would see the missings. Looking at the data sets is a very good debugging technique, highly recommended.

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

Reeza — Wed, 14 Aug 2019 19:53:20 GMT

You have 6 variables listed in the INPUT statement but your data appears to have many more columns:

2 7590-VHVEG,1,0,1,0,1,0,2,1,0,1,0,0,0,0,0,1,0,30,30,0, 53

If you're new, I would suggest using PROC IMPORT to get you moving forward but you should really be reading your logs.

proc import out=telco2 datafile="/home/johnfranklin0/EGP194/data/Telco2.csv" dbms=csv replace; 
guessingrows=max;
run;

proc factor data=telco2 simple corr;
run;

@mspswede wrote:

Thank you both...here's the (long) log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 data Telco2;

74 title 'Principal Component Analysis';

75 infile "/home/johnfranklin0/EPG194/data/Telco2.csv";

76 input Tenure Contract InternetService Contract PaymentMethod MonthlyCharges;

77

NOTE: The infile "/home/johnfranklin0/EPG194/data/Telco2.csv" is:

Filename=/home/johnfranklin0/EPG194/data/Telco2.csv,

Owner Name=johnfranklin0,Group Name=UNKNOWN,

Access Permission=-rw-r--r--,

Last Modified=14Aug2019:08:32:44,

File Size (bytes)=404207

NOTE: Invalid data for Tenure in line 1 1-226.

NOTE: Invalid data for Contract in line 1 228-241.

NOTE: Invalid data for InternetService in line 1 243-243.

NOTE: Invalid data for Contract in line 1 245-256.

NOTE: Invalid data for PaymentMethod in line 1 258-264.

NOTE: Invalid data for MonthlyCharges in line 2 1-53.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

2 7590-VHVEG,1,0,1,0,1,0,2,1,0,1,0,0,0,0,0,1,0,30,30,0, 53

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=1

NOTE: Invalid data for Tenure in line 3 1-56.

NOTE: Invalid data for Contract in line 4 1-54.

NOTE: Invalid data for InternetService in line 5 1-56.

NOTE: Invalid data for Contract in line 6 1-54.

NOTE: Invalid data for PaymentMethod in line 7 1-55.

NOTE: Invalid data for MonthlyCharges in line 8 1-56.

8 1452-KIOVK,0,0,0,1,22,1,1,2,0,1,0,0,1,0,0,1,3,89,1949,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=2

NOTE: Invalid data for Tenure in line 9 1-55.

NOTE: Invalid data for Contract in line 10 1-57.

NOTE: Invalid data for InternetService in line 11 1-56.

NOTE: Invalid data for Contract in line 12 1-55.

NOTE: Invalid data for PaymentMethod in line 13 1-55.

NOTE: Invalid data for MonthlyCharges in line 14 1-57.

14 8091-TTVAX,0,0,1,0,58,1,1,2,0,0,1,0,1,1,1,0,3,100,5681,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=3

NOTE: Invalid data for Tenure in line 15 1-57.

NOTE: Invalid data for Contract in line 16 1-57.

NOTE: Invalid data for InternetService in line 17 1-57.

NOTE: Invalid data for Contract in line 18 1-56.

NOTE: Invalid data for PaymentMethod in line 19 1-57.

NOTE: Invalid data for MonthlyCharges in line 20 1-55.

20 4190-MFLUW,1,0,1,1,10,1,0,1,0,0,1,1,0,0,0,0,3,55,528,1, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=4

NOTE: Invalid data for Tenure in line 21 1-56.

NOTE: Invalid data for Contract in line 22 1-53.

NOTE: Invalid data for InternetService in line 23 1-55.

NOTE: Invalid data for Contract in line 24 1-53.

NOTE: Invalid data for PaymentMethod in line 25 1-56.

NOTE: Invalid data for MonthlyCharges in line 26 1-56.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

26 6322-HRPFA,0,0,1,1,49,1,0,1,1,1,0,1,0,0,0,0,3,60,2970,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=5

NOTE: Invalid data for Tenure in line 27 1-56.

NOTE: Invalid data for Contract in line 28 1-56.

NOTE: Invalid data for InternetService in line 29 1-53.

NOTE: Invalid data for Contract in line 30 1-56.

NOTE: Invalid data for PaymentMethod in line 31 1-56.

NOTE: Invalid data for MonthlyCharges in line 32 1-56.

32 3841-NFECX,1,1,1,0,71,1,1,2,1,1,1,1,0,0,2,1,3,96,6767,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=6

NOTE: Invalid data for Tenure in line 33 1-54.

NOTE: Invalid data for Contract in line 34 1-56.

NOTE: Invalid data for InternetService in line 35 1-53.

NOTE: Invalid data for Contract in line 36 1-53.

NOTE: Invalid data for PaymentMethod in line 37 1-57.

NOTE: Invalid data for MonthlyCharges in line 38 1-54.

38 6047-YHPVI,0,0,0,0,5,1,0,2,0,0,0,0,0,0,0,1,0,70,317,1, 54

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=7

NOTE: Invalid data for Tenure in line 39 1-56.

NOTE: Invalid data for Contract in line 40 1-57.

NOTE: Invalid data for InternetService in line 41 1-56.

NOTE: Invalid data for Contract in line 42 1-55.

NOTE: Invalid data for PaymentMethod in line 43 1-56.

NOTE: Invalid data for MonthlyCharges in line 44 1-55.

44 9867-JCZSP,1,0,1,1,17,1,0,0,2,2,2,2,2,2,1,0,1,21,418,0, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=8

NOTE: Invalid data for Tenure in line 45 1-56.

NOTE: Invalid data for Contract in line 46 1-55.

NOTE: Invalid data for InternetService in line 47 1-56.

NOTE: Invalid data for Contract in line 48 1-53.

NOTE: Invalid data for PaymentMethod in line 49 1-54.

NOTE: Invalid data for MonthlyCharges in line 50 1-56.

50 7639-LIAYI,0,0,0,0,52,1,1,1,1,0,0,1,1,1,2,1,3,80,4218,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=9

NOTE: Invalid data for Tenure in line 51 1-56.

NOTE: Invalid data for Contract in line 52 1-56.

NOTE: Invalid data for InternetService in line 53 1-56.

NOTE: Invalid data for Contract in line 54 1-56.

NOTE: Invalid data for PaymentMethod in line 55 1-54.

NOTE: Invalid data for MonthlyCharges in line 56 1-56.

56 4667-QONEA,1,1,1,1,60,1,0,1,1,1,1,1,0,1,1,1,3,75,4456,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=10

NOTE: Invalid data for Tenure in line 57 1-56.

NOTE: Invalid data for Contract in line 58 1-57.

NOTE: Invalid data for InternetService in line 59 1-57.

NOTE: Invalid data for Contract in line 60 1-55.

NOTE: Invalid data for PaymentMethod in line 61 1-57.

NOTE: Invalid data for MonthlyCharges in line 62 1-57.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

62 0434-CSFON,1,0,1,0,47,1,1,2,0,0,1,0,1,1,0,1,0,101,4707,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=11

NOTE: Invalid data for Tenure in line 63 1-56.

NOTE: Invalid data for Contract in line 64 1-56.

NOTE: Invalid data for InternetService in line 65 1-55.

NOTE: Invalid data for Contract in line 66 1-54.

NOTE: Invalid data for PaymentMethod in line 67 1-54.

NOTE: Invalid data for MonthlyCharges in line 68 1-56.

68 8627-ZYGSZ,0,0,1,0,47,1,1,2,0,1,0,0,0,0,1,1,0,79,3650,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=12

NOTE: Invalid data for Tenure in line 69 1-56.

NOTE: Invalid data for Contract in line 70 1-55.

NOTE: Invalid data for InternetService in line 71 1-55.

NOTE: Invalid data for Contract in line 72 1-53.

NOTE: Invalid data for PaymentMethod in line 73 1-56.

NOTE: Invalid data for MonthlyCharges in line 74 1-57.

74 1891-QRQSA,0,1,1,1,64,1,1,2,1,0,1,1,1,1,2,1,2,112,7099,0, 57

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=13

NOTE: Invalid data for Tenure in line 75 1-56.

NOTE: Invalid data for Contract in line 76 1-54.

NOTE: Invalid data for InternetService in line 77 1-57.

NOTE: Invalid data for Contract in line 78 1-56.

NOTE: Invalid data for PaymentMethod in line 79 1-54.

NOTE: Invalid data for MonthlyCharges in line 80 1-56.

80 0191-ZHSKZ,0,1,0,0,30,1,0,1,1,1,0,0,1,1,0,1,0,75,2111,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=14

NOTE: Invalid data for Tenure in line 81 1-56.

NOTE: Invalid data for Contract in line 82 1-53.

NOTE: Invalid data for InternetService in line 83 1-55.

NOTE: Invalid data for Contract in line 84 1-54.

NOTE: Invalid data for PaymentMethod in line 85 1-57.

NOTE: Invalid data for MonthlyCharges in line 86 1-55.

86 0318-ZOPWS,1,0,1,0,49,1,0,0,2,2,2,2,2,2,2,1,2,20,973,0, 55

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=15

NOTE: Invalid data for Tenure in line 87 1-54.

NOTE: Invalid data for Contract in line 88 1-56.

NOTE: Invalid data for InternetService in line 89 1-56.

NOTE: Invalid data for Contract in line 90 1-55.

NOTE: Invalid data for PaymentMethod in line 91 1-56.

NOTE: Invalid data for MonthlyCharges in line 92 1-56.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

92 4767-HZZHQ,0,0,1,1,30,1,0,2,0,1,1,0,0,0,0,0,2,82,2570,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=16

NOTE: Invalid data for Tenure in line 93 1-53.

NOTE: Invalid data for Contract in line 94 1-56.

NOTE: Invalid data for InternetService in line 95 1-57.

NOTE: Invalid data for Contract in line 96 1-57.

NOTE: Invalid data for PaymentMethod in line 97 1-55.

NOTE: Invalid data for MonthlyCharges in line 98 1-56.

98 9803-FTJCG,0,0,1,1,71,1,1,1,1,1,0,1,0,0,1,1,3,67,4749,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=17

NOTE: Invalid data for Tenure in line 99 1-54.

NOTE: Invalid data for Contract in line 100 1-56.

NOTE: Invalid data for InternetService in line 101 1-56.

NOTE: Invalid data for Contract in line 102 1-53.

NOTE: Invalid data for PaymentMethod in line 103 1-53.

NOTE: Invalid data for MonthlyCharges in line 104 1-56.

104 7123-WQUHX,0,0,0,0,38,1,1,2,0,0,1,1,1,0,1,0,2,95,3606,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=18

NOTE: Invalid data for Tenure in line 105 1-56.

NOTE: Invalid data for Contract in line 106 1-57.

NOTE: Invalid data for InternetService in line 107 1-54.

NOTE: Invalid data for Contract in line 108 1-57.

NOTE: Invalid data for PaymentMethod in line 109 1-55.

NOTE: Invalid data for MonthlyCharges in line 110 1-56.

110 8597-CWYHH,0,0,0,0,43,1,1,2,0,0,0,0,1,1,1,0,1,94,3921,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=19

NOTE: Invalid data for Tenure in line 111 1-56.

NOTE: Invalid data for Contract in line 112 1-56.

NOTE: Invalid data for InternetService in line 113 1-56.

NOTE: Invalid data for Contract in line 114 1-56.

NOTE: Invalid data for PaymentMethod in line 115 1-56.

NOTE: Invalid data for MonthlyCharges in line 116 1-56.

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

116 5256-SKJGO,1,0,1,1,64,0,2,1,0,1,0,1,1,1,2,1,0,55,3424,0, 56

NOTE: Invalid data errors for file '"/home/johnfranklin0/EPG194/data/Telco2.csv"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tenure=. Contract=. InternetService=. PaymentMethod=. MonthlyCharges=. _ERROR_=1 _N_=20

NOTE: LOST CARD.

NOTE: 7047 records were read from the infile "/home/johnfranklin0/EPG194/data/Telco2.csv".

The minimum record length was 21.

The maximum record length was 264.

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.TELCO2 has 1176 observations and 5 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 908.50k

OS Memory 36276.00k

Timestamp 08/14/2019 07:00:15 PM

Step Count 159 Switch Count 3

Page Faults 0

Page Reclaims 175

Page Swaps 0

Voluntary Context Switches 26

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

78 proc factor data=Telco2 simple corr;

79 run;

WARNING: 1176 of 1176 observations in data set WORK.TELCO2 omitted due to missing values.

ERROR: All observations in data set WORK.TELCO2 have missing values, or the sum of weights or frequencies is nonpositive.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE FACTOR used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 871.25k

OS Memory 36276.00k

Timestamp 08/14/2019 07:00:15 PM

Step Count 160 Switch Count 0

Page Faults 0

Page Reclaims 138

Page Swaps 0

Voluntary Context Switches 10

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 8

80

81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

94

Re: PROC FACTOR "ERROR - All observations in dataset have missing values"

data_null__ — Wed, 14 Aug 2019 22:15:03 GMT

@mspswede wrote:

Hi, I'm working in SAS Studio trying to run a PROC FACTOR but keep getting this error message: "ERROR - All observations in dataset have missing values".

I know that my data file is working just fine, as I can run other PROCS on it, although I have gotten the response regarding a couple of columns "variable (name) not found".

data Telco2;
title 'Principal Component Analysis';
infile "/home/johnfranklin0/EPG194/data/Telco2.csv";
input Tenure Contract InternetService Contract
PaymentMethod MonthlyCharges;

proc factor data=Telco2 simple corr;
run;

I will appreciate any help anyone can offer!

If your data are truly CSV then at least you need DSD option. Also you have CONTRACT in the input statement twice.

data Telco2;
   title 'Principal Component Analysis';
   infile "/home/johnfranklin0/EPG194/data/Telco2.csv" dsd;
   input Tenure Contract InternetService Contract2 
      PaymentMethod  MonthlyCharges;
   run;