About rkolupoti9001

rkolupoti9001 · ‎02-24-2016

data new_age; set test; new_age =(INPUT(SCAN(Age, -1), 8.))-(INPUT(SCAN(Age, 1), 8.)); run;

rkolupoti9001 · ‎08-13-2015

Hi, I have a dataset with 3 columns state, city,& population which has 50 states with respective cities and populations. I want 50 different outputs with top 4 populated cities. Thanks in advance

rkolupoti9001 · ‎07-09-2015

Thanks Hai.Kuo Sure From next I will input data in ready format

rkolupoti9001 · ‎07-09-2015

Thanks Xia It Worked Perfectly

rkolupoti9001 · ‎07-08-2015

Hi Ballardw, Dates are currently in Character

rkolupoti9001 · ‎07-08-2015

Hi Need to calculate members for each month Have Mem_ID start_date end_date 123 201401 201412 234 201208 201501 345 201211 201403 456 201306 201412 567 201401 201406 Want Year_Month Count_of_members 201401 5 201402 5 201403 5 201404 4 201405 4 201406 4 201407 3 Thanks in advance

rkolupoti9001 · ‎07-01-2015

Have_Var Want_Var 123q987 ###$### 324s784 ###$### 386 ### 58881 ##### afgelk $$$$$$ Hi, I want to translate 0-9 character # and A-Z to $ Thanks in advance!!!!

rkolupoti9001 · ‎01-19-2015

Hi, Am having a dataset where am calculating the percentages and when am trying to export it to excel by proc export the format is not the same as it was in sas for calculation. Can anybody let me know how to keep the same format in excel ? calculation in sas have format in excel want format in excel 60% 0.60 60% Thanks in Advance!!!!

rkolupoti9001 · ‎01-15-2015

It worked Thank you!!!

rkolupoti9001 · ‎01-15-2015

Into same dataset

rkolupoti9001 · ‎01-15-2015

Hi, Am having a set files like master_1,master_2,master_3.........,master_n in access database.Can we import them all at a time something like master%. Thanks in advance!!!!

rkolupoti9001 · ‎01-09-2015

Thank You!!!

rkolupoti9001 · ‎01-09-2015

Hi when am doing Proc rank by selecting option ties=low if two members are having same rank lets say two members having rank 1 and I want next rank to be 2 not 3 Like Rank_Present_need Can we Do that Thanks in Advance Name Present Rank_Present_output Rank_Present_need Davis 77 3 2 Orlando 93 1 1 Roe 93 1 1 Sanders 68 4 3

rkolupoti9001 · ‎12-03-2014

Hi PG, Thanks for the reply and am having one more question!!! trust me this is the last one:smileylaugh: Am having dataset where members went to different movies i.e there are 100 members seen movie Frozen in 2013 and 100 in 2014, 100 members seen movie Avengers in 2013 and 100 in 2014 , 100 members seen movie Titanicin 2013 and 100 in 2014. Members can repeat across movies and across 2013, 2014 that means a member can go to all three movies in 2013 and in 2014 or he can go to only one movie in 2013 and two in 2014 and a member can have multiple rows for each movie. So now I need to flag 10% of distinct members for each movie, for each year but if member is selected in movie frozen 2013 he should not be selected again. Thanks!!!

rkolupoti9001 · ‎12-03-2014

Hi PG, Thanks for the reply!!! One more question Instead of extracting those random sampled members can we flag them ie, if the member is selected for random sample then mark it as "Y" else "N". Thanks!!!

Online Status	Offline
Date Last Visited	‎03-09-2016 04:04 PM

Re: SAS BASE- Range conversion

How to pick top 4 populated Cities

Re: Calculating members

Re: Calculating members

Re: Calculating members

Calculating members

Need to translate 0-9 to # and A-Z to $

Exporting to Excel with format

Re: can we import files with same names at once

Re: can we import files with same names at once

Re: Need to translate 0-9 to # and A-Z to $

Re: Condition for the logic

Re: Condition for the logic

Re: SAS BASE- Range conversion

How to pick top 4 populated Cities

Re: Calculating members

Re: Calculating members

Re: Calculating members

Calculating members

Need to translate 0-9 to # and A-Z to $

Exporting to Excel with format

Re: can we import files with same names at once

Re: can we import files with same names at once

can we import files with same names at once

Re: Question on proc rank

Question on proc rank

Re: Need to Pick Random samples of single coulmn from dataset

Re: Need to Pick Random samples of single coulmn from dataset