About tlnarayana26

tlnarayana26 · ‎05-24-2019

Thanks, ballardw

tlnarayana26 · ‎05-21-2019

Hi to all, Sas code /*STRATA METHOD */ PROC SORT DATA=PROD_DATA OUT=PROD_DATA_SORT; BY PROD_FLAG; RUN; PROC SURVEYSELECT DATA=PROD_DATA_SORT OUT=STRATA_SPLIT SAMPRATE=.7 SEED=34258 OUTALL; STRATA PROD_FLAG; RUN; DATA TRAINING VALIDATION; SET STRATA_SPLIT; IF SELECTED = 1 THEN OUTPUT TRAINING; ELSE OUTPUT VALIDATION; RUN; I have one data set it contains 100 observations. Spiting data into 70% and 30% using PROC SURVEYSELECT method with Strata statement. Then data is split into 70 and 30 . But i have two problems 1.Run same code into another system/ laptop. the data split is 70 and 30. But In both of 70 agents are differed. How to get same agents on all laptops? 2.Adding some variables to data set and spit is 70 and 30 But In both of 70 agents are differed. How to get same agents on all laptops? please give your valuable suggestions Thanks, Lakshminrayana.

tlnarayana26 · ‎05-02-2018

Hi Here you we assigned X=0 and index=1 it increments 1 ,3 ,5 and 7 . In index=5 condition is true then X is 5 and again do loop by 2 value is added (index=7) and condition is falls so X=5 and index=7

tlnarayana26 · ‎11-14-2017

Thanks

tlnarayana26 · ‎11-13-2017

I have two tables TAB1 and TAB2, Both have two common variables followed by other different variables. so what i need here is When we join both the tables i need all the records from both the tables. But the condition here is if both the table have common variables it has to merge the data else no. Tab1 : Date Member Code Amount 4/1/2017 50000 ABC 5 4/1/2017 50000 DEF 7 4/1/2017 50000 XYZ 4 3/1/2017 PQR 6 3/1/2017 6000 EFX 3/1/2017 70000 VXB 5 3/1/2017 70000 IDJ 9 Tab2 Date Member Age Name 4/1/2017 50000 43 JAMES SCHMIDT 4/1/2017 50000 54 JACK BALDWIN 4/1/2017 50000 32 DAVID OPACK 4/1/2017 50000 23 HEATHER MARKS 4/1/2017 50000 49 DANIEL LUNSTAD 3/1/2017 70000 JACK BALDWIN 3/1/2017 70000 46 JAMES SCHMIDT 3/1/2017 5222 75 DANIEL LUNSTAD Required output; Date Member Code Amount Age Name 3/1/2017 PQR 6 3/1/2017 5222 75 DANIEL LUNSTAD 3/1/2017 6000 EFX 3/1/2017 70000 VXB 5 JACK BALDWIN 3/1/2017 70000 IDJ 9 46 JAMES SCHMIDT 4/1/2017 50000 ABC 5 43 JAMES SCHMIDT 4/1/2017 50000 DEF 7 54 JACK BALDWIN 4/1/2017 50000 XYZ 4 32 DAVID OPACK 4/1/2017 50000 23 HEATHER MARKS 4/1/2017 50000 49 DANIEL LUNSTAD Thanks and regards, Tlnarayana.

tlnarayana26 · ‎07-04-2017

Thanks Ksharp, It is help ful.

tlnarayana26 · ‎06-29-2017

Hi every one. I have data like this Agent ID A B C D E F G H I J 001 1 1 1 0 1 0 1 1 0 0 002 0 0 1 1 1 0 1 0 0 1 003 1 1 1 0 0 0 1 1 0 0 004 0 0 1 1 1 1 0 0 0 0 005 0 1 1 1 0 1 1 1 1 0 006 0 1 1 0 1 1 1 1 0 1 007 0 1 0 1 1 0 0 1 1 0 008 0 0 1 1 0 0 1 1 1 0 009 0 1 1 0 1 1 1 0 0 0 010 1 0 0 1 0 1 0 1 1 0 011 1 0 0 0 1 0 0 0 0 1 012 1 1 0 1 1 1 1 1 0 1 013 1 1 0 1 0 1 0 0 1 1 014 1 1 1 1 1 1 0 0 0 0 015 0 0 1 0 1 1 0 1 0 0 016 1 0 1 0 1 0 0 0 1 0 017 0 0 1 1 1 1 1 1 0 1 018 0 0 0 0 0 0 0 0 0 1 019 0 0 1 0 0 1 0 0 0 1 020 0 1 0 0 0 1 0 1 1 1 Please suggest me which Cluster method is suitable for above data & How to validate that method, Thanks in Advance.

tlnarayana26 · ‎01-25-2016

Hi, One and all, I have the one dataset one variable id. its contains some observations. data like this data ds1; input id @@; datalines; 8 15 20 26 31 36 44 47 54 59 65 68 74 79 85 90 95 100 ; run; 50 and 75 are fixed values. Form above dataset pick the nearst values. 1.74 is neartst value for id variable ( 75). 2.47 is nearst value for id variable (50). note: the id variable values b/w 5 to 100. plz help above problem.

tlnarayana26 · ‎06-22-2015

Thanks for all your Great help. Hi reeza sir above link gives list words. how can move to next step. plz help.

tlnarayana26 · ‎06-18-2015

Hi Every one i have data set word count lakshmi 10 ads 6 market 5 the 4 to 2 laks 2 is 2 what 2 and 1 help 1 book 1 How to eliminate articles,prepositions and pronous from above data set with out the word. using base sas plz help me.

tlnarayana26 · ‎06-08-2015

just creating a new project

tlnarayana26 · ‎06-02-2015

Hi. i am using version locally.

tlnarayana26 · ‎06-01-2015

Hi Every one, I am creating a new project in sas Enterprise Miner 7.1 . The project is not created because the flowing error occurred. Error is This server location is already registered for use, either by another project, or by another SAS application. Or user does not have permission to create project at this location. Try using a different name for your project, or enter a different path. how to solve the problem . plz help me. Thanks T.Lakshminarayana

tlnarayana26 · ‎03-24-2015

code is working sir. thank you

tlnarayana26 · ‎03-24-2015

Hi friends, I have the problem. and I have the sas data set like this emp_details value sal 5,25,369 HRA 10.2% PF 5% TAX 1% LIC 10% OTHER_INCOME 60,500 OTHER_SAVES . TA 0 HERE emp_details AND value BOTH ARE CHARACTER DATA TYPE ., I WANT CONVERTING value VARIABLE CHARACTER TO NUMERIC. AND ALSO GET THE SAME FORMATS emp_details value sal 5,25,369 HRA 10.2% PF 5% TAX 1% LIC 10% OTHER_INCOME 60,500 OTHER_SAVES . TA 0 HERE VALUE IS THE NUMERIC DATA TYPE PLZ HELP ME

Online Status	Offline
Date Last Visited	‎05-24-2019 02:46 AM

Re: Proc Survey Select - Stratified Random Sampling

Proc Survey Select - Stratified Random Sampling

Re: SAS

Re: I was trying to merge data only where exists in both datasets.

I was trying to merge data only where exists in both datasets.

Re: Cluster Analysis:

Cluster Analysis:

How pick the (50,75) nearest value b/w the observations

Re: How to eliminate articles,prepositions and pronous from data

How to eliminate articles,prepositions and pronous from data

Re: Why a do loop index is great than a counter within do loop