DATA Step, Macro, Functions and more

1 Unclosed Select Block

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 130
Accepted Solution

1 Unclosed Select Block

Libname Learn'/folders/myfolders/SASData' ; 

Data Sales(keep = Date Amount) Inventory(keep = Partnumber Quantity) ; 
	infile '/folders/myfolders/SASData/mixed_recs.txt'  pad ; 
	Input @16 Code 2. @ ;
	If Code eq 1 then do ; 
		Out = Sales ;
		input @1 Date mmddyy10. 
		      @12 Amount 4.  ; 
		format Date mmddyy10. ;   
	end ; 
		
	
	Else if Code ne 1 then do ;
		Out = Inventory ;
		input @1 PartNumber $ 6.
		      @8 Quantity 3. ; 
	end ; 
run ; 

Data Sales_Only ; 
	Set Sales ; 
	Select ; 
	When (Missing(Date)) New = 1 ; 
	When (Not Missing(Date)) New = 2 ; 
	When (Missing(Amount)) New = 3 ;
	When (Not Missing(Amount)) New = 4 ; 
	Otherwise ; 
run ; 

Not sure where this is unclosed? Tx.


Accepted Solutions
Solution
‎04-14-2018 01:21 AM
Super User
Posts: 2,078

Re: 1 Unclosed Select Block

Posted in reply to ManitobaMoose

I think you missed an END

 

Data Sales_Only ; 
	Set Sales ; 
	Select ; 
	When (Missing(Date)) New = 1 ; 
	When (Not Missing(Date)) New = 2 ; 
	When (Missing(Amount)) New = 3 ;
	When (Not Missing(Amount)) New = 4 ; 
	Otherwise ; 
end; run ;

View solution in original post


All Replies
Solution
‎04-14-2018 01:21 AM
Super User
Posts: 2,078

Re: 1 Unclosed Select Block

Posted in reply to ManitobaMoose

I think you missed an END

 

Data Sales_Only ; 
	Set Sales ; 
	Select ; 
	When (Missing(Date)) New = 1 ; 
	When (Not Missing(Date)) New = 2 ; 
	When (Missing(Amount)) New = 3 ;
	When (Not Missing(Amount)) New = 4 ; 
	Otherwise ; 
end; run ;
Super User
Posts: 10,623

Re: 1 Unclosed Select Block

Posted in reply to ManitobaMoose

Maxim 1: Read the documentation.

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=lestmtsref&docsetTarget=p0...

SAS 9.4 and Viya 3.3 Programming Documentation - Data Step Programming - Data Step Statements - Dictionary of D. S. Statements

 

The presence of the necessary end; statement is prominent in the syntax section.

 

There is a very strong reason why Maxim 1 is actually the first.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 10,623

Re: 1 Unclosed Select Block

Posted in reply to ManitobaMoose

And you should start writing code in a visually ordered style:

Data Sales_Only ; 
  Set Sales ; 
  Select ; 
    When (Missing(Date)) New = 1 ; 
    When (Not Missing(Date)) New = 2 ; 
    When (Missing(Amount)) New = 3 ;
    When (Not Missing(Amount)) New = 4 ; 
    Otherwise ; 
  end;
run ; 
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 235 views
  • 0 likes
  • 3 in conversation