Import a Text files with a DATA STEP in SAS
data work.shoes;
infile "/folders/myfolders/import/shoes.txt"
delimiter = "09"x
missover
dsd
firstobs=2;
informat Region $50.;
informat Product $50.;
informat Subsidiary $50.;
informat Stores best12.;
informat Sales dollar12.;
informat Inventory dollar12.;
informat Returns dollar12.;
format Region $50.;
format Product $50.;
format Subsidiary $50.;
format Stores best12.;
format Sales dollar12.;
format Inventory dollar12.;
format Returns dollar12.;
input
Region $
Product $
Subsidiary $
Stores
Sales
Inventory
Returns;
run;
proc print data=work.shoes (obs=6) noobs;
run;