Sas macro depository jobs

I am looking for a Freelancer to help me with a logic correction in my VBA Excel macro. The output results of the macro are incorrect and I have an idea of what I expect the output to look like. All related elements of the macro are functioning correctly, however I need help troubleshooting the logic to ensure that the output results are correct. I am open to hearing creative solutions to rectify the issue in the most efficient and timely manner possible.

This is simple task. You need to attach file and hit button to import. Create form with attach file option. Hit a button File is imported into data table Notification import is done. Need to time data stamp data. Don't allow duplicate entry if dispatch date is already imported. Example file and how it looks in access are attached.

I am looking for a SAS programmer to debug, refine, and finish a program for a life-history study, with about 750 cases and 37000 variables. The data I need to use is an existing dataset, and I need to adhere to a specific timeline. As this project needs to be completed in a timely manner, it is essential that the programming language used is SAS. I am seeking someone who is highly skilled in this language, and reliable when it comes to completing tasks within a designated time frame. Two SAS programmers have failed to do this, possibly not easy.

The dedupe has to be done the following way: If a data record is in the list more than once that has BOTH the NAME of the businesses AND the POSTAL STREET ADDRESS COLUMN C of the business any additional data records are eliminated. It is important not to only use the NAME of the business because there are often many Food Chains that have several locations within the directory but they a...NAME OF TEH BUSINESS but they have different street address locations that is NOT a duplicate. In the USA we have a Dunkin Coffee every few miles! So we will have several Dunkin locations and that is fine. Only when we have the same Business name and same postal street address COLUMN C is more than once is it a DUPLICATE. I just need a python script that will remove the duplicates or run a ...

As an experienced professional, I am looking for an expert to assist me in preparing an Information Memorandum and Financial Model. It is for a company in the electricals sector in India. This will go to investors. Job will require: - Maintaining confidentiality of the project - Preparing the macro economic thesis for investing in the electricals sector (this is like a report, 5-6 slides) - Peer analysis (this is like a report, 3-4 slides) - Preparing a financial model with 5 years projection for the company (including P&L, Balance Sheet, Cash Flow statement + 3 historical years) PS: An Information Memorandum is a lot more detailed that a Pitch Deck, therefore people with experience of preparing an IM should only apply.

I have attached a similar project that I am wanting. The example I have is outdated and from another school. I want to create something similar for my school's context and attempted to do this on my own. I would like to hyperlink our school's documents into the project as well as to the NCCD website and their documents. I like the video elements as well. I want it to look professional and want it to be user-friendly for all staff. The links are also really clunky and not completely able to read the content either. I want our data capture to be accessible form every year level as well (Prep-Year 6). I am not sure how this might work or whether this is realistically possible (one can only hope!). I am able to supply all the documents and information I am requiring but it would be s...

I'm looking for someone to remove unwanted artifacts from my photos, on an urgent basis. The photos I'll need edited include landscapes, portraits, and macro shots, and the objects I want removed will be unwanted artifacts. I need this project completed as soon as possible and won't accept an extended turnaround time. If you can commit to a quick turnaround and ensure the quality of edits, please submit your proposal.

...don't want them to be able to see. I have a very simple macro that when executed asks for a password to hide certain sheets of my excel (3 sheets) while leaving the other ones open and protected, except 3 sheets that I want my colleagues to work on. This works fine. BUT I WANT TO ADD to this same code a macro to hide and protect all the rows that in column "F" contains "Repartos" and "Facturas" only in my sheet named "transacciones". The sheet "transacciones" is a very long database (currently working on row 33293 and counting, so I want this to be smooth when I run the macro. There is a second macro that "unprotect" everything back to normal (this works fine as well, but I don't know if y...

We’re looking develop formulas and a macro to reformat a document for our regular data import process. We receive a report from a partner organization on a daily basis and regularly need to reformat and upload the ticket data into our system. These are the basic requirements to make the sheet ready for our import: • Partitioning the Name field provided into First, Last, First 2, Last 2 columns • Partitioning the Csz column into separate city, state and postal code columns • Removing foreign country zip codes • Adjusting zip codes that start with 0 (the file does not include the 0 if it’s the leading number) • Removing extraneous columns • Removing rows with missing seats/seat locations • Partitioning the Seat Location column int...

...Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / HD Removed: Yes / Services Performed/Requested: Hard Drive Wipe X 1 / HD Manufacturer: Seagate / HD Model: ST300MM0008 / HD Serial#: S420MJ2L / HD Capacity: 300GB / HD Interface: SAS / HD Form Factor: 2.5 / HD Source Serial #: 49GL482 / Storage Type: 10000 RPM HDD / HD Removed: Yes / Services Performed/Requested: Hard Drive Wipe X 1 / HD Manufacturer: Seagate / HD Model: ST300MM0008 / HD Serial#: S420MHVE / HD Capacity: 300GB / HD Interface: SAS / HD Form Factor: 2.5 / HD Source Serial #: 49GL482 / Storage Type: 10000 RPM HDD / Model: Standard SATA AHCI Controller / Model: PERC H730 Mini / Model: Standard SATA AHCI Controller / Graphic Card Interface: Integrated Graphics / GPU: Matrox ...

We require a Chrome Based Excel Macro for a repetitive task , it should import / pick data from Excel and use it on Macro - Open a webpage , link provided in Excel - Fill the credentials using the data from Excel - Follow the page flow and place order with some basic checks on every page - On successful order capture the order details in excel Its a one time task , if a suitable freelancer is found we can award more projects INDIAN FREELANCERS PREFFERED

We are looking for an experienced Excel VBA developper to create a Cutting stock optimisation Macro in excel. The goal of the project is to develop an efficient algorithm that sorts and maximizes the uses of our stock based on parts required. The objective is to take in data on Line 10. Sort the parts in order to maximize the bars (220) Output data on line 17 to 47. There are special parts that need to be marked as special after the output. The algorithm should handle up to 30 full bars or up to 150 parts. I want the code to run on one click of a button. The idea is similar to this: Thank you

I need someone to modify my macro to also have 2 more cases for shift start and shift end times separately. right now it includes the full shift time IE: 3:00 PM to 4:59 PM. I need just the start time in column O and end time in column P. The file is on a VM for the database connection so if you want you can also work on team viewer or I can send you the code and then you can send it back to me.

I am in need of a VBA developer with webscraping skills to create a VBA macro for a project. The VBA developer should have intermediate level expertise and be proficient in MS Excel VBA. The project involves building an automated VBA macro that can scrape data from the web, extract it and store it in a suitable format. The macro should be able to pull data from multiple webpages and process them efficiently. Additionally, the macro should also be able to parse HTML documents, identify useful data and process them accordingly. The desired outcome is a program that can be used to robustly scrape data from the web in an automated way, and store it in the desired format. The project requires the developer to apply their skills to create a customised product with...

...obtain the PC's serial number with the computer owner's agreement. • Create a VBA code that prevent tabs to be viewed without activation key. • Create or source a key creation tool to unlock the Excel document once pc’s serial number matches that obtained in step 1. • Write a macro or VBA into the Excel document that will validate the serial number on the computer trying to open the document and enable it to open, use and operate the Excel document. If that fails document will not open and cannot be viewed. • Develop a macro or VBA into the Excel document that will have an expiry date, determined by us, that will disable the tool and make it unusable after that date. • Provide suggestions on different possibilities for protecting th...

Hi, I have created a macro in i am unable to schedule the flow through power automate browser version. The flow that I require is: at a particular time excel file is opened, the macro is ran the macro execution is complete, the excel is closed . (please note:cannot use the power automate desktop flow for the above)

I am looking for a freelancer to help me fix a macro for importing a database. The macro is not clearing the sheet starting from row 2 before importing the data even though the line is there. I have taken a look at it and need some outside help to identify why it is not working. The import works well most of the time when the sheet is cleared but sometimes it doesn't actually clear the sheet before importing which leaves the old data in the sheet. It is all importing onto one sheet. Would prefer if someone can work on team viewer or any desk as the file is running in a virtual machine.

