Urgent SPSS or SAS very small project!!

Hello, I need help for an urgent SPSS or SAS project.

For this project, a source file called "totranspose" is provided , which is a table with comma-separated columns. First column is a string, all the others are integers. This first table is to be converted into another table with a program/script that winner would write, a program that I would be able to use on other similar tables as the totranspose table. A second file called [url removed, login to view] is provided in order to facilitate comprehension of the problem (see below).

The totranspose table contains a lot of columns (around 1750 columns), with first row containing the headers, thus we have the column ID and then the columns 16, 17, 25 till 6869. From this first table, another second table must be created containing all the information present in the first table. In the second table, I only want three columns: a column "ID" as in the first table, a column called "PI" that contains the values for each column of the first table (ie the values present in the columns 16, 17, 25 to 6869 of the first table) and a third column called "NUMBER" that correspond to the header of the column. The third column just indicates from which header the values have been taken from (so, for example, the number 16 will be repeated a few times, the same is true for the number 17, 25 till 6869). In other words, all the columns 16, 17, 25 till 6869 should be put one under the other (so column 17, will be under column 16, column 25 will be under column 17 and so on till column 6869). We thus end up with a second table with many many lines (instead of many many columns as in the first table). The excel file attached called [url removed, login to view] will help you to understand what I want from the first table "totranspose" (in the example, I thus started to do it manually).

Please note that I need a script/program that can automatically convert any table having the same format as the "totranspose" file (I will have other similar files in the future, with the same structure, that I need to convert but which will have more columns and more lines). The output file should be a txt file.

Looking forward to your bids,


Taidot: tietojenkäsittely

Näytä lisää: SPSS projects, sas stata, xls header, up string, the string problem, string processing in c, string problem, string in data structure, string data structure, integers and, facilitate it, data structure problem, data structure note, convert number to words in excel, convert sas table individual data, spss convert word, convert spss script project, freelance job spss sas, sas spss conversion, sas spss convert 2009, spss conversion excel files, open source conversion sas spss, converting rows comma seperated columns sas, statistical analysis spss, sas project free

Tietoa työnantajasta:
( 0 arvostelua ) Geneva, Switzerland

Projektin tunnus: #425773

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Look PM please

$55 USD 1 päivässä
(7 arvostelua)

i like to do this job

$100 USD 5 päivässä
(0 arvostelua)

this is my first job in this website so only i did this job with low money

$99 USD 10 päivässä
(0 arvostelua)

I am a statistician, working with SPSS all day, every day. I can do this easily, I'll make a syntax that's usable for other files like this one as well, with instructions how to use it.

$125 USD 7 päivässä
(0 arvostelua)

Hi, You will enjoy the service of a professional statistician. Pls check PMB for more.

$40 USD 1 päivässä
(0 arvostelua)

I can do you work in Excel in 1 hour. If an Excel solution is okay with you please contact me. Regards.

$35 USD 1 päivässä
(0 arvostelua)

Hi, please check the PM for details. Thanks.

$40 USD 0 päivässä
(0 arvostelua)

sir,please give me this job ,i know very well how to do this work

$30 USD 1 päivässä
(0 arvostelua)

Hi, We can do this by writing a script in SPSS. We do have lot of experience in SPSS Scripting. We are group of three Statistician doing market research projects. Please provide us an opportunity, we will prove ours Lisää

$30 USD 1 päivässä
(0 arvostelua)

I am a professional statistician. Bachelor's degree. Let's start.

$35 USD 2 päivässä
(0 arvostelua)

I am an engineering graduate from IIT Kanpur. I have more than two years of experience with SPSS. Can do this task very quickly and efficiently.

$75 USD 1 päivässä
(0 arvostelua)

i m a statistician with market research/ clinical industry experiences

$35 USD 8 päivässä
(0 arvostelua)