Difference between local and global macro variables in sas jobs

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...

...sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based solution rather than one installed on my computer but...

I need a visit visa sponsored letter from someone who is in Austria or an Austrian national. Or spain. AusThe primary goal for obtaining this letter is to explore business opportunities in the tourism and hospitality industry. The sponsorship letter would ideally help facilitate my visit to Austria and convey my intentions of exploring potential collaborations or partnerships in the tourism and hospitality sector. The letter should be signed in front of local lawyers and approved by embassy.

I am seeking a skilled data miner to initially extract at least 1,000 company names, telephone numbers, and emails of translation agencies in the United States. We will provide the names of the cities, and the data miner will be responsible for searching local translation agencies on Google that meet these requirements. The database is to be created on a Google Spreadsheet. Based on this information, please tell us how many entries you can complete per hour and your best rate per hour.

Please note that this is not for a particular role, this for representation. We work with all Casting Directors in Australia on all productions. We are seeking talented individuals to play varying roles. We receive briefs for Film, TV, and Commercials. We left the project duration field blank, this means there are opportunities for both short-term and long-term collaboration. Most jobs are between 4-8 hours or can be multiple days on larger productions. As experience is needed for some productions, inexperience actors are also welcome as there are allot of roles you don't need experience for as long as you feel comfortable in front of the camera. Please contact me if you have any questions. Regards Brad Walks Talent Management

I'm seeking an experienced film editor specializing in continuity editing for my short film running between 10-20 minutes. Here are the key touchpoints for this project: • Implement Continuity Editing: Your task is to ensure the seamless transition between different shots and scenes in the film. Your skill in maintaining the narrative coherence is paramount. • Special Effects: Your repertoire should include the application of color grading, text/title effects, and sound effects. I'm counting on your creativity and expertise to enhance the artistic direction of the film. Ideally, you should have proven experience in editing short films, enhancing the visual storytelling with your skilful treatment. Familia...

I'm in need of a skilled video editor to create a cinematic 1.30 minute video capturing "a day in my city". I have a collection of 150 video clips, ranging from 1 to 5 seconds each, and an additional inspirational clip. The video must be edited with the following specifications: - No copyright music: It's important that the video is accompanied by an original or copyright-free soundtrack. - Dynamic transitions: The transitions between the scenes should be engaging and captivating, enhancing the overall cinematic effect. - Inspirational message: The primary emotion I want this video to convey is 'Inspiration'. Therefore, the editing should reflect this tone and help to deliver the message effectively. Ideal Skills a...

Must be local to Portland, Oregon, USA I'm seeking a watercolor artist to paint a set of murals in my dining room with a focus on nature, specifically landscapes in oregon such as Multnomah falls, mt hood, Haystack rock, etc. There will be 5 murals about 35" x 55" inside of moulding. Example attached in a similar style (Susan Harter wallpaper) Key requirements include: - Expertise in watercolor painting - Experience with medium-scale mural artwork - A strong understanding and skill set in painting natural landscapes

...iOS, Android, and Web, the app's functionalities must include: - Property Search: An intuitive, user-friendly interface for users to search properties. - Filter options: Users can filter search results based on different criteria. - Saved favorites: Users can bookmark their preferred properties for future reference. The app should also facilitate user interaction with features allowing: - User registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature facilitates communication between users and property agents/owners. Ideal candidates...

Please alter the soacing between the top word. Needs to be Yew Tree NOT Yewtree. Please can the Yew tree be centralised to the tree above equal letters either side of possible.

I require an Adobe Premiere proficient video editor to handle a 2-5 minute music video in a clean and simple style. The task must be completed within 24 hours, and I need to be delivered an editable Adobe Premiere version as the final work. As I have not specified any particular visual effects or transitions, use your professional judgement to best meet the clean and simple style preference. My budget falls between 35 to 50€. Ideal freelancers will have experience in music video editing and be able to operate swiftly and efficiently. The video is for a class project and I have the files as XML

As the operator of a Melbourne-based real estate agency, I require a lead generation expert to help expand my client base. I'm specifically targeting overseas, local, and national investors looking for promising real estate projects. Tasks and responsibilities include: - Generating verified leads using LinkedIn Ads. - Strategically targeting and communicating with investors. The ideal candidate should have: - Extensive experience in lead generation, specifically via LinkedIn Ads. - A strong understanding of the real estate market and the ability to effectively target investors. - Proven track record of successful conversion of leads. Please note, compensation will be either per hour or per lead conversion, at a rate of $5000 per converted ...

