About TarunKumar

TarunKumar · ‎06-12-2017

DATA WORK.ANALYSIS1; SET ANALYSIS1 (KEEP = ID ZONE AGE GENDER); RUN;

TarunKumar · ‎06-12-2017

DATA work.sample; INPUT ID Year Industry; DATALINES; 004605 1972 . 004605 1973 . 004605 1974 6798 004610 1984 6799 004610 1985 . ; RUN; PROC SORT DATA=SAMPLE ;BY ID Industry ;RUN; DATA SAMPLE_1; SET SAMPLE; BY ID ; IF LAST.ID THEN OUTPUT; RUN; PROC SQL; CREATE TABLE WANT AS SELECT A.*,B.Industry AS Industry_NEW FROM SAMPLE AS A LEFT JOIN SAMPLE_1 AS B ON A.ID = B.ID; QUIT;

TarunKumar · ‎04-04-2017

Hi, i have sas data set with the field Account number , ac_opn_date, and month on month balances . i want to create new dataset with Month one (m1) balances against the account number on the basis of account open date . for eg , for account number 1 account open date is Mar 16 then month balance is Apr_16 and for acccount nmer 2 account open date is Apr 2016 then month one balance is May_16, data is huge and i dont want to use if then else contition Account_no Ac_opn_date Mar_16 Apr_16 May_16 jun_16 jul_16 aug_16 Sep_16 Oct_16 Nov_16 Dec_16 1 01-Mar-16 1000 900 2000 1500 3000 6000 6000 5000 5000 5000 2 10-Apr-16 0 2000 5000 4000 5000 4000 4000 3000 3000 3000 3 15-May-16 0 0 6000 70000 8000 5000 5000 5000 5000 5000 4 16-Jun-16 0 0 0 8000 9000 6000 6000 6000 6000 6000 5 17-Jul-16 0 0 0 0 10000 4000 4000 4000 4000 4000 6 18-Aug-16 0 0 0 0 0 3000 3000 30050 30050 30000 7 20-Sep-16 0 0 0 0 0 0 6000 6055 6055 6000 8 16-Oct-16 0 0 0 0 0 0 0 10000 10000 9000 9 25-Nov-16 0 0 0 0 0 0 0 0 9500 9000 required data set is : Account_no M1_AVG 1 900 2 5000 3 70000 4 9000 5 4000 6 3000 7 6055 8 10000 9 9000

TarunKumar · ‎06-09-2016

Dear Team, I have two data set . table Achivement location fee per casa per 1 50-75% 150-200% 2 150-200% 100-150% 3 >=200% 150-200% Second table Payout Grid CASA 75-100% 100-150% 150-200% >=200% fee 50-75% 0 0 3500 5250 75-100% 3000 3500 4500 7250 100-150% 3500 4500 5250 8000 150-200% 4500 5250 7250 8500 >=200% 5250 7250 8000 12500 Out put required location fee per casa per payout 1 50-75% 150-200% 3500 2 150-200% 100-150% 5250 3 >=200% 150-200% 8000

TarunKumar · ‎03-19-2016

Dear Team , Any an idea how we can import sasdata set in ms access. by import wizard i am able to do the import & export. but i want to done by sas coding. Regards Tarun Kumar

TarunKumar · ‎01-27-2016

Below error while using the code Error: Connect: Class not registered Error: Error in the Libname statement with the import wizard --------------------------- OLEDB Connection Problem --------------------------- A problem was encountered while attempting to use OLEDB to read data from the source file. This may be caused due to the source file being opened within another application or a security issue while attempting to access the source file. Because of this problem the Import Data wizard is unable to continue. --------------------------- OK ---------------------------

TarunKumar · ‎01-27-2016

Hi problem in importin ms access table in has SAS EG 7. O/S Windiows XP 64 Bit Office 2010 32 bit SAS EG - 7 64 BIT Thanx Tarun Kumar

TarunKumar · ‎06-25-2015

