LINE and COLUMN could not be determined

amychau — Mon, 05 Dec 2016 07:52:21 GMT

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

Re: LINE and COLUMN could not be determined

Kurt_Bremser — Mon, 05 Dec 2016 08:21:11 GMT

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

Re: LINE and COLUMN could not be determined

amychau — Mon, 05 Dec 2016 09:12:05 GMT

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

topic LINE and COLUMN could not be determined in SAS Studio

LINE and COLUMN could not be determined

Re: LINE and COLUMN could not be determined

Re: LINE and COLUMN could not be determined