topic Error in generating data step in SAS Studio

Error in generating data step

ChristosK — Sun, 22 Jul 2018 20:52:35 GMT

Experiencing a strange problem:

Its with the 3rd line from the bottom:

LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54

Prior to entering the count values , I have 24 entries in my dataset.

I have changed the spacing, variable name, treated it as a categorical value, and tried entering this one line as the only value in the dataset (which actually works).

I asked a colleague to try it and he had no problems with this code.

Have also restarted SAS Studio, and rebooted the virtual machine .

Any solutions?

data Concordance_MAP;
input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
datalines;
LA  BI_A_MAP BI_LA_MAP  0.5813 0.4376 0.6960 89
LL  BI_A_MAP BI_LL_MAP  0.3992 0.1926 0.5719 58
Nex BI_A_MAP BI_Nex_MAP 0.6511 0.5149 0.7553 89
UA  BI_A_MAP BI_UA_MAP  0.5274 0.356  0.6644 77

LA  i3min_A_MAP i3min_LA_MAP  0.5942 0.4548 0.7051 89
LL  i3min_A_MAP i3min_LL_MAP  0.2979 0.0579 0.5054 54
Nex i3min_A_MAP i3min_Nex_MAP 0.8376 0.764  0.8897 90
UA  i3min_A_MAP i3min_UA_MAP  0.2369 0.049  0.4086 75

LA  i15min_A_MAP i15min_LA_MAP  0.6234 0.4911 0.7275 90
LL  i15min_A_MAP i15min_LL_MAP  0.5584 0.3475 0.7155 54
Nex i15min_A_MAP i15min_Nex_MAP 0.6498 0.5169 0.7521 90
UA  i15min_A_MAP i15min_UA_MAP  0.5681 0.4265 0.6825 74
   
LA  i30min_A_MAP i30min_LA_MAP  0.6298 0.4908 0.7376 90
LL  i30min_A_MAP i30min_LL_MAP  0.5181 0.3028 0.6831 54
Nex i30min_A_MAP i30min_Nex_MAP 0.6895 0.5624 0.7848 90
UA  i30min_A_MAP i30min_UA_MAP  0.6076 0.4677 0.7178 74

LA  i45min_A_MAP i45min_LA_MAP  0.6877 0.5604 0.7832 89
LL  i45min_A_MAP i45min_LL_MAP  0.4402 0.2084 0.6252 52
Nex i45min_A_MAP i45min_Nex_MAP 0.7509 0.6422 0.8300 89
UA  i45min_A_MAP i45min_UA_MAP  0.5898 0.4348 0.7108 73

LA  p3min_A_MAP	p3min_LA_MAP  0.5436 0.3843 0.6714 90
LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54
Nex p3min_A_MAP p3min_Nex_MAP 0.6559 0.5297 0.7538 90
UA  p3min_A_MAP p3min_UA_MAP  0.424  0.2609 0.5636 72

;
run;

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data Concordance_MAP;
 74         input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
 75         datalines;
 
 NOTE: Invalid data for Count in line 102 1-2.
 RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                     
 102        LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54
 Measure=LA DV=p3min_A_MAPp3m IV=0.5436 CC=0.3843 LCL=0.6714 UCL=90 Count=. _ERROR_=1 _N_=21
 NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
 NOTE: The data set USER.CONCORDANCE_MAP has 23 observations and 7 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.02 seconds
       cpu time            0.02 seconds

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 21:18:54 GMT

data Concordance_MAP;
input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
datalines;
LA  BI_A_MAP BI_LA_MAP  0.5813 0.4376 0.6960 89
LL  BI_A_MAP BI_LL_MAP  0.3992 0.1926 0.5719 58
Nex BI_A_MAP BI_Nex_MAP 0.6511 0.5149 0.7553 89
UA  BI_A_MAP BI_UA_MAP  0.5274 0.356  0.6644 77
LA  i3min_A_MAP i3min_LA_MAP  0.5942 0.4548 0.7051 89
LL  i3min_A_MAP i3min_LL_MAP  0.2979 0.0579 0.5054 54
Nex i3min_A_MAP i3min_Nex_MAP 0.8376 0.764  0.8897 90
UA  i3min_A_MAP i3min_UA_MAP  0.2369 0.049  0.4086 75
LA  i15min_A_MAP i15min_LA_MAP  0.6234 0.4911 0.7275 90
LL  i15min_A_MAP i15min_LL_MAP  0.5584 0.3475 0.7155 54
Nex i15min_A_MAP i15min_Nex_MAP 0.6498 0.5169 0.7521 90
UA  i15min_A_MAP i15min_UA_MAP  0.5681 0.4265 0.6825 74
LA  i30min_A_MAP i30min_LA_MAP  0.6298 0.4908 0.7376 90
LL  i30min_A_MAP i30min_LL_MAP  0.5181 0.3028 0.6831 54
Nex i30min_A_MAP i30min_Nex_MAP 0.6895 0.5624 0.7848 90
UA  i30min_A_MAP i30min_UA_MAP  0.6076 0.4677 0.7178 74
LA  i45min_A_MAP i45min_LA_MAP  0.6877 0.5604 0.7832 89
LL  i45min_A_MAP i45min_LL_MAP  0.4402 0.2084 0.6252 52
Nex i45min_A_MAP i45min_Nex_MAP 0.7509 0.6422 0.8300 89
UA  i45min_A_MAP i45min_UA_MAP  0.5898 0.4348 0.7108 73
LA  p3min_A_MAP	p3min_LA_MAP  0.5436 0.3843 0.6714 90
LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54
Nex p3min_A_MAP p3min_Nex_MAP 0.6559 0.5297 0.7538 90
UA  p3min_A_MAP p3min_UA_MAP  0.424  0.2609 0.5636 72
;
run;

