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 ;
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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