About allurai0412

allurai0412 · ‎02-02-2013

thanks...

allurai0412 · ‎02-02-2013

Hi keith, I am getting error.... will you please look in to the issue... Regards ALLU 448 data school; 449 input Age format z5. Quiz : $1. Midterm Final; --- 48 ERROR 48-59: The informat Z was not found or could not be loaded. 450 451 id2= '000'||strip(age); 452 if age=12 then grade=6; 453 else if age=13 then grade=8; 454 datalines;

allurai0412 · ‎02-02-2013

thanks VD.. it is working...just i added another like id2= '0000'||strip(id); regards.. ALLU

allurai0412 · ‎02-01-2013

hi i find some short cut in excel only... But it will give FOUR zeros for before the number... Please find the screen shot... Regards ALLU

allurai0412 · ‎02-01-2013

Thanks a lot...

allurai0412 · ‎02-01-2013

hi, I am providing a sample of dataset that I am working with... I want threee zeros to be added to "id" in the ouput dataset; DATA HAVE; INFILE DATALINES; INPUT ID NAME : $ AMOUNT; DATALINES; 1 ALIERN 4500 2 VEREKR 20000 3 RERRRR 100000 ; RUN; ****************************** REQUIED OUTPUT; 00001 ALIERN 4500 00002 VEREKR 20000 00003 RERRRR 100000 Regards ALLU

allurai0412 · ‎01-24-2013

hi , I have some fileds(included only frist row) in the excel format. I would like to have in text (text output2) file (required format) ..... I am unable to change it to txt format (text output2) , as it is confusing me in spaces an zeros. Please find my import file (excel input) (WITH variables position in text file) outputtextfile(text output2) please help.. Regards ALLU

allurai0412 · ‎01-17-2013

please help.... at least in SQL...!!

allurai0412 · ‎01-16-2013

hi , i have some query how to generate the required output in PROC REPORT please help... data have1; infile datalines; input trdatedate9. trtype$ BROKER$8. FOLIONO tramount datalines; 24/02/2008 SWITCH ARN-0010 4278998 5000.00 01/01/2008 PURCHASE ARN-0022 4897722 7875.56 01/03/2009 PURCHASE ARN-0010 4222111 4500.00 02/04/2009 PURCHASE 000-000 4555689 7899.00 12/04/2007 SWITCH ARN-0012 4121212 4555.00 12/04/2007 SWITCH 0000-0000 4787878 45651.00 01/08/2011 PURCHASE ARN-23587 4787872 12780.00 25/01/2012 SWITCH ARN-0018 4878123 10000.00 24/10/2010 PURCHASE ARN-0025 4666667 7800000.00 ; RUN; ************************************************************************************output required************************* I NEED THE OUTPUT THRU PROC REPORT LIKE FOLLWING FOLIONO EXITLOAD 4278998 .... 4897722 ... 4222111 ... 4555689 NIL 4121212 ... 4787878 NIL 4787872 ... 4878123 ... 4666667 ... CONDITIONS TO BE MATCHED : * customers with BROKER CODE ....000-000 at any trdate , they will have "NO LOAD" * THOSE WHO HAS GOT IN TO THE FUND..... 3 YEARS AGO WILL have " NO LOAD" i.e earlier 16/01/2010 * Those who has got in to the fund after 17/01/2010 will have exit load "2%" of tramount. reagards ALLU

allurai0412 · ‎01-16-2013

hi sam, thanks for your reply.. the second condition....we need the customer of highest amount to the total corpus .... i.e invname corpus %of total faisal 20000 ramesh 1,000,000 AMIN 250,000 . . . like this i need % of each individual to the total corpus. ............and who has gone beyond 20% regards ALLU

allurai0412 · ‎01-15-2013

hi what's the logic behind the sub code day(somedate) < day(birth)))? please explain thanks ALLU

allurai0412 · ‎01-15-2013

