Build an automated SQL & Macro process in SAS

Greetings!. I checked your Database Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Queries, Reports and Forms. We are Professionals, So we complete your within a time with perfect work with 100% accuracy. So don’t worry about anything.

Hi, I am an expert SAS programmer with 5 years experience with SAS. I am good with data management. Please reach out for help. Best, Aida

Hi Sir, Greetings of the day!! I am a Data Analytics Professional with 5+ years of experience in banking and finance. Have hands on expertise in BASE & ADVANCE SAS, SQL, EXCEL and SHAREPOINT. If my skills are suitable for your job I'll be happy to work with you. Thanks, Puneet Kumar

I am a financial analyst and I am really good at Excel and PPT since I have been in a multinational corporation working for over 3 years and using excel for more than 8 years. And I have improved many excel modeling by using marco and VBA.

Hi! Hope you are well! I have 10+ years experience working with SAS, SQL and SAS Macros for banks in Australia. I've had a quick look through your datasets and reporting process and may be able to help you with this task. I do have some questions though so please contact me if you would like to chat further. Regards, Duong

7+ year of experience in Data Analytics mainly in Finance domain. I have extensively used SAS, SQL and Python through out my career. Will be happy to provide the Solution. Please feel free to reach, if you are Interested.

I have 5 years of experience with SAS working with the first télécommunications company in Tunisia, I can deal with different type of data and make an automated script that aggregate your data to extract valuable information. I can transform your data into insights that helps you take the best decision to improve your business.

Quoted figures are tentative and can vary as per actual requirement and scope /timeline for quality delivery

Hi, my name is Alan from Italy. I'm a SAS certyified professional since 2002. This is what I'm going to do according to the process you described in your DOC: Process: • Join SEAL application data with MARS actuals based on “Application ID.” Line items that have no valid application ID should be included and return “Invalid App” for empty SEAL fields. --> SAS BASE code to read input file, sort and merge them • Join Product Mappings fields “Parent Category,” “Category,” “On/Off Prem” fields with MARS Actuals based on “Product” field. --> SAS BASE code to read input file and join with PROC SQL • This new aggregated table should be titled “Scalability Actuals.” • SQL queries: o Summarize the “Scalability Actuals” Data by “Org L1” field for monthly totals o Group data by “Category” & “Parent Category” fields o Filter grouped data by the “Parent Category” field for only “Modern” Value o Construct sub-queries and in-line views within an SQL procedure step to:  Subset “Modern” data (Parent Category field) by using non-correlated subqueries (HAVING clause)  Subset “Modern” data (Parent Category field) by using correlated subqueries  Reference an in-line view with other views or tables (multiple tables) --> many PROC SQL coding to create summarized tables/views • Create additional summary insights to answer the questions below --> SAS MACRO coding according to your specification