Re: st: extracting of data

[Prakash Singh <prakashbhu@gmail.com>]

Nick
Though I managed to write the code and run it but I realised today
that for each level stata is extracting data from only one txt file.
which means that only one dct file is being read.

here is the revised code

clear
set more off
set mem 500m
tempfile mydata
forv l=1/9 {
	infile using D:\TEAM_PC\level`l'\level`l'.dct, clear
	capture append using `mydata'
	save `mydata', replace
	keep if level==`l'
	save "D:\TEAM_PC\level`l'_list.dta", replace
}


Regards
Prakash

On Tue, Jan 1, 2013 at 9:32 PM, Prakash Singh <prakashbhu@gmail.com> wrote:
> Thanks Nick
> I got it finally
>
> Best wishes to all stata listers for 2013
>
> Regards
> Prakash
>
> On Mon, Dec 31, 2012 at 11:10 PM, Nick Cox <njcoxstata@gmail.com> wrote:
>> I don't understand what is holding you up. Your code shows that you
>> are familiar with -foreach- and -forval-. So you need to write another
>> big loop using that construct.
>>
>> Nick
>>
>> On Mon, Dec 31, 2012 at 4:37 PM, Prakash Singh <prakashbhu@gmail.com> wrote:
>>> Nick, I thanked you for that
>>>
>>> I mentioned in the first mail that the structure of the data is such
>>> that to have final data I need to extract 9 (using 9 dct file for each
>>> level) different level files then some of them I need to reshape and
>>> then merge them.
>>>
>>>
>>> Hope, I have made my query more clear to you.
>>>
>>> regards
>>> Prakash
>>> On Mon, Dec 31, 2012 at 9:48 PM, Nick Cox <njcoxstata@gmail.com> wrote:
>>>> You don't comment on my replacement of 9 lines of code with 1.
>>>>
>>>> Your main loop looks like another -forval- or -foreach- loop but you
>>>> don't explain why you want to save different levels in different
>>>> datasets.
>>>>
>>>> Nick
>>>>
>>>> On Mon, Dec 31, 2012 at 2:27 PM, Prakash Singh <prakashbhu@gmail.com> wrote:
>>>>> Nick sorry but that is type error.
>>>>> Thanks for the suggestion anyway.
>>>>>
>>>>> Moreover I am looking some help on creating look so that I can repeat
>>>>> the following code for each level 1 to 9.
>>>>>
>>>>> clear
>>>>> set more off
>>>>> set mem 500m
>>>>> tempfile mydata
>>>>> foreach l of numlist 11/19 {
>>>>>    infile using D:\TEAM_PC\level`l'.dct, clear
>>>>>    capture append using `mydata'
>>>>>     save `mydata', replace
>>>>> }
>>>>> use `mydata', clear
>>>>> keep if level==1
>>>>> save level1_list.dta", replace
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/