hi, i am providing you sample data , where i need to check 1)PAN no should and must be 10 digits .(first 5 places should and must be CHARACETERS) 2)I need to identify the customer who has more than 20% of available corpus data have1; infile datalines; input trdatedate9. invname$ corpus trtype$ PANNO$ datalines; 14/1/2013 FAISAL 20,000.00 SWITCH AJYPA***** 14/1/2013 RAMESH 1,000,000.00 PURCHASE ALOPP***** 11/1/2013 AMIN 250,000.00 PURCHASE ***PA4084F 11/1/2013 A AMIN 200,000.00 PURCHASE A********* 15/1/2013 MOHAN 200,000.00 PURCHASE ACB******* 11/1/2013 RAHUL 100,000.00 PURCHASE ***PD9407B 10/1/2013 BHAT 15,000.00 PURCHASE AXQ******* 14/1/2013 SHIRISH 2,500,000.00 PURCHASE AAGPR9**** 14/1/2013 CHATURBHUJ120,000.00 PURCHASE ***PD0807F 11/1/2013 KUMAR 95,000.00 PURCHASE ABTPG3**** 11/1/2013 G. KUMAR 110,000.00 SWITCH ADTPM5692E 14/1/2013 SHASHI 175,000.00 SWITCH ADC******** ; RUN; please help...

allurai0412 · ‎01-14-2013

hi, I am providing a sample data . 1)I need the investor who attained the minor to major on 14/01/2012 ( i .e greater than equal to 18 years) 2)I should pick up the entire address from another database (have2) with the INVNAME? data have1; input name$ dob DATE10.; cards; SHARMA 10/10/2010 TRISHA A 30/11/1992 TRISHA 30/11/1999 SANGHVI 30/05/2000 SANGHVI 26/03/1991 ; run; data have2; input INVNAME $8. STATE$ ACNO$; cards; SHARMA UTTAR PRADESH 813120***** TRISHA GUJARAT 819173***** TRISHA A GUJARAT 826162***** SANGHVI GUJARAT 826293***** SANGHVI GUJARAT 826313***** ; run;

allurai0412 · ‎12-27-2012

thanks richard good work... is there any way to do in PROC SQL...?

allurai0412 · ‎12-26-2012

hi , i am working with large data base , but i am providing the sample one. DATA TAXSAVERS; INPUT AMOUNT LOAD; DATALINES; 2779 50 16050 50 18000 45 17000 65 2566 20 ; RUN; I need the REQUITED DATABASE as follows 1) The first step is "load should be deducted " i.e 2779-50=2729 2) The gross or final TAXSAVER amount should be multiple of 500...i.e 2729 ...would be 2500. shall i use the MOD function for the second step. please help ....is there any PROC in SAS ...if not go ahead with PROC SQL...

Online Status	Offline
Date Last Visited	‎04-21-2016 11:24 AM

Re: How to create cumulative sums

Re: Delimiter for Tab in SAS.

Re: multiple sheets in excel

Re: Splitting up accounts on a weekly basis

Re: Splitting up accounts on a weekly basis

Re: Splitting up accounts on a weekly basis

Re: Why doesn't the book's macro to separate data work?

Re: search long hyphen (−) in the program

Re: function ...contain()

function ...contain()

Re: SAS datatime variables

Re: SAS datatime variables

Re: concatenating all observations in single

Re: concatenating all observations in single

Re: search long hyphen (−) in the program

Re: Delimiter for Tab in SAS.

Re: diff b/n value and invalue in Proc Format

Re: PROC REPORT multi avg

Re: multiple sheets in excel

Re: search long hyphen (−) in the program

Re: Adding zeros for the number...

Re: Adding zeros for the number...

Re: Adding zeros for the number...

Re: Excel converts string to numeric

Re: caculating 'exit load' based on dates !!!

Adding zeros for the number...

importing excel and output as text ??/

Re: caculating 'exit load' based on dates !!!

caculating 'exit load' based on dates !!!

Re: identifying maximum investment among ??

Re: obtaining minor to major using date diffs?

identifying maximum investment among ??

obtaining minor to major using date diffs?

Re: How to required output (multiple of 500)?

How to required output (multiple of 500)?