...first section on any local host. Once it’s ready, show it to me. If the functionality is working correctly, I will give you the login details, and you can then transfer it there and continue the work. and I will also award you the job at that time. 3) The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. I need ONE PAGE created for web store (wordpress/woocommerce). Must have a visual product customizer. Meaning that a customer will have the option to customize the item and see the changes they make in real time. Not ...

...search in the medical device register and create a search report as detailed in the following URL. The freelancer must be experienced in conducting medical literature database searches, compiling results, and writing an academic document following the Vancouver citation style. There's no word limit for the report. URL: Key Points: - The primary objective of this research is to identify and interpret trends in the utilization of diagnostic and therapeutic medical devices in healthcare practices worldwide. Ideal Candidate: - A background in medical research/healthcare analysis would be highly beneficial for this project. - Experience in academic research, especially in the field of medical devi...

I'm looking for help from a talented programmer with C++ experience and low-level programming knowledge. The main purpose of this project is to develop a keyboard input emulator specifically for gaming purposes. Basic requirements: - Compatibility: The emulator must be designed to run on Windows operating systems. - Programming Language: It is important to develop the emulator using C++. - Purpose: Macro tests will be performed with the emulator in the game. Your role will be as follows: - Design and develop a reliable and efficient keyboard input emulator for gaming. System level programming is required. (It will simulate the keyboard on the hardware and perform keydown and keyup operations. I want it to press the z1 key when the Cap...

- Implementation of a feature that toggles audio output between Speaker and earphone in a React Webview screen inside a React Native app - The feature should be user-friendly, enabling seamless switching between the two audio outputs Ideal Skills: - Proficiency in React Native and React - Experience with audio output handling in mobile applications - Understanding of Android audio controls and React Native Webview integration If you have the necessary skills and experience, please get in touch.

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Und...

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kn...

I'm looking for a talented video editor to assist in creating Instagram reels. The primary goal of these reels is to increase brand awareness. Key Requirements: - Editing Style: The editing style required is cinematic. - Video Duration: The reels should be between 15-30 seconds. The ideal candidate should have experience in social media video editing, particularly Instagram. You must be able to bring the brand to life in a visually appealing and engaging way, while maintaining a cinematic feel. Please include relevant samples or portfolio links in your bid.

I'm seeking a seasoned salesperson who can use their prowess in social media outreach to reach out to restaurants in western countries and other businesses. You would be responsible for closing deals through sales calls. Key Responsibilities: - Engage with potential clients through social media - Utilize your sales skills to pitch our products/services - Close deals via effective sales calls The ideal candidate should have: - Proven experience in B2B sales, especially in the restaurant industry - A strong understanding of social media outreach - The ability to close deals effectively and meet targets - Excellent communication and negotiation skills This position is commission-based, so your earning potential will be directly proporti...

...the expertise of a seasoned digital marketing freelancer to enhance my agency's operations. One who's adept in an array of digital marketing services including: - Search Engine Optimization (SEO) - Social Media Marketing - Content Marketing - Website Design and Development - PPC - Meta Ads - Google Ads - Market Research The crux of this collaboration pivots on the generation of leads and conversions. Furthermore, the successful applicant will concentrate their strategies towards the working professionals demographic aged between 26-50. I strongly encourage enthusiastic digital marketing professionals with a proven track record in the above areas to apply. Your ability to design and implement result-oriented strategies that effecti...

...Happiness and Inspirational. Responsibilities: Translate the entire manuscript accurately and fluently, capturing the original meaning and style. Use clear, concise, and natural-sounding Brazilian Portuguese specific to the target audience (Brazil). Pay close attention to cultural nuances and terminology to ensure the translation resonates with Brazilian readers. Maintain consistent voice and tone throughout the translation. Translate all text elements, including chapters, headings, subheadings, and any captions or illustrations. Proofread the translated manuscript for any errors or inconsistencies. Qualifications: Native-level Brazilian Portuguese speaker and writer Extensive experience translating non-fiction books, preferably...

