Change Row Name Mat Stata

I have never before however seen a stata matrix whose row or column names begin with digits.

Change row name mat stata. This will work at least this far. The tricks and shortcuts mentioned were introduced with stata 12 0. Using stata mat c 2 1 5 1 3 4 5 4 2 mat lis c symmetric c 3 3 c1 c2 c3 r1 2 r2 1 3 r3 5 4 2 mat ct c mat lis ct symmetric ct 3 3 r1 r2 r3 c1. Prior to that some other commands such as the following were available.

If you load the mat file into a struct i e. See here note that stata won t let you name a variable 1960 1961 etc they can t begin with a number so i would go into the csv file or excel and manually rename them y1960 y1961 etc. Both import excel and import delimited will let you specify that the first row contains variable names. Which names matrix tokenize names local where newname local newnames matrix which names matrix newnames end examples.

No names informs stata whether variable names are included on the first line of the file roberto ferrer feb 7 16 at 23 54. A quick review in the user manuals has not turned up anything to say that it is illegal but it is also clear from the text and all examples that stata matrix row and column names are often intended to match variable names and of course a variable name cannot. In contrast the question mark stands for a single character in a variable name. But let me refer here to the stata help at help rename group.

Older versions of stata. You can then save the struct back out to the mat file with the struct flag. Matrcrename z col 4 sas column out of range r 498. Matrcrename z col 3 some alternative.

Row names returns a data frame with the row names changed. The load option with output argument then your variables become fields of that struct which allows you to rename them renaming variables themselves is not a fun task. In that case i will continue to use the solution suggested by stata tech support which changes value labels before any matrices are created. Mat li z symmetric z 3 3 x y z a 1 b 1 1 stata 1 1 1.

My final goal is a tab delimited text file that will be imported into a word processor to create a table like the one below. Read the first row. Start reading at row 2 use the macro variable from step 1 after an input statement. Mat li z symmetric z 3 3 x y z a 1 b 1 1 c 1 1 1.

Matrcrename z row 3 stata. Rename does not include the syntax variable unless that is a variable name. Row names is similar to rownames for arrays and it has a method that calls rownames for an array argument.