Dataset: US Patents

In Progress

I need two datasets containing some new variables constructed out of 4 existing flat files that are available online (these large are files). In step 1, I describe the relations between these four flat files for merging purposes. In the second step, I need some new variables to be created using the linked data created in step 1. I then need these new variables output into two flat files that are preferably in either SAS or STATA format.

We are not concerned about which database tools are used to merge the data (e.g. SQL, etc.). Ideally, the output should not be in csv/excel format.

The attached file provides more details on steps 1 and 2.

Note: We previously tried to have an MS Access DB created along these dimensions which appeared too cumbersome and did not work.

Skills: Database Administration, FileMaker, Microsoft Access, MySQL, SQL

See more: ms access online, in sas, microsoft access online, stata sql, SAS, sas database, csv merge, sql merge data excel, flat file access, microsoft merge, excel csv online, excel sql merge, data merging, sql file csv, access sql merge, merge excel data sql, access merge csv files, large dataset, merge csv sql database, sql data csv, data merge excel, merge sql database, step format file, sql merge excel sql, merge database csv

About the Employer:
( 35 reviews ) Singapore, Singapore

Project ID: #1613739

6 freelancers are bidding on average $412 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$500 USD in 10 days
(74 Reviews)
6.9
srinichal

I can deliver the project to your specs

$620 USD in 5 days
(17 Reviews)
5.7
puneethmech

As I am ETL person working on Data models , Will be able to finish this work!

$300 USD in 5 days
(2 Reviews)
2.9
jr593

I can provide a high quality result, with 100% error free output. Please check your PM thanks

$300 USD in 4 days
(1 Review)
2.8
shael2

Hi I am interested to work on this project> i have a good experience of doing such projects . Please read the private message. Warm Regards Mohit Softprone Technologies

$250 USD in 7 days
(2 Reviews)
2.4
rgupta2704

I have over 10 years experience in working on projects. I have completed projects for domestic as well as international clients. My personal strengths are good presentation, communication and interpersonal skills. Fur More

$500 USD in 5 days
(0 Reviews)
0.0