I'm looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. I will provide the script at well.

I have a scientific article in French that I would like translated into English for publication in an English journal. The subject matter is in the field of geography so a background in this area would be beneficial. Key Requirements: - Fluency in both French and English - Experience with scientific translation - Understanding of geographical terminology The document is between 10 to 20 pages long and contains specialized terminology that needs to be translated accurately. If you are bilingual and have experience in this area, I would love to hear from you.

I'm in need of an expert who can establish an effective indoor wayfinding system for specific rooms and departments in commercial spaces, including stores, galleries, theaters, parking lots, casinos, etc. This will encompass: - Designing a clear and intuitive pathway using physical signs, specifically directions with arrows. - Creating directions to defined variables in the commercial space. - Being able to visualize the user journey through our indoor space and mapping it out logically. Ideal skills and experience: - Proven experience in wayfinding system design, specifically for indoor spaces. - Excellent design skills with a keen eye for intuitive visual communication. - A good understanding of space utilization ...

You must be in the UK and ideally local. I'm looking to collaborate with a talented videographer who can help me create engaging TikTok-style videos for my Instagram. The ideal candidate should be able to record, edit, and add ready-to-post captions for the videos. Key Requirements: - Experience creating content in the TikTok style. - Proficiency in advanced video editing, including animations, green screen effects, and custom graphics. - Ability to produce content that is visually appealing and aligns with current social media trends. Please include samples of your previous work, particularly any TikTok or Instagram content you've created. I'm excited to see how we can work together to create some compelling a...

I need assistance to accomplish two specific tasks for my impending project that involves a deep-dive into financia...Analysis: Applying my real-world data, there's a need to execute an efficient regression analysis. The aim isn't to predict future values but to identify significant variables inherent in the dataset. 2. Model Evaluation: Post regression analysis, your expertise will be needed for a thorough model evaluation, ensuring the accuracy of the identified variables and assessing the overall performance of the model. Ideal applicants should possess robust experience in R, financial econometrics, regression analysis, and model evaluation. Familiarity with real-world finance data would be an added advantage. The goal is to unlock...

...experienced Revit designer to develop medium-scale models for various types of buildings - residential, commercial, and industrial during the construction phase. Key Responsibilities: - Create Revit models from concept design to construction documentation - Coordinate with our on-site team to ensure accuracy of the model Required Skills: - Proficiency in various types of Revit modeling - Prior experience in residential, commercial, and industrial projects - Detailed understanding of various construction phases - Ability to handle medium-scale projects independently. Your expertise will help us bridge the gap between conception and construction, providing a more realistic and manageable understanding of each project. Candidates who ...

I'm looking for an experienced PPC marketer who can help me set up Microsoft advertising ppc campaigns.

...highly skilled and expeditious Native Spanish Translator to join our dynamic remote team. The ideal candidate will possess an excellent command of both Spanish and English, with extensive experience in translation and document editing. **Responsibilities:** - Translate a variety of documents from English to Spanish and vice versa while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish wit...

I am seeking the expertise of a professional engineer to create 2 sets of stamped engineering plans for a 7-10k elevator boat lift. The desgin...engineer to create 2 sets of stamped engineering plans for a 7-10k elevator boat lift. The desgin should incorporate: - 20 degree angle lift secured to a seawall, indicating a balance of strength and flexibility. - Weight capacity between 5,000 - 10,000 lbs, to cater to a diverse range of boats. The ideal candidate should have: - Extensive experience in marine engineering - A proven track record with designing boat lifts - Familiarity with the local codes and regulations in Pasco County. For a smooth working relationship, the ability to respond promptly to queries and meet deadlines is crucial....

I'm looking for a professional who can help me integrate my FreePBX system with an AI to automate and manage my call center. The ideal candidate should be able to: - Implement AI-driven call routing - Develop an AI voice bot - Configure the AI voice bot to provide information, take orders and schedule appointments Key requirements: - Seamless integration between FreePBX and the AI system - Smooth call handling and routing - Accurate and relevant information delivery by the AI voice bot to the callers - AI system must be able to provide business hours, product descriptions and pricing information to the callers.

