BookmarkSubscribeRSS Feed
capam
Pyrite | Level 9

Hello,

 

I have the following code that generates an error. I am checking the matrix 'have' for the variable 'cusum'. If 'cusum' exists it is removed. The error I get is: 

 

ERROR 117-185: There was 1 unclosed DO block.

 

	data _null_;
		dsid=open('have');
		check=varnum(dsid,'cusum');

		if check=1 then
			do;
	data have(drop=cusum);
	set have;
	run;
			end;
		run;
3 REPLIES 3
PaigeMiller
Diamond | Level 26

You can't have a data step inside a data step. That is the cause of the ERROR message you are seeing.

 

A better way to check to see if a variable exists and then delete it would be:

 

Use PROC SQL to query the DICTIONARY.COLUMNS table to see if the variable exists; and if it exists, then use PROC DATASETS to remove the variable from the data set. This would have to be done in a macro.

 

I'm curious as to why you need to conditionally delete a variable if it exists, as normally leaving an unwanted variable in a data set causes no problems other than taking up slightly more disk space.

--
Paige Miller
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Something like the below - although I totally agree with @PaigeMiller, there is rarely a need to delete a variable if you don't know about it up front, sounds like a lack of knowledge about your data.

data _null_;
  set sashelp.vcolumn (where=(libname="WORK" and memname="HAVE" and name="CUSUM"));
  call execute('data work.have; set work.have (drop=cusum); run;');
run;
Quentin
PROC Star

You don't actually need to check for the existence of the variable. 

 

The system option DKRICOND determines whether or not and error is generated when you drop/keep/rename a variable that doesn't exist.  It's default is DKRICOND=ERROR, but you can set it to NOWARN.

 

data have1;
  x=1;
run;
data have2;
  x=2;
  cusum=1;
run;

options dkricond=error;
data want;
  set have1(drop=cusum)  /*causes error cuz cusum does not exist*/
      have2(drop=cusum)
  ;
  put _all_;
run;


options dkricond=nowarn;
data want;
  set have1(drop=cusum)  /*no error cuz DKRICOND=NOWARN*/
      have2(drop=cusum)
  ;
  put _all_;
run;
options dkricond=error;  *restore the default;
Check out the Boston Area SAS Users Group (BASUG) video archives: https://www.basug.org/videos.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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