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
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;
That worked out, thank you.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.