About AKHILA

AKHILA · ‎09-01-2023

Please try: Age_final=max(age1,age2,age3,age4,age5)

AKHILA · ‎08-11-2021

Hope this will helps: proc sort data=a; by var1; run; data want; set a; by var1; retain ord; if first.var1 then ord+1; run;

AKHILA · ‎09-25-2020

Thank you so much!!

AKHILA · ‎09-25-2020

Hi all, I have a dataset as: Id.no Number Flag 101 543 0 101 657 0 101 723 1 101 123 0 101 432 0 102 564 0 102 634 1 102 327 0 103 765 0 103 567 0 103 908 0 103 432 1 103 231 0 Can I get the observations upto the first occurrence of flag variable as '1' for each id no? I mean the output dataset as: Id.no Number Flag 101 543 0 101 657 0 101 723 1 102 564 0 102 634 1 103 765 0 103 567 0 103 908 0 103 432 1 Please help me out for this . Thank you

AKHILA · ‎06-16-2020

any order is fine

AKHILA · ‎06-16-2020

Thanks for the suggestion. but in future if i add more programs how can i dynamically add those without entering in %include statement. Can you please suggest some macros?

AKHILA · ‎06-16-2020

I mean simply to run all 5 pgms parellel or one after other to get the 5 outputs.

AKHILA · ‎06-16-2020

Hi all, I have some 5 programs ,say for eg: pgm1.sas, pgm2.sas, pgm3.sas. etc which i am saving in the same location. let it be D:\Path. Is there any way to use a single %include statement to run all this programs at once? Please help me for this.

AKHILA · ‎11-11-2019

Hi all , i have a dataset with two variables. i want to merge two columns into a single one such that the second column will be subgroup for the first. color$ flower$; yellow red red rose yellow white jasmine white lilly red white i want my final dataset to look like this ; yellow red rose white jasmine lilly please help...

AKHILA · ‎05-28-2019

in the following dataset i want to derive a new variable 'TYPE' in which the max and min of val2 within id for each val1 should be populated like ID VAL1 VAL2 001 HT 170 001 HT 170 001 HT 170 001 WT 56 001 WT 78 001 WT 91 001 TM 32 001 TM 31 001 TM 27 001 BP 120 001 BP 111 001 BP 178 002 HT 169 002 HT 169 002 HT 169 002 WT 34 002 WT 89 002 WT 90 if the val2 is constant for any val2(here HT) I have to keep only one record for that .the output should be like; ID VAL1 VAL2 TYPE 001 HT 170 001 WT 56 min 001 WT 78 001 WT 91 max 001 TM 32 max 001 TM 31 001 TM 27 min 001 BP 120 001 BP 111 min 001 BP 178 max 002 HT 169 002 WT 34 min 002 WT 89 002 WT 90 max please help.

AKHILA · ‎05-20-2019

thank u 🙂

AKHILA · ‎05-20-2019

hi, I am not getting proper output. I want 3 flags for each id because there are 3 param values(A,B,C) as per the dataset.

AKHILA · ‎05-20-2019

I have a dataset like this Id param vaL date1 date2 101 A 2.4 02jan2019 05jan2019 101 A 4 05jan2019 05jan2019 101 A 5 10jan2019 05jan2019 101 B 1 03MAY2018 0APR2019 101 B 8 04AUG2017 05SEP2017 101 C 2 06FEB2016 01JAN2016 101 C 5 08MAR2014 08AUG2018 101 C 9 07APR2017 09MAR2018 102 A 10 09SEP2016 09DEC2015 102 A 4 05jan2019 15jan2019 .......................................SO ON..... I want to derive a flag variable , as per the conditions; The flag should be populated for each param within each id;(only once as the conditions are satisfied for the firsttime) Also date1 < date2 like d param vaL date1 date2 FLAG 101 A 2.4 02jan2019 05jan2019 Y 101 A 4 05jan2019 05jan2019 101 A 5 10jan2019 05jan2019 101 B 1 03MAY2018 0APR2019 101 B 8 04AUG2017 05SEP2017 Y 101 C 2 06FEB2016 01JAN2017 101 C 5 08MAR2014 08AUG2018 Y 101 C 9 07APR2017 09MAR2018 102 A 10 09SEP2016 09DEC2015 102 A 4 05jan2019 15jan2019 Y .......................................SO ON.....

AKHILA · ‎05-13-2019

Hi all, In the dataset below; visit var1 count 1 1 a1 1 2 a2 1 3 a3 1 000 no 2 1 b1 2 2 b2 2 000 no 2 000 no if the count value is 'no' then var1 should be mapped to the previous var1 value.if the same visit value then the var1 should follow an order like, visit var1 count 1 1 a1 1 2 a2 1 3 a3 1 3.1 no 2 1 b1 2 2 b2 2 2.1 no 2 2.2 no....etc.

AKHILA · ‎05-08-2019

thank you somuch. it works

Online Status	Offline
Date Last Visited	‎09-01-2023 08:27 AM

Re: How to create a new column based on the highest value from multipl...

Re: categorize a variable

Re: choosing observations based on first occurence of a varaiable

choosing observations based on first occurence of a varaiable

Re: To run multiple programs by a single code

Re: To run multiple programs by a single code

Re: To run multiple programs by a single code

To run multiple programs by a single code

To merge two columns under a single name

find min and min within two unique values

Re: choosing observations based on first occurence of a varaiable

Re: To merge two columns under a single name

Re: Transposing proc freq

Re: retain a value for common id

Re: How to create a new column based on the highest value from multipl...

Re: best format

Re: best format

Re: categorize a variable

Re: How to create a new column based on the highest value from multipl...

Re: categorize a variable

Re: choosing observations based on first occurence of a varaiable

choosing observations based on first occurence of a varaiable

Re: To run multiple programs by a single code

Re: To run multiple programs by a single code

Re: To run multiple programs by a single code

To run multiple programs by a single code

To merge two columns under a single name

find min and min within two unique values

Re: to flag a variable.

Re: to flag a variable.

to flag a variable.

to derive a value based on the previous value

Re: Transpose data