...0DEC2013
456 987654321DEF 31JAN2014
456 987654321GHI 02FEB2014
; I would like to reshape this data where the values of col_b are transposed to new columns and the minimum of the date column per c...
I want to reshape a matrix created in IML and convert it to a sas dataset while retaining the column and row names. For example, suppose I have an N by N matrix with row and column names.&n...
Hi, I need assistance in transforming Table 1 below into Table 2 The last 2 characters of the column headers need to match. I have color coordinated them below. The last two characters ...
Dear SAS community, wish you all well. Can I please ask how do I improve my SAS code to my problem? I have included a small partial output of how my exact data is like. I wish to reshape my d...
I have a matrix, x, that is numeric and 49X47. The second row contains all missing values. I would like to reshape it to a square matrix that is 47x47 by eliminating the first and second rows.&n...
Hello, I'm not sure if SAS does support a manipulation like this but if there is a way, please advise. I have a dataset that look like the following. From ...
I have this codes below. As I understand the length of item is from 1-13, IDnum is from 15-19 , Instock 21-22 backord 24-25.
the order that variable will be stored in the data is item indnum ...
Hello: I have a table "have" which can be created by the code attached. I would like to reshape it to the table "want" (see eg in the code). Basicly, the table "have" contains the counts of types o...
