Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Float invalid
From
Ronnie Babigumira <[email protected]>
To
[email protected]
Subject
Re: st: Float invalid
Date
Thu, 24 May 2012 23:41:27 +0200
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: [email protected] (mailto:[email protected])
> > To: [email protected] (mailto:[email protected])
> > 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/