...owner on Instagram, Twitter, and Tiktok, I'm on the lookout for a proficient marketing professional to aid in the recruitment of advertisers. Responsibilities: - Finding and securing advertisers - focusing on local businesses, service providers, and e-commerce companies interested in the sports sector. - Formulating strategic proposals to attract potential advertisers. - Negotiating partnerships and sponsorships with advertisers. Ideal Candidate: - Experience in digital marketing, particularly in recruiting advertisers. - Strong understanding of social media platforms: Instagram, Tiktok, and Twitter. - Proven track record in securing sponsorships and collaborations. - Familiarity with sports a...

...approximately 400 meters long, approximately 8 meters wide and approximately 4 meters high. Its walls are glass and cladding, and it also has escalators. Key Requirements: - Visualize the Design: I need the freelancer to translate my design into a visually appealing and realistic 3D model. This will help me understand how the final space will look. - Client Presentation: The rendering should be of a quality that I can use it to present my design to clients. It should be professional, detailed, and showcase the key elements of the design concept. - Interior design rendering with pictures of the floors in the shape of a running track, numbered with the track number and the distance traveled on both sides of the escalators, as well as i...

...seeking assistance in configuring a child post within the Pods plugin for Wordpress. I need the child post to automatically inherit the ID of its parent post. This inherited ID serves as a key point, allowing me to display parent post data within the child post. Key Requirements: - Configuring Pods Plugin: You should be proficient in utilizing the Pods plugin for Wordpress. Your expertise in setting up parent-child relationships is crucial. - Automating ID Inheritance: Enable the child post to inherit the ID of the parent post automatically. This feature is essential to streamline our content management process. - Displaying Parent Post Data: The inherited ID should be used to display relevant parent post information within the child post. This will improve the use...

Technical Requirements Specifications for our Mobile Money Solution 1. Context and Objectives Our goal is to provide subscribers of a mobile phone company with an innovative mobile money solution. This solution will allow users to perform various financial transactions and payment operations from an iOS/Android mobile application. To carry out this project, we are looking for a competent and experienced IT developer company to ensure the development, deployment, and support of the Mobile Money solution. Preliminary and non-definitive mockups of the solution are provided in the appendix to illustrate the functional expectations. 2. Functional Scope The functional scope of the Mobile Money solution must cover at least: - Management of a virtual wal...

I'm looking for a Figma expert to design the User Interface for my mobile app. The app is expected to have between 10-20 screens. Key Responsibilities: - Design the mobile app UI using Figma. - Design the UI in a way that is visually appealing and user-friendly. Ideal Skills and Experience: - Proficient in Figma and mobile UI design. - Strong understanding of user experience and user interface design. - Previous experience designing mobile apps with 10-20 screens. - Good at communication to understand the app's functionalities. If you are interested in this project, please share some of your previous work with me.

... The stream is in Grayscale (RG12, 12bit) format and I need assistance in creating Python code to receive this stream and make it available in a CuPy array. The primary goal is to process this data in real-time for monitoring purposes. It is crucial that the data is not copied between CPU and GPU memory. Key Requirements: - Acquire data stream from /dev/video0 on Nvidia Jetson Orin and store as an array - Use Python 3.9+ for the codebase - Process the data array for real-time monitoring - Do not copy data between CPU and GPU memory, as one frame is 17MB in size Ideal freelancer for this project should have: - Extensive experience with Python, particularly in real-time data processing - Prior exp...

I'm in need of an engaging and interactive activity book to complement my upcoming children's book designed for children between the ages of 5 and 8. The activity book should contain 32-40 pages, combining a variety of activities to keep young minds entertained and stimulated. Key Requirements: - A blend of different activities: I'm looking for a mix of activities, particularly coloring pages, mazes, word scrambles, picture matching, and find objects in pictures. These activities should be both fun and educational, reinforcing the themes and characters of the book. - Specific Inclusions: The coloring pages should predominantly feature the main character of the book as well as key scenes. These illustrations sh...

...freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user interface for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in...

...seeking a skilled developer who can help me optimize my team's workflow and communication on Slack through the creation of automation bots. These bots should offer the following functionalities: - Message Scheduling: Automating message delivery at specific times. - File Sharing: Facilitating easy and organized file exchange between team members. - Task Assignment: Automating the delegation of tasks within the team. - Onboarding: Assisting with the onboarding process for new team members. I prefer the use of the Slack API to develop these bots. The ideal candidate should have a good understanding of this platform and be able to leverage its features effectively. User interaction with these bots should be seamless and intuitive. I envision the fo...

