...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...
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 data...
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 &n...
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 i...
Hello, i have a sales dataset as shown below, i am facing a problem to manipulate the data with the Dates presented as attributes in the top row, can someone suggest a method to reshape t...
...o looking for some help/guidance. I have a dataset that looks like: data have;
input id tr1 tr2 tr3 tr4;
cards;
1 AAA BBB GGG FFF
2 DDD CCC AAA BBB
3 BBB AAA JJJ VVV
;
run; The o...
...student can have different types of violations that fall under the same incident type; and c) different students have different number of incidents and violations. How do I reshape this long data...
