Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
304 results
Sorted by:
05-23-2018
04:23 PM
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...
09-23-2020
04:12 PM
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 ...
08-27-2015
10:03 PM
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...
10-09-2015
06:53 AM
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...
05-09-2017
07:31 AM
Hi have data like a 4 a 3 a 6 b 3 b 7 b 8 c 1 c 5 c 7 and want my data to the form 4 3 1 3 7 5 6 8 7
02-15-2020
08:47 AM
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 ...
01-26-2021
11:45 PM
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...
11-04-2020
05:35 PM
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 ...
03-18-2016
08:21 PM
Hi everyone,
I have a wide dataset similar to following table and want to reshape it to long. Variables' formats: name (character), date(date), new_id and original_id(numeric)
n...
05-26-2016
06:09 PM
RAW_DATA
Obs
Flag_A
Flag_B
Flag_C
Flag_D
Flag_E
Flag_F
Flag_G
N
1
No
...