Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: open table from csv file


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: open table from csv file
Date   Fri, 30 Jul 2010 21:38:50 +0200

<> 


Your data will require surgery, see the recent
http://www.stata.com/statalist/archive/2010-07/msg01265.html




HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Sebastian Kruk
Gesendet: Freitag, 30. Juli 2010 21:25
An: statalist@hsphsun2.harvard.edu
Betreff: st: open table from csv file

Dear all,

I have a csv file with a table what I want to use it, columns are
months and rows are years. Do I have to use insheet and then combine
columns?

For example first 5 years are:


	1990	                1991	                1992
1993	
              1994
					
mean	1,479326421	1,495925444	1,303478865	1,607773914
1,583957871
					
1	1,771154084	1,895948998	1,11141386	1,734593998
1,497756215
2	1,757857006	1,58194736	1,127595638	1,998219562
1,497143745
3	1,083821477	1,068027206	1,325017202	1,048764884
1,411963473
4	1,168200955	1,171181418	1,216362048	1,40308408
1,93351786
5	1,961940615	1,06707611	1,720292235	1,40055235
1,588392367
6	1,652619236	1,730939194	1,122304789	1,809156879
1,411537766
7	1,176224668	1,27746496	1,015194709	1,931876725
1,69622126
8	1,684312887	1,482043153	1,846568056	1,885092942
1,805751811
9	1,092914801	1,722992564	1,011772831	1,715600999
1,987044829
10	1,817043613	1,807681016	1,600595916	1,745284118
1,561033528
11	1,52957095	1,177749318	1,202591678	1,496120968
1,534938618
12	1,056256755	1,968054034	1,342037419	1,124939466
1,082192981


Thanks,

Sebas.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index