Question

1. You are given a text file where dollar signs were used as delimiters. To indicate missing values, two dollars signs were entered. Values in this file represent last name, employee number, and annual salary.

Here is a listing of this file:

File company.txt

Roberts$M234$45000

Chien$M74777$$

Walters$$75000

Rogers$F7272$78131                                                  

Using this data file as input, create a temporary SAS data set called Company with the variables LastName (character), EmpNo (character), and Salary (numeric).

Answer 1

data company; 

infile 'c:\books\learning\company.txt' dsd dlm= ' $ ' ; 
input LastName $ EmpNo $ Salary; 

format Salary dollarlO.; /* optional statement */ 
run; 

title "Listing of COMPANY"; 
proc print data=company noobs ; 
run;