BookmarkSubscribeRSS Feed
ManitobaMoose
Quartz | Level 8

Hi,

 

I work hard to find out what is wrong before positing here, but here I have an error I don't understand. I am getting an error stating that

"The Data step was not specified on the data statement". When I remove the Anydigit function, that error disappears. Thanks for your help.

libname Learn '/folders/myfolders/Learn' ;

Data Check1 ; 
	Set Learn.Errors ; 
	If anydigit(Subj) then output mixed_data ; 
	else output only_nums ; 
	 
proc print data=mixed_data ; 
run ;
3 REPLIES 3
WarrenKuhfeld
Rhodochrosite | Level 12

The name(s) in the DATA statement need to match the name(s) in the OUTPUT statement.

Reeza
Super User

@ManitobaMoose wrote:

Hi,

 

I work hard to find out what is wrong before positing here, but here I have an error I don't understand. I am getting an error stating that

"The Data step was not specified on the data statement". When I remove the Anydigit function, that error disappears. Thanks for your help.

libname Learn '/folders/myfolders/Learn' ;

Data Check1 ; 
	Set Learn.Errors ; 
	If anydigit(Subj) then output mixed_data ; 
	else output only_nums ; 
	 
proc print data=mixed_data ; 
run ;

POST YOUR LOG along with your code in future questions. 

Why? Because it's too easy to make a mistake otherwise, for example your typed error message above is wrong. It should say Data SET, not Data STEP. 

 

ERROR 455-185: Data set was not specified on the DATA statement.

 

As indicated, the option after the OUTPUT statement is the data set name.

 

From the docs:

https://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n1lltvbis7ye1a...

 

OUTPUT <data-set-name(s)>;

Patrick
Opal | Level 21

@ManitobaMoose

You must define the tables in the DATA statement which you explicitly address in the OUTPUT statements.

libname Learn '/folders/myfolders/Learn' ;

Data mixed_data only_nums; 
	Set Learn.Errors ; 
	If anydigit(Subj) then output mixed_data ; 
	else output only_nums ; 
	 
proc print data=mixed_data ; 
run ;

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 810 views
  • 0 likes
  • 4 in conversation