topic Re: I need help with loading Data in SAS Studio

I need help with loading Data

genius99 — Tue, 10 Sep 2019 15:40:37 GMT

I am trying to load data with the data files attached,

this is my code

data Orders;
    infile "C:/Users/100355202/Desktop/Orders.txt" dsd dlm = " ";
    input OrderID CustomerID :$20. EmployeeID :$20. OrderDate :mmddyy10. 
          RequiredDate :mmddyy10. ShippedDate :mmddyy10. ShipVia Freight 
          ShipName :$20. ShipAddress :$20. ShipCity :$20. ShipRegion :$20. 
          ShipPostalCode :$20. ShipCountry :$20. ;
run;

this is what I should get as the output

but I am getting this as the output

Can you help me figure out what I am missing for it t work?

I am receiving these notes

Re: I need help with loading Data

Jagadishkatam — Tue, 10 Sep 2019 15:44:47 GMT

could you try the tab delimitation '09'x

data Orders;
    infile "C:/Users/100355202/Desktop/Orders.txt" dsd dlm = "09"x;
    input OrderID CustomerID :$20. EmployeeID :$20. OrderDate :mmddyy10. 
          RequiredDate :mmddyy10. ShippedDate :mmddyy10. ShipVia Freight 
          ShipName :$20. ShipAddress :$20. ShipCity :$20. ShipRegion :$20. 
          ShipPostalCode :$20. ShipCountry :$20. ;
run;

Re: I need help with loading Data

genius99 — Tue, 10 Sep 2019 15:50:11 GMT

That worked out, thank you.

Re: I need help with loading Data

Jagadishkatam — Tue, 10 Sep 2019 16:10:59 GMT

Thank you @genis99, Could you mark this solution as accepted so that it will help future users.