Re: st: Float invalid

[Ronnie Babigumira <rb.glists@gmail.com>]

This looks complicated! I must admit I do not know the answer to your problem, however, I have a couple of comments.

My first comment would be that it might be easier if you break it up into smaller chunks and then -merge- the smaller datasets. 

Second, probably a good thing given the number of variables, you neither showed any data nor the actual error code so, not much to work with, however, here is a dummy dataset for your first two variables (for 3 years)

set seed 1234 
// Create dummy dataset
clear
set obs 10
gen coy_id = _n
foreach i of numlist 91 92 93 {
    foreach v of newlist a_dirs_by_board a_dirs_by_exec {
               gen `v'_`i' = uniform() > .5
       }
} 

order coy_id a_dirs_by_board* a_dirs_by_exec* 

// Reshape
reshape long a_dirs_by_board_@ a_dirs_by_exec_@, i(coy_id) j(year) string

This works and so I imagine doing a few of these and them merging the created datasets with both get you where you wanna be but also, make it easier for you to identify the problem variables

Ronnie 

-- 
010100100110111101101110011011100110100101100101




On Thursday, May 24, 2012 at 10:20 PM, Ozgur Ozdemir wrote:

> 
> Hi,
> please find my command below:
> reshape long a_dirs_by_board_@ a_dirs_by_exec_@ a_dirs_by_nonexec_@ a_ex_with_pre_nex_sf_@ a_hist_fy_ex_by_ex_@ a_hist_fy_ex_by_nex_@ a_hist_fy_exbyex_nexbynex_@ a_hist_fy_exbynex_nexbyex_@ a_hist_fy_nex_by_ex_@ a_hist_fy_nex_by_nex_@ a_hist_nof_dir_by_board_@ a_hist_nof_dir_by_ex_@ a_hist_nof_dir_by_nex_@ a_hist_nof_ex_by_ex_@ a_hist_nof_ex_by_nex_@ a_hist_nof_exbyex_nexbynex_@ a_hist_nof_exbynex_nexbyex_@ a_hist_nof_nex_by_ex_@ a_hist_nof_nex_by_nex_@ a_nex_with_pre_ex_sf_@ a_nexpreex_exprenex_sf_@ a_numberof_ex_by_ex_@ a_numberof_ex_by_nex_@ a_numberof_exbyex_nexbynex_@ a_numberof_exbynex_nexbyex_@ a_numberof_nex_by_ex_@ a_numberof_nex_by_nex_@ a_portfoliocat_@ a_portfolioperc_@ adj_d_@_salbon adj_mv_@ 
> adj_wc01001_@ adj_wc02999_@ board_rate_@ 
> busy_board_@ ce_fin_exp_@ ce_own_@ 
> ce_rate_@ 
> ce_sf_exp_beforece_@ 
> cf_fin_exp_@ cf_own_@ cf_rate_@ 
> cf_sf_exp_beforecf_@ 
> ch_fin_exp_@ ch_own_@ ch_rate_@ 
> ch_sf_exp_beforech_@ 
> committee_rate_@ d_@_salbon d_@_salbonovertotassets d_@_sumofbonus d_@_sumofsalary d_@_sumoftotal dn_@_salbon 
> dn_@_salbonovertotassets 
> exec_rate_@ exist_@ experienced_ce_@ experienced_cf_@ experienced_ch_@ large_shrhldrid_@ large_shrhldrid_curr_pcent_@ large_shrhldrid_hold_date_@ large_shrhldrid_ind_@ large_shrhldrid_manuel_type_@ leverage_@ 
> log_adj_d_@_salbon 
> log_adj_mv_@ 
> log_adj_wc01001_@ 
> log_adj_wc02999_@ log_mv_@ log_oo_boardsize_@ log_tobin_q_@ 
> log_wc01001_@ 
> maintainstake_d_@ 
> maintainstake_dirs_@ 
> maintainstake_m_@ 
> maintainstake_n_@ 
> max_dirs_by_anydir_@ mv_@ n_@_salbon 
> n_@_salbonovertotassets 
> n_@_sumofbonus 
> n_@_sumofsalary 
> n_@_sumoftotal nonexec_rate_@ nonzeropoints_d_@ nonzeropoints_dirs_@ nonzeropoints_m_@ nonzeropoints_n_@ noof_busy_dirs_@ noofshareholders_@ oo_boardd_@ 
> oo_boardindep_@ oo_boardn_@ oo_boardsize_@ oo_sepch_@ 
> oo_sub_index_@ op_d_@ op_dirs_@ 
> op_m_@ op_n_@ p_@ 
> perc_busy_dir_@ roast_@ roe_@ 
> saset_@ shortdebt1_@ shortdebt2_@ 
> shrhldrid_noof_ind_intlocks_@ 
> shrhldrid_t_ind_inv_perc_@ shrhldrid_a_ind_inv_perc_@ t_dir_ind_dir_@ t_dir_past_ce_@ t_dirs_by_board_@ t_dirs_by_ce_@ t_dirs_by_cf_@ t_dirs_by_ch_@ t_dirs_by_exec_@ t_dirs_by_nonexec_@ t_ex_with_pre_nex_sf_@ t_exec_ind_dir_@ t_exec_past_ce_@ t_hist_fy_ex_by_ex_@ t_hist_fy_ex_by_nex_@ t_hist_fy_exbyex_nexbynex_@ t_hist_fy_exbynex_nexbyex_@ t_hist_fy_nex_by_ex_@ t_hist_fy_nex_by_nex_@ t_hist_nof_dir_by_board_@ t_hist_nof_dir_by_ex_@ t_hist_nof_dir_by_nex_@ t_hist_nof_ex_by_ex_@ t_hist_nof_ex_by_nex_@ t_hist_nof_exbyex_nexbynex_@ t_hist_nof_exbynex_nexbyex_@ t_hist_nof_nex_by_ex_@ t_hist_nof_nex_by_nex_@ t_nex_with_pre_ex_sf_@ t_nexpreex_exprenex_sf_@ t_nonexec_ind_dir_@ t_nonexec_past_ce_@ t_numberof_ex_by_ex_@ t_numberof_ex_by_nex_@ t_numberof_exbyex_nexbynex_@ t_numberof_exbynex_nexbyex_@ t_numberof_nex_by_ex_@ t_numberof_nex_by_nex_@ tobin_q_@ 
> tobin1_@ wc01001_@ wc01201_@ 
> wc02999_@ wc03051_@ wc03255_@ 
> wc03351_@ wc03451_@ wc07011_@ 
> wc08316_@ wc3501_@ wc02001_@ dupno_@ 
> d_rep_@ m_rep_@ nonvoting_@ mperc10concent_@_nodup1 mperc3concent_@_nodup1 mperc5concent_@_nodup1 ownd_@_nodup1 
> ownn_@_nodup1 owndandn_@_nodup1 large_shrhldrid_coport_perc_@
> instownperc3concent@
> instownperc5concent@ instownperc10concent@ op_inst_@ maintainstake_inst_@
> nonzeropoints_inst_@ tobin2_@ wc04551_ wc08001_@ volatility1_@ volatility2_
> volatility3_@ volatility4_@ ptbv_@ pe_@ all_cr1_@, i(coy_id) j(year) string 
> 
> 
> 
> 
> 
> 
> kind regards
> Ozgur Ozdemir
> 
> 
> 
> ----------------------------------------
> > Date: Thu, 24 May 2012 22:11:37 +0200
> > From: rb.glists@gmail.com (mailto:rb.glists@gmail.com)
> > To: statalist@hsphsun2.harvard.edu (mailto:statalist@hsphsun2.harvard.edu)
> > Subject: Re: st: Float invalid
> > 
> > As has been said many times, showing what you typed and some data will increase the likelihood of getting a solution to your problem.
> > 
> > 
> > --
> > 010100100110111101101110011011100110100101100101
> > 
> > 
> > 
> > 
> > On Thursday, May 24, 2012 at 10:06 PM, Ozgur Ozdemir wrote:
> > 
> > > 
> > > 
> > > Hi,
> > > when I use the reshape long command it is giving the following error message "Variable name : Float invalid", when I delete the variable with the problem, it keeps giving for other variables.
> > > 
> > > 
> > > 
> > > kind regards
> > > Ozgur Ozdemir
> > > 
> > > *
> > > * 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/
> 
> 
> 
> *
> * 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/