...analysis, and pricing trends. Key Tasks: - Gather and analyze data on consumer preferences regarding black beans in Mexico City. - Conduct a thorough competition analysis of the black beans market in the city. - Identify and document the pricing trends of black beans in the local market. - Complete the questionnaire we provided Target Audience: - Consumers: Understand their preferences, purchasing habits, and expectations. - Retailers: Identify key players, their pricing strategies, and market positioning. - Distributors: Explore current distribution networks, challenges, and opportunities. - wholesale market of agricultural products - Agricultural supermarket - Ideal Candidate: - Located in...

I'm seeki...high-quality backlinks from reputable websites in the finance industry. - Ensuring global reach: The backlinks must be strategically placed in a manner that enhances my website's visibility on a global scale. Ideal Candidate: - Proven experience in SEO and backlink building: You should have a track record of successful backlink campaigns that have led to improved search engine rankings. - Strong understanding of the finance industry: Knowledge of the finance sector will be advantageous in selecting the most relevant websites for backlinking. - Creative and strategic thinker: The ability to think outside the box and develop a comprehensive backlink strategy is crucial for this project. If you have the ...

Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current mo...

I need a freelancer to design and administer a survey aimed at collecting statistical data from university students. The main focus of this study will be establishing the relationship between technology integration and student engagement. Your responsibilities: - Design a survey that comprehensively captures information about students level of engagement when technology used during their academic activities. - Implement this survey and ensure a high response rate from the students. Ideal skills: - Previous experience in research design specifically targeting student demographics - Proficiency in data collection, interpretation and representation. - Familiarity with advanced technology trends in an academic setting. With the resu...

I'm look...looking for an experienced website designer to create a global sourcing e-commerce website. Key features of the project: - A platform that facilitates the sourcing of both manufactured goods and various services. - Unique, user-friendly navigation and layout. - Efficient display of products and services. - Does not require a user login or registration feature. The ideal candidate should have: - Experience in designing e-commerce websites. - Understanding of efficient site navigation. - Ability to create user friendly layouts. - Portfolio showcasing past work in this area. This project requires bringing together stunning design with seamless functionality for an optimal user experience. I'm looking forward to seeing your...

I own an event hall in India, particularly a marriage hall. Currently, it is the off-season, and I am seeking a digital marketing specialist who can devise and implement a robust strategy to attract clients throughout the year. Key Responsibilities: - Plan and implement a comprehensive digital marketing strategy leveraging social media and SEO. - Analyze market trends to identify opportunities and challenges to optimize our marketing efforts. - Collaborate with the design team to create engaging content. - Monitor and report on the performance of marketing campaigns. Target Audience: - Couples getting married. - Event planners. - Local community. Unique Selling Points: - Spacious indoor space. - Beautiful outdoor garden area. Ide...

I'm in need of a competent WordPress developer to assist me in make the site is in to two language English and Thai. You need to create multi language button. Customer able to switch back and forth between two language. I also need developer to update all new current plugin and make the site load faster. Need SEO plugin install and social networking login.

...development agency and I require a skilled communicator, ideally with conversational English skills, to get in touch with my clients. This person will be responsible for client onboarding and consultation. Key Responsibilities: - Engage in client onboarding. - Conduct consultations with clients to gather their project requirements. - Ensure smooth communication between clients and my development team. Ideal Candidate: - Should be a native or fluent English speaker. - Have a background in client management or customer service. - Be proficient in understanding and communicating technical requirements from clients. - Able to manage multiple clients at once (1-5 clients at a time). This role is crucial in ensuring tha...

I'm looking for an animator who can help me create a 1-minute animation. I'm open to a realistic or simplified style, or anything in between. The animation will be focused on demonstrating construction techniques for renewable energy sources. Key Points: - Duration: 1 Minute - Style: Realistic or simplified - Audience: General public - Focus: Highlighting construction techniques for renewable energy sources Ideal Skills & Experience: - Proven experience with animations - Ability to create engaging content for the general public - Knowledge of renewable energy sources could be a plus, but not mandatory