Hi Guys, I have data of our sales team in sas data set. emp_code name dept li_revenue mf_revenue gi_revenue Total_Revenue email_id 1 a SALES 5000 0 200 5200 ABC@MAIL.COM 2 b SALES 1000 0 3000 4000 BC@MAIL.COM 3 c SALES 2000 2500 4000 8500 AS@MAIL.COM 4 b SALES 3000 3600 5000 11600 GB@MAIL.COM 5 e SALES 400 500 6000 6900 DB@MAIL.COM Want to create Detail report and want same is email as Attachment or Mail Body . emp code 1 Subject :- Issued Revenue Dear a, Revenue done in the month of Jun15. Li Revenue --5000/- MF Revenue -- 0/ Gi Rebvenue -- 200/ Total Revenue -- 5200/- Regard XYZ Bank Corporate Office

TarunKumar · ‎01-07-2015

data test; my_name = 'Tarun Kumar'; length my_name_new$20.; do i = 1 to length(my_name); substr(my_name_new,i,1) = substr(my_name,length(my_name)+1-i,1); end; put (my_name my_name_new) (=); run;

TarunKumar · ‎01-07-2015

Not sure but try this ==> OPTION COMPRESS = YES RESUE=YES; LIBNAME NEDGLOR ODBC DATASRC=NEDGLOR SCHEMA=DBO; OPTION COMPRESS = YES RESUE=YES; PROC SQL; CREATE TABLE SASUSER.TBL_WF_ST_ACT_USER AS SELECT PRO_ID, CREATE_DATE, ACT_DEF_NAME, APP_STATUS_CODE, COMPLETE_DATE, CUSTOM_COLUMN1 FROM NEDGLOR.TBL_WF_ST_ACT_USER ; QUIT; PROC SORT DATA=TBL_WF_ST_ACT_USER; BY PRO_ID DESCENDING CREATE DATE DESCENDING ACT_DEF_NAME; RUN;

TarunKumar · ‎01-07-2015

x = intck("month",'01JAN14'd,'01OCT14'd);

TarunKumar · ‎12-30-2014

The Little SAS Book By Lora D.Delwiche and Susan J. Slaughter is very usefull .

TarunKumar · ‎12-30-2014

pls share the sample data

TarunKumar · ‎05-07-2014

%let drug = 'CARBOPLATIN ABARELIX ABS ABIRATERONE AFINTONIB ALDESLEUKIN'; data x; y= indexw(&drug,"ABARELIX") ; run;

TarunKumar · ‎04-17-2014

data sortedbase2; set sortedbase; length countrycode $2; if substr(compress(upcase(ISIN)),1,2) in ('HK','CN'); countrycode = substr(compress(upcase(ISIN)),1,2); run;

Online Status	Offline
Date Last Visited	‎10-17-2023 01:11 PM

Re: How to remove extra blank spaces after the text

How to sent Bulk Mail with Attached data to Multiple User

Re: calculating previous dates

Re: Update the exisiting height value if next value is 0

Re: Need Correction on finding the first name

Re: How to select 3 months with different transaction...

Re: How to select 3 months with different transactin amount

Re: delete all the Geography from rows having zero sum Value

Re: Adding characters to a string

Re: Creating a combined value of variables

Re: generating excel files using DDE

Re: Do's and loops

Re: Unmerging Excel cells in SAS

Re: SUM statement

Re: A layman question on data _null_ ?

Re: Need Correction on finding the first name

Re: Months Between two dates

Re: delete all the Geography from rows having zero sum Value

Re: Uanable to run the code with KEEP in SAS 9.4

Re: Delimiter for Tab in SAS.

Re: Uanable to run the code with KEEP in SAS 9.4

Re: Replacing missing values with closest non-missing observation with...

WANT TO FIND OUT M1 Balances

How to merge two datasets and select value from a transposed set of da...

import and export im ms access on windows os

Re: ERRO IN IMPORT MS ACCESS TABLE IN SAS EG

ERRO IN IMPORT MS ACCESS TABLE IN SAS EG

Want to create detail Report

Re: how to reverse a string with out using reverse function

Re: Proc Sort causing my temporary file burst my storage

Re: Months Between two dates

Re: Hi Guys, I would like to know if there is any book for practicing ...

Re: Import data files from a local windows machine

Re: Using the let statement to call later in a macro

Re: want to keep observations if variable x equals to something

SAS Analytics Explorers