En cours

Dataset: US Patents

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.

Compétences : Administration de Bases de données, FileMaker, Microsoft Access, MySQL, SQL

en voir plus : 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

Concernant l'employeur :
( 37 commentaires ) Singapore, Singapore

Nº du projet : #1613739

6 freelance font une offre moyenne de $412 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(74 Commentaires)

I can deliver the project to your specs

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(17 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)