Starting from this table I'd like to obtain this other table (numeric part multiplied by 2) using proc iml only and without explicitly using the column names but rather using only variables created inside proc iml   The following code creates the table reads numeric and character subsets in proc iml multiplies by 2 the numeric subset exports the numeric subset by setting the same row names as the original table and the same column names as the numeric part of the original table   data HAVE; country = 'laos'; value = 18; h = 1; output; country = 'mira'; value = 21; h = 3; output; run; proc iml; use HAVE; read all var _NUM_ into num_mtx[colname=num_names]; read all var _CHAR_ into char_mtx[colname=char_names]; close; num_mtx = num_mtx*2; create WANT from num_mtx[colname=num_names rowname=char_mtx]; append from num_mtx[rowname=char_mtx]; close; quit;   And this is the output As you can see there is a problem: the name of the column containing the row names is char_mtx instead of country.   The problem could be easily solved by explicitly renaming the column during the export create WANT(rename=(char_mtx=country)) from ... but since I have to automize all the process, I cannot write the explicit column name (i.e. country) in the code.   Running print char_names; I noticed that char_names correctly contains the char column name however I'm not able to use it in order to rename the column containing the row names. I tried several commands such as    create WANT(rename=(char_mtx=char_names)) from ... and %let name = char_names; create WANT(rename=(char_mtx=&name)) from ... but none of them works. I also tried to create a new vector containing both the character and numeric column names, then setting the colname equal to that vector, but only the numeric subset columns are renamed as you can see below all_names = char_names || num_names; create WANT from num_mtx[colname=all_names rowname=char_mtx];   Any suggestion? I'm sure the problem is a piece of cake         ... View more

I'm using SAS EG 8.3 on a company computer which can be used only with a keyboard. Reading several tutorials, for example SAS Enterprise Guide 7.1: Accessibility Features SAS Help Center: Keyboard Shortcuts I learnt that there is a keyboard shortcut for (almost) everything, but I'm struggling with an apparently simple task: just moving the focus from the code editor to the log panel, and then go back to the code editor. For example, looking at the picture below, using the keyboard how to move the blinking cursor (inside the red circle) from the log to the code editor, so that I'm able to write code again? Similarly, when the cursor is in the code editor, I'd like to move the focus to the log panel so that I can navigate the log or look at the Output Data or Results panels.   I tried a lot of things to do the task displayed in the picture below, for example: With CTRL+TAB one can move from a tab to another (for example from Program to Start Page) but when I come back to the code editor the blinking cursor is still in the log box. With ALT one can move to "File" at the top left corner of SAS, and then with the keyboard arrows I can navigate the different menus and with TAB we can move to other elements of the GUI unitl I reach the left sidebar (Project, Servers), but then it goes back to "File". There is also a setting in Tools > Options > Results > General > Default tab to display, which can be changed so that after running code the focus is moved to another panel or stay to the code editor. This setting may help in some cases, but the problem depicted in the image still is not solved.   Any ideas?           ... View more