About bharath86

bharath86 · ‎12-09-2020

@Kurt_Bremser @PeterClemmensen @hhinohar Hi, Data I have ID parameter miles age value 2 1 . . 9 2 2 . . 156 2 3 . . 2 . 0 2 . 2 . 0 2 . 2 . 1 9 . 2 . 5 16 . 2 . 3 17 . 2 . 7 48 . 2 . 5 48 . 2 . 9 60 . 2 . 9 72 . 2 . 9 96 . 2 . 9 108 . 2 . 9 132 . 2 . 9 156 . 12 1 . . 5 12 2 . . 5.5 12 3 . . . 12 . 0 5 . 12 . 0 10 . 10 1 . . 2 10 2 . . 12 10 3 . . Data I want ID parameter miles age value 2 1 . . 9 2 2 . . 156 2 3 . . 17 2 . 0 2 . 2 . 0 2 . 2 . 1 9 . 2 . 5 16 . 2 . 3 17 . 2 . 7 48 . 2 . 5 48 . 2 . 9 60 . 2 . 9 72 . 2 . 9 96 . 2 . 9 108 . 2 . 9 132 . 2 . 9 156 . 12 1 . . 5 12 2 . . 5.5 12 3 . . 10 12 . 0 5 . 12 . 0 10 . 10 1 . . 2 10 2 . . 12 10 3 . . . 1. Valid miles (between 2 to 9) 2. If the parameter is 3 and miles is between 2 to 9 then pick the age value of earliest miles (which is 3 and age is 17 in case of ID 2). 3. If the parameter is 3 and miles not in 2 to 9 then assign max age for each ID (which is 10 incase of ID 12) 4. If there are miles or age leave the value of parameter 3 to blank. (incase of ID 10)

bharath86 · ‎12-09-2020

Hi Thanks, This works to the extent, but not for multiple if statements. I need to do the same activity for other variables as well. Thanks again.

bharath86 · ‎12-09-2020

Hi Yeah this is working, reason for the failure is in some cases the values are not the same like in ID, for instance ID has 2 rows with value 12 but in some cases there are different values, in such cases is should take the max value. I am thinking how to assign max value for death.

bharath86 · ‎12-08-2020

ID Transaction Age Death Parameter Value 6 1 . . A 6 2 . . B 6 3 . . C 6 . 3 3.45 8 1 . A 8 2 . B 8 3 . C 8 . 2 12 8 . 2 12

bharath86 · ‎12-08-2020

Value retains values of first ID to the next ID instead of looking for new values for next ID

bharath86 · ‎12-08-2020

Hey sorry about that, I didnt knew. Anyways thanks for checking in.

bharath86 · ‎12-08-2020

I have tested your code it works but this doesnt serve my purpose using sql, It has to be in a data step in order to process all the other statements.

bharath86 · ‎12-08-2020

SQL may be working but I need it in a data step as I have numerous if statements to be processed under similar scenario. For me the Ideal way would be data step. Thank you.

bharath86 · ‎12-08-2020

Hi I have multiple Id's and transaction 1,2,3 are always blank. I only need to look for values in other than (1,2,3) rows. I may have any number of rows after transaction 3 but i need to look into all the rows and assign the value. ID Transaction Age Death Parameter Value 6 1 . . A 6 2 . . B 6 3 . . C 6 . 3 3.45 8 1 . A 8 2 . B 8 3 . C 8 . 2 12 8 . 2 12

bharath86 · ‎12-08-2020

@Kurt_Bremser @PeterClemmensen @hhinohar Hi, Below is an example of data I have. My requirement is, If my parameter is B then value = Death, but in this case the row is blank however there is a death value in some other row. It doesnt matter in which row the value is in but the code should look in all rows for an ID and assign the value. I want this to be in a data step as I have numerous if statements to process and there may be multiple ID's but the transaction rows are always empty, code should look at all rows beyond transaction 3 to find the value. Data I have ID Transaction Age Death Parameter Value 6 1 . . A 6 2 . . B 6 3 . . C 6 . 3 3.45 Data I want ID Transaction Age Death Parameter Value 6 1 . . A 6 2 . . B 3.45 6 3 . . C 6 . 3 3.45 Please advise. Thank you

bharath86 · ‎11-30-2020

Hey, Thank you for the response. You been amazingly helping me here.

bharath86 · ‎11-30-2020

Hey, Thank you for the response. All three solutions are working actually. I just haveto accept the first one as he deserves it.

bharath86 · ‎11-30-2020

@Kurt_Bremser @hhinohar Hi I have a query please advise. Data I have: ID Tx Flag 1 NA Unknown 1 yes Y 1 yes Y 2 NA Unknown 3 NA Unknown 3 yes Y 3 yes Y Data I Want: ID Tx Flag 1 yes Y 1 yes Y 2 NA Unknown 3 yes Y 3 yes Y I want to delete those records which has Tx as 'NA' and Flag as 'Unknown', however if there is only one record for any ID, I dont want to delete that record even if the condition satisfies. Ex: For ID 2 there is only one record but it satisfies my condition to delete but I dont want to delete ID 2 as there is only one record. Please advise. Thank you

bharath86 · ‎11-29-2020

@Kurt_Bremser Hi, Can you please help me with this output. Data I have: ID Tr_ID Category Low High 111 1 Age 3 4 111 2 Duration 3 3 111 3 Duration 2 2 222 1 Age 60 60 222 2 Duration 24 24 What I get: ID Tr_ID Category Low High Age_Low Age_High 111 1 Age 3 4 3 4 111 2 Duration 3 3 6 7 111 3 Duration 2 2 5 5 222 1 Age 60 60 60 60 222 2 Duration 24 24 84 84 What I need: ID Tr_ID Category Low High Age_Low Age_High 111 1 Age 3 4 3 4 111 2 Duration 3 3 6 7 111 3 Duration 2 2 8 9 222 1 Age 60 60 60 60 222 2 Duration 24 24 84 84 Code I use: data need; set have; if Category= 'Duration' then Age_Low=0; Age_Low=lag(low)+low; if Category= 'Duration' then Age_High=0; Age_High=lag(high)+High; if Category ='Age' then Age_Low= low; if Category ='Age' then Age_High= high; run; How many ever rows I might have with category as 'Duration' I should be able to take the previous row value and sum this with current row. But my code stops executing this logic after first occurrence. Please advise. Thank you

bharath86 · ‎11-20-2020

@Kurt_Bremser Thank you very much. This logic can actually be applied in either case if records < 24 or > 24 just by tweaking it a bit. Thank you again.

Online Status	Offline
Date Last Visited	‎10-03-2023 02:14 PM

Split a variable to multiple variables

Importing multiple csv files

Re: output XPT filenames in lowercase

output XPT filenames in lowercase

Re: Proc compare

Re: Proc compare

Proc compare

Re: Drop variables from comparison using a macro

Drop variables from comparison using a macro

Re: Character variable to character date variable

Re: output XPT filenames in lowercase

Re: Reading XLSX file and change the all column type into character

Re: Copy values to entire section

Re: Imputation technique

Re: How to remove level 2 bookmarks from this proc report

Re: Delete rows on a condition but dont delete if there is only one re...

pick correct value based on condition

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Re: Assign value from any row by ID

Assign value from any row by ID

Re: Delete rows on a condition but dont delete if there is only one re...

Re: Delete rows on a condition but dont delete if there is only one re...

Delete rows on a condition but dont delete if there is only one record

Need cumulative totals based on condition

Re: keep record closest to a value

CoDe SAS German