Looking for some to create a Macro that reads an order form and creates a csv file to be used for import that contains a column of product numbers and units ordered. The macro needs to have an execute "button." Upon execution the macro reads Column G and Column N in the attached order form, looking for any product that has a quantity >0 ordered and adds that product number and number of units ordered to the new CSV file.

retreiving data from the internet and populate the relative field in ana excel sheet the data are financial data, ratios and information rewgarding companies and stocks. The excel sheet has to be like a one - stop page where the same information are shown of any ticker that will be selected

Hello there! I am looking for a freelancer to help create a small excel macro for a project. The macro will send cell values from an excel spreadsheet of about 20 cells to a http post url. The cells will not change so I can use macro again

I'm looking for an experienced freelancer to help with an Excel VBA project. The project involves working with existing data, which I can provide. The desired output of this project is a macro enabled report. I'm looking for someone who is an expert in VBA programming and Excel, who is able to take the existing data and use it to create a macro enabled report that meets my specific needs and requirements. I require a professional, who has a good understanding of the VBA programming language and Microsoft Excel, and is able to complete tasks quickly and accurately. Experience with creating charts, tables and other visuals will be beneficial. I'm hoping to find a freelancer who has the right skills and experience to complete the project within the agreed upon ...

Hi. I would like to setup a micro script or a configuration which basically analyses a set of stock (based on the input of other historical charts) which were bullish and let it alert me when a stock is BULLISH and about to break out. Input is a set of 50 or70 stocks to monitor for the exact bullish shape prior to a break out. (The Macro would analyze the shape of the chart and alert me as it detects the break out shape) Apparently something like PINE SCRIPT can be used. Trading View Commodity Sector

I'm looking for someone that has expertise in SAS that can help me build a machine leaning model about a certian topic (to be discussed) on SAS viya. It will follow with a simple step by step PowerPoint

I am looking for a VBA Expert who can help me with a project that requires coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have exper...coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have experience with dashboard generation. The below is the sample project requirement. You will be interviewed based on your performance to provide resolution to below illustration. Whomsoever- want to apply create the macro in attached file ''compare data" two data and bring difference in other tab. It should be professional and can...

...American creative advertising specialist- strategist with experience. This is for an advertising campaign in Ecuador South America. The person needs to be latin american, from: Argentina, Colombia, Mexico, Perú, or Ecuador. I have an advertising digital agency. My client is starting an Online used car business. He wants to sell used car with loans. The first thing that I need is the advertising macro and creativity. Then the media applications including social media...

How will AI change the construction Industry. How to prepare for this change and its integration? Risks and Benefits! Effects on workforce employability and skills obsolescence! Any ethical, social and legal considerations. Recommendations proposed at the macro, meso and micro levels. 2000 words

Sticker_Label file created, with macros to import the Shipper info and get the label's format.

- I need to create an excel template/form file with 10-15 rows. - It will contains few drop downs, based on the first drop down it need to populate second drop - Few validations like datetime formats, numbers - Most important it need to generate a json file as an output at the end (using any technologies like VB, macro etc) - Good look and feel (optional)

I have a team of 5 people that work remotely in macro enabled excel files. I need someone to develop a web application connected to a database that will all be hosted in Azure so that the work can be centralized.

Hi, We have a custom-made timesheet for our staff that is entered manually into MYOB. We are looking for someone who can help create an easy method to extract that information into a .txt template to import into MYOB or create a new user-friendly Excel timesheet in line with the existing format that can be easily extracted as a .txt and imported. We have a macro-enabled timesheet and a list of jobs on another sheet to select from. The time slots are 15 minutes each and entered by staff using an assigned job number during the work day. The timesheets are for 1 week at a time and a new one is created for each week. Attached is a snapshot of the timesheet and a template txt file that it needs to be extracted into in order to import to MYOB. If this sort of thing is up your alley, ple...

