I have a SAS table with more than 100 columns like this->
A B C D E F
8 3 7 1 3 3
. . . . . .
. . . . . .
. . . . . .
Now I want to create a new table where against each variable nth maximum value is mentioned like this->
Variable Name nth Max Value
A 21
B 45
C 32
D 64
E 13
. .
. .
How can I derive such a table?
... View more
I want the following output by using the lag function using multiple by variables.
A B C Lag(C)
a d 1 .
a d 2 1
a e 3 .
b e 4 .
b e 5 4
c e 6 .
c f 7 .
c f 8 7
But the output I am getting is this-
A B C Lag(C)
a d 1 .
a d 2 1
a e 3 2
b e 4 3
b e 5 4
c e 6 5
c f 7 6
c f 8 7
... View more
Yes exactly, I want the lag function to be executed just for the case where Col-A is equal to "Y", Like this - A B lag1(B) lag2(B) X 4 X 3 Y . 3 4
... View more
Thank you for your in-depth explanation but I am still not very clear about why it doesn't work with IF-Then on the other works perfectly with Ifn function. I guess my basic understanding of base sas is not very clear.
... View more
Col-A Col-B
X 9
X 4
X 3
Y .
X 1
I want to add the last values of Col-B when Col-A is equal to "Y" and replace the null value by it
Output ->
Col-A Col-B
X 9
X 4
X 3
Y 7
X 1
To achieve this output I am using this code->
data table;
set table;
if "Col-A"n = "Y"
then "Col-B"n=lag1("Col-B"n)+lag2("Col-B"n);
run;
But I am getting the following error in this code ->
NOTE: Missing values were generated as a result of performing an operation on missing values.
Note- I am getting proper output when I am storing the lag function variables first and then adding them,
But I don't want to unnecessarily store variables.
... View more
I have a date column like this -
Joining Date
03/01/2020
24/09/2020
25/07/2019
I want to derive the last date for the whole column like this -
31/01/2020
30/09/2020
31/07/2019
... View more
I have a column in a table like this -
Column A
1
2
6
.
.
.
Now I only want to replace the first missing value in the column with a numeric value(For ex -10)
Output
Column A
1
2
6
10
.
.
The code should be dynamic, i.e. It should automatically identify the first missing value and then replace it.
... View more
data WORK.test; merge WORK.sample_table WORK.sample_table (firstobs=2 keep=SerialNumber rename=(SerialNumber=_SerialNumber)); /* further processing */ run;
After executing the above code 1 empty cell will get created in the last row of the column, now I want to define a certain value to be filled in that empty/null cell. How can I achieve that?
... View more
When using "firstobs" function on a column it creates a lookahead column because of which empty cells are created(Number depends on the argument used in the lookahead function) at the end of the column. Is there any way I can define the value to be filled in that empty cell?
... View more
I have a numeric column like this-
Col A
100%
100%
0%
0%
100%
0%
I am trying to convert it into character format for which I am using the following code -
put(t1."Col A"n, 10.)
From which I am getting this output -
Col A
1
1
0
0
1
0
Why am I getting this output?
... View more
I have a dataset with 100k rows, I want to add a column with serai number from 1 to 100k, but I want to write the code which is dynamic i.e.it should work with a dataset of any size (for example 1000 rows, 5000 rows, etc)
... View more
