Hello Jag, Thank you for the quick response! The count I am getting is not a sum of distinct ID. I want to show how many individuals were seen at the department X during month XX-YYYY.  Thank you!  ... View more

Reeza,   The proc means was helpful for summarizing the data. The amounts datasets reflects the allocation amounts for each contractor. I may just have to analyze all this in Excel. Thank you!  ... View more

Allow me to clarify something. Cost actually reflects expenditure. It's just named cost in the dataset. I will change it to "paid". It's possible that this is an unreasonable task given these contractors spend wildly different amounts each month. Typically more mid-year and beginning and end of the FY.    I multiplied FY17 paid amounts by 4/3  for each months. What is the rationale for 4/3 instead of maybe 10%?     I feel I am at a loss! 😞 ... View more

Hello, Essentially, I need to project whether each contractor will spend all of their allocated funds (amount table). So, contractor #1 has spend $X ytd, how likely are they to spend the rest of their contracted amount before the end of the FY?   The input data set contains several variables including contractor, paid date, service, cost, cost type, ID, and fiscal year. There are other variables but I'm not sure if they are needed for this exercise. I have two fiscal years worth of data: 2018 (Sep-Aug) and 2019 (Sep-Jan). I believe for forecasting, the previous year's data is used to predict future costs. I think the biggest issue right now is ensuring my dataset if formatted correctly to execute any of the procedures.    I definitely do not have a financial/accounting background so it's making this all that more difficult for me! I appreciate your help 🙂  ... View more

Hello, This is my input data: data input; infile datalines delimiter=','; input Primary_Disability Secondary_Disability Contractor_Name Paid_Date Unit_Type Cost Service_CD Service_Description Contract_ID Cost_Type; datalines; Hearing Physical Contractor1 9/4/2018 Item $1,300.00 31 Hearing Aid Purchase 3 Complex/High Dollar Hearing Physical Contractor1 9/4/2018 Service $199.99 32 Hearing Aid Service Charge, Earmolds, and Batteries 3 Complex/High Dollar Physical Cognitive Contractor1 9/4/2018 Service $300.00 68 Modification Inspection or Review by Engineer 3 Complex/High Dollar Hearing Contractor2 9/4/2018 Item $426.00 31 Hearing Aid Purchase 15 Complex/High Dollar Physical Vision Contractor3 9/5/2018 Item $105.02 9 Assistive technology, not otherwise listed 2 Typical Vision Contractor3 9/5/2018 Item $105.02 9 Assistive technology, not otherwise listed 2 Typical Other Physical Contractor 4 9/7/2018 Item $5,600.00 62 Major Modification (e.g. permanent) 7 Typical Physical Contractor5 9/28/2017 Service $510.00 26 Medical diagnostic & evaluation services 11 Typical Physical Contractor6 9/28/2017 Service $150.00 65 Pre-modification evaluation or title search 11 Typical Vision Contractor7 9/28/2017 Hour $159.12 40 Orientation & Mobility Training 11 Typical Physical Contractor8 9/28/2017 Service $200.00 65 Pre-modification evaluation or title search 11 Typical ; data amounts; infile datalines delimiter=','; input Contractor Amount ; datalines; Contractor1 $60,000.00 Contractor2 $150,000.00 Contractor3 $1,250,656.00 Contractor4 $350,000.00 Contractor5 $260,000.00 Contractor6 $420,000.00 Contractor7 $750,000.00 Contractor8 $68,000.00 ; This output below is what would be helpful. I'm not sure I need a graph.  ... View more

Hello Tom, Thank you for your response. I have the amount each contractor has been allocated. How do I put it in the dataset in an effective manner? Each service is paid whenever it's approved so i'm not sure how I could determine frequency. The paid_date variable is when the service was paid. I think i'm struggling the most with how to format my dataset.  ... View more