I have a SAS Studio Analyse Project. I have attached the task file. Aslo I will share the Dateset file via chat box.

I have a SAS Studio Analyse Project. I will share the task file in via chat box.

Its a small project to analyse a dataset on SAS studio

Looking for a research writer in the field of macro-economics and equity market

Hi - I have a requirement to build a professional template in excel to import selective set of tables from word document and generate new excel in required format. This can be further enhanced during our brainstorming. Please let me know the possibilities. Thanks

I am looking for an experienced freelancer to build an Google Sheet based on Excel and macro. Script must save the google sheet with a new name and export a .csv file. File attach is excel Experience with Excel, macros, and Google Sheets will be essential for this project. The successful freelancer should have skills in Excel, VBA Macros, and working with Google Sheets. They should have experience converting data from an Excel format to a Google Sheets format, and be able to provide a demonstrated history of successful conversion projects.

Hi everyone – I’m looking for a talented photographer to help with a project. My photography needs consist of portraits, landscapes, and macro images, and they will be used both in print and digital formats. I’m not entirely certain if I’ll need the images edited yet, so I’m looking for someone whose experience and portfolio can speak for itself. I’m hopeful that with the right person on board, I’ll find the perfect combination of creativity and quality. If you think you’re the right fit, please get in touch and let me know – I’m excited to see what you have to offer!

I am looking for help with correcting an Excel VBA macro that I have already created. Specifically, I need help with the output. I am also looking for assistance in debugging the code. If you have any experience with Excel VBA macros, please feel free to respond to this project.

I need columns from 2 different excel files analysed automatically. with any changes highlighted

I want to make dashboard with various worksheets and clickable dropdown lists etc. upon which the visual charts and tables will change.

1. Changes on OpenAI form: 1.1. Replace default question for OpenAI form for both English and Swedish. 1.2. Add "Förstärk texten med emojis" macro to the OpenAI form. 1.3. Display active auktion for auktion filtering by default and add show all checkbox which show all the auktion for filtering 2. Go live the changes for /starter and filter pages. etc.

I am looking for an experienced and knowledgeable freelancer to create a macro using VBA language, which will be used in Word. The macro should be able to make all bolded text into the table of contents. The macro must be highly efficient and work reliably; I am looking for someone who has a proven track record with these types of projects and can get it done quickly. If you think you have the skills and experience necessary to complete this project, please get in touch. I look forward to receiving your proposals! I'm only will to pay $40 so if that is not in your budget, please don't apply.

I am looking for an experienced Excel professional to help with data entry, data validation, VBA & macro development. The data entry will be a mixed format, requiring manual and automated input. The data will also need to be validated according to an established date range. Additionally, I would need assistance in designing macros to help automate job tasks. If you have experience in these areas and are interested in this project, please don’t hesitate to reach out!

I have created the model in Spyder IDE for model performance I want accuracy, confusion matrix , macro-average precision,recall and F1 score on the console. I have got accuracy and confusion matrix but I am not able to see precision,recall and F1 score on the console. I just want that

Hello We need help to finish formulas and a simple macro in an excel file this is very simple for a excel specialist...

I have a file, wrote a macro and it keeps erroring out and not performing like i need it to. it gives me a subscript out of range error or object out range error. I need someone to help me get it figured out and i am hoping to resolve this in the next hour. see attached file.

I have a file, wrote a macro and it keeps erroring out and not performing like i need it to. it gives me a subscript out of range error or object out range error. I need someone to help me get it figured out and i am hoping to resolve this in the next hour. see attached file.

i need the Macro Guru only for multiple jobs. Details will be discussed.

Excel VBA macro Fixing task. Only bid if you can start right away. Need to get it done in next 2 hours max.

Hello, I need this done today, is it possible? I am working on a Macro to fill out PDF from Excel. I get the pdf to open and it the macro extracts the data, but the data is not being inputted into the fields on the pdf and is instead being returned to the macro. I need to also make sure that it is saving right. I need today. Thank you