7945 data Concordance_MAP;
7946 input Measure $ DV: $15. IV: $15. CC LCL UCL Count;
7947 datalines;

NOTE: The data set WORK.CONCORDANCE_MAP has 24 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.85 seconds
cpu time 0.03 seconds

Re: Error in generating data step

ChristosK — Sun, 22 Jul 2018 21:23:04 GMT

This is interesting. Might be a bug in my SAS software?

I cut and pasted your version and still get the same error message.

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data Concordance_MAP;
 74         input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
 75         datalines;
 
 NOTE: Invalid data for Count in line 97 1-2.
 RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                     
 97         LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54
 Measure=LA DV=p3min_A_MAPp3m IV=0.5436 CC=0.3843 LCL=0.6714 UCL=90 Count=. _ERROR_=1 _N_=21
 NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
 NOTE: The data set USER.CONCORDANCE_MAP has 23 observations and 7 variables.
 NOTE: DATA statement used (Total process time):

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 21:25:50 GMT

paste on to notepad and then copy paste to your sas software plz

make sure there are no spaces between datalines

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 21:28:07 GMT

maybe adding truncover will help?

data Concordance_MAP;
infile datalines truncover;
input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
datalines;
LA  BI_A_MAP BI_LA_MAP  0.5813 0.4376 0.6960 89
LL  BI_A_MAP BI_LL_MAP  0.3992 0.1926 0.5719 58
Nex BI_A_MAP BI_Nex_MAP 0.6511 0.5149 0.7553 89
UA  BI_A_MAP BI_UA_MAP  0.5274 0.356  0.6644 77
LA  i3min_A_MAP i3min_LA_MAP  0.5942 0.4548 0.7051 89
LL  i3min_A_MAP i3min_LL_MAP  0.2979 0.0579 0.5054 54
Nex i3min_A_MAP i3min_Nex_MAP 0.8376 0.764  0.8897 90
UA  i3min_A_MAP i3min_UA_MAP  0.2369 0.049  0.4086 75
LA  i15min_A_MAP i15min_LA_MAP  0.6234 0.4911 0.7275 90
LL  i15min_A_MAP i15min_LL_MAP  0.5584 0.3475 0.7155 54
Nex i15min_A_MAP i15min_Nex_MAP 0.6498 0.5169 0.7521 90
UA  i15min_A_MAP i15min_UA_MAP  0.5681 0.4265 0.6825 74
LA  i30min_A_MAP i30min_LA_MAP  0.6298 0.4908 0.7376 90
LL  i30min_A_MAP i30min_LL_MAP  0.5181 0.3028 0.6831 54
Nex i30min_A_MAP i30min_Nex_MAP 0.6895 0.5624 0.7848 90
UA  i30min_A_MAP i30min_UA_MAP  0.6076 0.4677 0.7178 74
LA  i45min_A_MAP i45min_LA_MAP  0.6877 0.5604 0.7832 89
LL  i45min_A_MAP i45min_LL_MAP  0.4402 0.2084 0.6252 52
Nex i45min_A_MAP i45min_Nex_MAP 0.7509 0.6422 0.8300 89
UA  i45min_A_MAP i45min_UA_MAP  0.5898 0.4348 0.7108 73
LA  p3min_A_MAP	p3min_LA_MAP  0.5436 0.3843 0.6714 90
LL  p3min_A_MAP p3min_LL_MAP  0.4575 0.2335 0.6353 54
Nex p3min_A_MAP p3min_Nex_MAP 0.6559 0.5297 0.7538 90
UA  p3min_A_MAP p3min_UA_MAP  0.424  0.2609 0.5636 72
;
run;

Re: Error in generating data step

ChristosK — Sun, 22 Jul 2018 21:38:32 GMT

Tried onto notepad, and a word document.

Found one tab which I deleted but it didnt make a difference.

Whats "adding truncover"?

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 21:41:33 GMT

to make sas not to jump to the next line if it can't find all values for one line

Re: Error in generating data step

ChristosK — Sun, 22 Jul 2018 21:55:04 GMT

How do you do that?

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 22:00:16 GMT

data Concordance_MAP;
infile datalines truncover;
input Measure $ DV:  $15.  IV:  $15. CC LCL UCL Count;
datalines;

did you notice this:

infile datalines truncover;

Re: Error in generating data step

ChristosK — Sun, 22 Jul 2018 22:15:06 GMT

I thought it had initially worked because the error message disappeared.

We now have 24 entries.

However proc freq shows that there are only 23 entries that have count data, and missing.

Hmmmm

Re: Error in generating data step

novinosrin — Sun, 22 Jul 2018 22:27:32 GMT

and this is what i'm getting:

The FREQ Procedure

Cumulative Cumulative
Count Frequency Percent Frequency Percent
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
52 1 4.17 1 4.17
54 4 16.67 5 20.83
58 1 4.17 6 25.00
72 1 4.17 7 29.17
73 1 4.17 8 33.33
74 2 8.33 10 41.67
75 1 4.17 11 45.83
77 1 4.17 12 50.00
89 5 20.83 17 70.83
90 7 29.17 24 100.00

So i think the issue lies with somewhere in copy/pasting the values.

Re: Error in generating data step

ChristosK — Sun, 22 Jul 2018 22:36:17 GMT

For some reason it didn't recognize the space in the 4th line from the bottom between the DV and IV.

That fixed it.

Thank you very much!

Christos