About usuario_estudo

usuario_estudo · ‎04-08-2020

I'd like to write a code that creates column C from A and B. Column C will be, the value of A from the row where B is the smallest value greater or equal to 0.99. If there are repeated values as in the example, the value must be the first of them. A B C 1 0.2 4 2 0.05 4 3 0.9 4 4 0.9901 4 5 0.9901 4 6 0.9901 4 7 0.995 4

usuario_estudo · ‎04-06-2020

I'd like to write a code that would do a recursive multiplication in one column. I have columns A and B and the idea is to calculate the column C as follows: When B is different from empty, then B=C. When B is empty, then the value for the line "i" of C is the value for the line "i" of A times the value for line (i-1) of C, as in the example below: A B C 11 6 6 2 27 27 7 12 12 8 . 96 3 . 288 4 . 1152

usuario_estudo · ‎04-06-2020

Table Have ID ID_REF X 1 4 0,33 2 4 0,4 3 4 0,12 4 4 0,8 5 4 0,154 Table Want ID ID_REF X Y 1 4 0,33 0,33 2 4 0,4 0,4 3 4 0,12 0,12 4 4 0,8 0,8 5 4 0,154 0,8 I want to create a code to create the column Y, whose value will be: when ID<ID_REF, then Y=X, when ID>=ID_REF, then Y will always have the same value, which will be the value of X when ID=ID_REF

usuario_estudo · ‎04-03-2020

I want to change this code that will fill a variable with the ID corresponding to a minimum age. Because in case we have more than one ID with the same minimum age, I would like to bring the minimum ID (containing the minimum age) for the variable ID_AGE_MIN. proc sql; create table want as select *, (select id from have having min(age)=age) as id_min_age from have; quit;

usuario_estudo · ‎04-03-2020

I want to change this code that will fill a variable with the ID corresponding to a minimum age. Because in case we have more than one ID with the same minimum age, I would like to bring the minimum ID (containing the minimum age) for the variable ID_AGE_MIN. proc sql; create table want as select *, (select id from have having min(age)=age) as id_min_age from have; quit;

usuario_estudo · ‎04-02-2020

@PeterClemmensen

usuario_estudo · ‎04-02-2020

It's perfect. I just had one problem: In case you have more than one ID with the same minimum age. In this case, I would like to bring the smallest ID (containing the smallest age) for the variable ID_AGE_MIN.

usuario_estudo · ‎04-02-2020

I would like to create a code that fill in a variable with the value which is the id corresponding to a minimum age. In case you have more than one ID with the same minimum age, Iwould like to bring the smallest ID (containing the smallest age) for the variable ID_AGE_MIN, e.g: ID AGE ID_MIN_AGE 1 13 3 2 25 3 3 7 3 4 7 3

usuario_estudo · ‎06-04-2019

Hello, Please, can anybody help me? I need to join two tables (TABLE 1 and TABLE 20 to get TABLE 3, as I explain and exemplify it in the attached excel.) Can you help me, because I am not able to create this code. I need to do this in SAS in sql, for a number of variables and a larger amount of values. What I send in excel is just one example.

usuario_estudo · ‎10-31-2018

Hi, I need a function in SAS that reads horizontally. I have to create a variable "Number of completed months" that returns the value of months that are filled until it arrives empty (missing "."). Example: ID MONTH_1 MONTH_2 MONTH_3 MONTH_4 MONTH_5 MONTH_6 MONTH_7 MONTH_8 "Number of completed months" 1 10 22 31 65 . . . . 4 2 152 111 . . . . . . 2 3 1 97 198 . . . . . 3 4 338 67 59 32 12 84 . . 6 5 100 176 90 220 81 88 887 78 8 Thnak you!

usuario_estudo · ‎10-16-2018

Yes, it's perfect, thank you!!!

usuario_estudo · ‎10-16-2018

Ok, I did that. Thank you very much!

usuario_estudo · ‎10-16-2018

Thank you very much, that was exactly it. Could you tell me how to change the code if I want to do the same for each different IDs? Example: Input table ID Flag Sub 1000 2 NA 1000 1 AB 1000 9 UH 1000 1 IF 1000 5 GE 1000 1 IP 1000 1 AB 1000 1 EH 1000 1 IA 2000 5 NA 2000 6 AB 2000 7 UH 2000 1 IF 2000 10 GE 2000 1 ES 2000 1 SW 2000 1 GF 2000 1 DY 2000 1 ZX Output table ID Flag Sub 1000 1 IP 1000 1 AB 1000 1 EH 1000 1 IA 2000 1 ES 2000 1 SW 2000 1 GF 2000 1 DY 2000 1 ZX

usuario_estudo · ‎10-16-2018

Hi, I need to make a filter keeping only all the last rows marking "Flag=1". Reading from bottom to top, I want to keep only the results until I get a value other than 1 for the variable "Flag". Here's an example in the table below. Input table ID Flag Sub 1000 2 NA 1000 1 AB 1000 9 UH 1000 1 IF 1000 5 GE 1000 1 IP 1000 1 AB 1000 1 EH 1000 1 IA Output table ID Flag Sub 1000 1 IP 1000 1 AB 1000 1 EH 1000 1 IA I need to have a SAS code that does this, could anyone help me? Thank you very much!

usuario_estudo · ‎10-16-2018

Thank you for the code, but it does not return the desired result. I would like to return the following table: ID Flag 1000 1 1000 1 1000 1 1000 1 2000 1 2000 1 2000 1 Thank you very much!

Online Status	Offline
Date Last Visited	‎04-14-2020 03:45 PM

Matching values

Recursiveness in SAS

create columns using the row value of another column

Fill a variable matching by lines

Fill a variable matching by lines

Re: Create a code in SAS with correspondences by line (like a vlookup)

Re: Create a code in SAS with correspondences by line (like a vlookup)

Create a code in SAS with correspondences by line (like a vlookup)

join tables with "lag"

Function reads horizontally

Re: Create a code in SAS with correspondences by line (like a vlookup)

Matching values

Recursiveness in SAS

create columns using the row value of another column

Fill a variable matching by lines

Fill a variable matching by lines

Re: Create a code in SAS with correspondences by line (like a vlookup)

Re: Create a code in SAS with correspondences by line (like a vlookup)

Create a code in SAS with correspondences by line (like a vlookup)

join tables with "lag"

Function reads horizontally

Re: Filter the last rows

Re: Filter the last rows

Re: Filter the last rows

Filter the last rows

Re: SAS - Filter