Write and run SAS programs in your web browser

LINE and COLUMN could not be determined

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

LINE and COLUMN could not be determined

Hello!

 

I'm having an issue with my code. My code is below: 

 

DATA EnrollUCB (DROP = _Type_ _FREQ_);
	MERGE Enroll06 Enroll07 Enroll08 Enroll09 Enroll10 Enroll11 Enroll12 Enroll13 Enroll14 Enroll15;
	By District Year;

However, when I try to merge all of my Enroll datasets, I receive the following error: 

 

 396        PROC Sort EnrollUCB;
 
 22: LINE and COLUMN cannot be determined.
 NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
 ERROR 22-322: Syntax error, expecting one of the following: ;, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, DUPOUT, 
               EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, 
               NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, NOUNIKEY, NOUNIKEYS, 
               NOUNIQUEKEY, NOUNIQUEKEYS, NOUNIQUEREC, NOUNIQUERECS, NOUNIREC, NOUNIRECS, OSA, OUT, OVERWRITE, PAGESIZE, PRESORTED, 
               PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, UNIOUT, 
               UNIQUEOUT, WKNO, WORKNO.  
 202: LINE and COLUMN cannot be determined.
 NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
 ERROR 202-322: The option or parameter is not recognized and will be ignored.
 397        By District Year University UCD UCLA UCB UCR UCI UCSD UCSB UCSC;
 398        
 399        /*Enroll UCD*/
 400        
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE SORT used (Total process time):
       real time           0.12 seconds
       cpu time            0.00 seconds

Accepted Solutions
Solution
‎12-05-2016 04:12 AM
Esteemed Advisor
Posts: 6,668

Re: LINE and COLUMN could not be determined

Your proc sort statement misses the data= option. Just naming the dataset without data= won't work. Read the documentation.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎12-05-2016 04:12 AM
Esteemed Advisor
Posts: 6,668

Re: LINE and COLUMN could not be determined

Your proc sort statement misses the data= option. Just naming the dataset without data= won't work. Read the documentation.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: LINE and COLUMN could not be determined

Thank you, Kurt! I didn't catch that mistake before. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 264 views
  • 2 likes
  • 2 in conversation