topic Re: solutions to Chapter 21 Question 10 SAS programming by Example in SAS Programming

solutions to Chapter 21 Question 10 SAS programming by Example

Dennis_K — Tue, 14 Sep 2021 05:19:29 GMT

10. The raw data file Mixed_Recs.txt contains two types of records. Records with a 1 in Column 16
contain sales records with Date (in mmddyy10. form) starting in Column 1 and Amount in Columns
11–15 (in standard numeric form). Records with a 2 in Column 16 are inventory records and they
contain two values, a part number (character, 5 bytes) starting in column 1 and a quantity. These two
values are separated by a space. A listing of this file is shown below:
10/21/2005 1001
11/15/2005 2001
A13688 250 2
B11112 300 2
01/03/2005 50001
A88778 19 2
Write a DATA step to read this file and create two SAS data sets, one called Sales and the other
Inventory. The two data sets should look like this:

Re: solutions to Chapter 21 Question 10 SAS programming by Example

Dennis_K — Tue, 14 Sep 2021 05:30:26 GMT

my code is as follows:

data sales inventory;
infile '/home/wckwone/SASbyExample/mixed_recs.txt' truncover;
input @16 type 1. @;

if type=1 then do;
keep saleDate Amount;
input @1 saleDate mmddyy10. Amount 11-15;
output sales;

end;

else do;
keep partno Quantity ;

output Inventory;

end;

drop type;
run;

Re: solutions to Chapter 21 Question 10 SAS programming by Example

Kurt_Bremser — Tue, 14 Sep 2021 06:09:40 GMT

KEEP is a declarative statement that affects all output datasets and is dealt with at compile time. So it is not executed, meaning it cannot be used conditionally.

Use KEEP= dataset options in the DATA statement instead.

Re: solutions to Chapter 21 Question 10 SAS programming by Example

Dennis_K — Tue, 14 Sep 2021 06:27:43 GMT

data sales(keep=saleDate Amount) inventory(keep=partno Quantity);
infile '/home/wckwone/SASbyExample/mixed_recs.txt' truncover;
input @16 type 1. @;

if type=1 then do;
input @1 saleDate mmddyy10. Amount 11-15;
output sales;
end;

else do;
input partno $1-6 Quantity 8-11;
output Inventory;
end;
run;

Re: solutions to Chapter 21 Question 10 SAS programming by Example

Kurt_Bremser — Tue, 14 Sep 2021 06:44:03 GMT

So what is your question now?

If you receive messages in the log that puzzle you, or the result does not match your expectations, post the complete log by copy/pasting it into a window opened with this button:

Similarly, post a few lines of your input data, using the same method.

Re: solutions to Chapter 21 Question 10 SAS programming by Example

Dennis_K — Tue, 14 Sep 2021 09:02:48 GMT

@Kurt_Bremser Initially, I have problems dropping the unnecessary columns. Your Suggestion have solve the issue.

Thanks a lot.