Re: st: extracting of data

[Prakash Singh <prakashbhu@gmail.com>]

Jeph thanks for the kind help.
There seems to be small problem, if you could lighten a bit more then
I think I am through.

Though the loop is reading all the dct file within level but in the
end it gives error massage

file D:\TEAM_PC\level1_list.dta saved
file C:\Users\Prakash\AppData\Local\Temp\ST_00000003.tmp already exists
r(602);

Prakash


On Tue, Jan 22, 2013 at 11:49 PM, Jeph Herrin <stata@spandrel.net> wrote:
> Do you have 9 different .dct files for each level? Then maybe you intend
> something like this:
>
>
>  clear
>  set more off
>  set mem 500m
>  tempfile mydata
>  forv l=1/9 {
>     save `mydata', emptyok
>     forv d=1/9 {
>         infile using D:\TEAM_PC\level`l'\level`d'.dct, clear
>
>         capture append using `mydata'
>         save `mydata', replace
>         }
>     keep if level==`l'
>     save "D:\TEAM_PC\level`l'_list.dta", replace
>  }
>
> hth,
> Jeph
>
>
> On 1/21/2013 1:15 PM, Prakash Singh wrote:
>>
>> 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/
>>
>>
> *
> *   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/