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: open table from csv file


From   Sebastian Kruk <residuo.solow@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: open table from csv file
Date   Fri, 30 Jul 2010 16:24:40 -0300

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/


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