Thank you for your question. I hope the following example clarifies your query: clear set obs 100 gen time = runiformint(1000, 2400) tostring time, replace gen hour = substr(time, 1, 2) // Extract the first two characters for the hour gen min = substr(time, 3, 2) // Extract the third and fourth characters for the minutes // Convert hour and min to numeric destring hour, replace destring min, replace

Thank you for reaching out to us. Replace the labels "good", "better", and "north" in `relabel()' with the desired year values. For example, say: "" graph bar inc (max) exp, bargap(-30) /// over(prov,relabel(1 "2021" 2 "2022")) I hope this answers your question.

thank you for your kind...

clear * Input -- end input a b c d 12 13 14 14 12 234 13 132 123 132 153 134 45 23 123 2435 12 13 14 14 12 234 13 132 123 132 153 134 45 23 123 2435 12 13 14 14 12 234 13 132 123 132 153 134 45 23 123 2435 12 13 14 14 12 234 13 132 123 132 153 134 45 23 123 2435 end rename a inc rename b exp rename c inf rename d age * gen clear set obs 30 gen a = 300 in f // f for first replace a = 1200 in 2/15 replace a = 5 in 16/20 replace a = 30 in l // l for last replace a = 700 if a==. rename a inc gen b = 900 * Data Editor clear

Thank you for your comment. The latest videos are free from any background music.

cls clear set obs 3000 * creating categorical variables a, b, and c gen a = round(runiform()*1) gen b = round(runiform()*3) gen c = round(runiform()*4) * creating discrete or continuous variables d, e, and f gen d = round(runiform()*100) gen e = round(runiform()*500) gen f = round(runiform()*1000) * Labeling categorical variables a, b, and c label define a 0 "Male" 1 "Female" label values a a label define b 0 "Spring" 1 "Autumn" 2 "Winter" 3 "Summer" label values b b label define c 0 "Go" 1 "Sit" 2 "Stand" 3 "Relax" 4 "Move" label values c c ** operating tabstat command ## labels of categorical variable "a" is displayed tabstat d e f, by(a) statist(n mean sum p10 p50) /// col(stat) longstub ## labels of categorical variable "a" is displayed, across labels of categorical variable b bysort b : tabstat d e f, by(a) /// statist(n mean sum p10 p50) /// col(stat) longstub ## labels of categorical variable "a" is displayed, across labels of categorical variable b and c bysort b c : tabstat d e f, by(a) /// statist(n mean sum p10 p50) /// col(stat) longstub

@@EconometricsMelody thanks for reply, with this example, suppose variable d is weight, variable e is height. I want tabstat table to provide label of variables in table, i.e. weight and height to appear in table instead of d and e

@@varunmiglani110 Before you run the tabstat command, make sure you first label the variables, eg. label variable d "Weight" label variable e "height" Now you can run the tabstat command and get the desired results tabstat d e f, by(a) statist(n mean sum p10 p50) /// col(stat) longstub Look at this video kzbin.info/www/bejne/mquXdKKHbNGKeJY for a detailed understanding of labeling the variables and values.

@@EconometricsMelody the problem still persists , tried these commands, still variable names are displayed in table and not label of variable

@@varunmiglani110 With reference to Stata version 15, unlike the commands "table" and "tabulate," tabstat does not display the label of a variable. However, you can manually edit the variable name when preparing the table from the tabstat outputs, or you can rename the variable without any spaces. Here are some suggested variable namings: 1) Rename variable "d" to "weight" and rename variable "e" to "height": rename d weight rename e height Then you can use tabstat with the renamed variables: tabstat weight height f, by(a) 2) Alternatively, if you want to rename the variables with longer names, you can use the following approach: rename d weight_of_the_children_under_18 rename e height_of_the_children_under_18 Then you can use tabstat with the renamed variables: tabstat weight_of_the_children_under_18 height_of_the_children_under_18, by(a) Both of these approaches will allow you to manually edit the variable name or use renamed variables to display meaningful labels in the tabstat output.

How to remove extra space from the column?

clear set obs 10 gen a = " do it now ok " split a, gen(m) gen b = m1+m2+m3+m4 order a b

clear set obs 10 gen a = " do it now ok " split a, gen(m) egen b = concat(m*) order a b

kzbin.info/www/bejne/pKHCi4yVf6ySbck

kzbin.info/www/bejne/l6WoeaWCorWbgbc

clear set obs 12 gen a =23 gen b = "adf" gen c = string(a)+b

egen d = concat(a b), punct("")

Thank you very much. It means a lot to us.

Than you very much. It means a lot to us.

Thank you very much

Thank you very much ...

Thank you very much Chitwambi Makungu

Thank you Beny smart

Thank you very much Ghofran Ghofran