I have been given this task below can someone help me understand what I have to do?   You are considering taking out a loan that requires monthly payments. The loan is $10000 and has simple interest of 0.25% per month.  Your payment is $100 per month.  Create data steps that will calculate the following: Your loan balance after 10 payments. The number of payments you’ll need to make until the loan is paid off. The number of payments you’ll need to make if you increase the payment to $125 every other month (starting with 2nd month). For each, show for each month, the starting loan balance for the payment, the interest charge (calculated before the payment), the payment amount, and the ending balance.   I have loaded all the data sets /* Load Orders Data */ data work.orders; infile "C:/Users/100355202/Desktop/Orders(3).txt" dsd dlm="09"x firstobs=2; input OrderID CustomerID $ EmployeeID OrderDate :mmddyy10. RequiredDate :mmddyy10. ShippedDate :mmddyy10. ShipVia Freight ShipName :$100. ShipAddress :$100. ShipCity :$100. ShipRegion :$100. ShipPostalCode :$100. ShipCountry :$100.; format OrderDate mmddyy10. RequiredDate mmddyy10. ShippedDate mmddyy10.; run; /*Load Order Details data */ data work.orderdetails; infile "C:/Users/100355202/Desktop/OrderDetails(1).txt" dsd dlm="09"x firstobs=2; input OrderID ProductID UnitPrice Quantity Discount; run;   ... View more

I have two data sets, and I want to assign a continent to each country. how do I do that? I have attached the data   ... View more

how can I merge the datasets keeping both Rate_1M_CD fields as different fields by renaming the my_citimon version as MON_RATE data work.my_citiday; set sashelp.citiday; if '01-JAN-88'd <= date <= '31-OCT-88'd and day(date)='01'; DowComposite=snydjcm; Rate_1M_CD = dcd1m; keep date DowComposite Rate_1M_CD; run; data work.my_citimon; set sashelp.citimon; if '01-MAR-88'd <= date <= '31-DEC-88'd; format date DATE9.; Rate_1M_CD = FSPCAP/100; Common_Stock_Price_Index = FSPCON; keep date Rate_1M_CD Common_Stock_Price_Index; run; ... View more

I am trying to merge datasets, and this is my code. /*Load Data*/ data Employees; infile "C:/Users/100355202/Desktop/employees.csv" dsd dlm = "09"x; input EmployeeID LastName :$20. FirstName :$20. Title :$20. Gender :$20. BirthDate :mmddyy10. HireDate :mmddyy10. Address :$20. City :$20. Region :$20. PostalCode :$20. Country :$20. HomePhone :$20. Extension :$20. ReportsTo; run; proc import datafile="C:/Users/100355202/Desktop/employees.csv" out=employees dbms=csv replace; getnames=yes; run; /* Merge dataset */ data Employees_Orders; merge Employees Orders; by EmployeeID; run; the orders code is like this /*Load Data*/ data Orders; infile "C:/Users/100355202/Desktop/Orders.txt" dsd dlm = "09"x firstobs = 2; 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; and I am getting these notes can anyone help me solve this ... View more

Hello, I am trying to import data files to SAS but it's telling me that the file is invalid. What should I do ... View more