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
Ammonite | Level 13

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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1055 views
  • 0 likes
  • 4 in conversation