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.
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 ;
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 ;
Maxim 1: Read the documentation.
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.
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 ;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: