About dishant

dishant · ‎04-29-2014

Hi Linush, Thanks For Giving Time To look my problem. Initially Tried with PROC COMAPRE But Didn't Achieve it. Could You Please Help Me..

dishant · ‎04-29-2014

Hi All, I have n number of variables in one dataset and same structure like in another dataset. Now I want to compare those two dataset with Respective variables and need to find position of the miss-matches. Below example data looks like original data. data test; Input name $ surname $; datalines; ramesh Babu Dishant parikh Disha.N Khanna ; Run; data test1; Input name1 $ Surname1 $; datalines; RamesH BABU DISHANT PARIKH disha Khanna ; Run; Now I need To Output like below. Name Name1 Char Surname Surname1 Char1 ramesh RamesH 1,6 Babu BABU 2,3,4 Dishant DISHANT 2,3,4,5,6,7 parikh PARIKH 1,2,3,4,5,6 Disha.N disha 1,6,7 Khanna Khanna So In Output Respective Variables Miss-Matches Position Need to be show As like Above.Your help will Mean to be lot. Thanks In advance. Regards, Dishant Parikh

dishant · ‎04-16-2014

Hi all, Ok One Small update Let us Consider Year Information Is Also Caputring Then How your Code Will Work And Urvish Your's As well...Can You Pls tell me..

dishant · ‎04-16-2014

Hi, Yeah I want include cust_id 204 in output.So can you Please Let me know What u-pdate needs to be Done..?

dishant · ‎04-16-2014

Hi Urvish, In You Code First Month For Resoective Customer_id Is not Dispalying.Can You Pls Confirm It.

dishant · ‎04-16-2014

Above Dataset name is Test ,Pls Make Update and Solve it.

dishant · ‎04-16-2014

Hi SK K, If Below The Case Then Specifiy Code Is Not Working.Can You pls Help It. Data cust_dim1; Input customer_id Month $ Month_num Product $ ; Datalines; 101 Jan 1 Cream 101 Dec 12 Powder 102 Feb 2 Cream 102 Mar 3 Paste 102 Apr 4 cloth 103 Sep 9 Cream 103 Jan 1 Paste 103 Nov 11 Cloth 104 Feb 2 Cream 104 Mar 3 Paste 104 May 5 Cloth 104 Apr 4 Brush 204 Dec 12 Paste 204 Jan 1 Cloth 204 Feb 2 Brush ; Run; Proc SQL ; Create Table WANT as select * from test where CUSTOMER_ID in Select Distinct Customer_id From (Select A.* From test as A Inner join test as B ON A.customer_id=B.customer_id Where A.month_num = B.Month_num+1 ) AS T Group By Customer_id Having Count(Coustmer_id) ge 2) order by customer_id,Month_num; Quit;

dishant · ‎04-16-2014

Hi SK K, I Would Say Big thank you to you..Its exactly maching Which Req Want. Your Solution Takes New Lavel of thinking.Thank a lot Onnce Again. Hi Urvish, I want Those Customer_id Which Had Visited Contious 3 months Not Total 3 months.Can you pls Note that Give Solution Like SK K Did and Give me In Data step. Thanks to all your help Meas A lot.And I Learn New thiongs From All Of You.

dishant · ‎04-16-2014

My requirment is who Visited CONTINOUS 3 or more months those customer_id with thier respective months should to come to output.

dishant · ‎04-16-2014

As Above mention output SQL is not giving.Can you pls help me on to Acheive Above output.

dishant · ‎04-16-2014

Hi, I must say well try.This Solution takes me another level of thinking. One little modification still required to achevie goal i.e. Output should to be each Customer_id with each Month With each product. If this will done itll achieve the goal. As per req ouput shuld to be shown below. Customer_id Month Month_num Product 102 Feb 2 Cream 102 Mar 3 Paste 102 Apr 4 Brush 104 Feb 2 Cream 104 Mar 3 Paste 104 Apr 4 Brush 104 May 5 Cloth Can you help on this last note.

dishant · ‎04-16-2014

Hi, Thanks for Your assistance and help. But as per requirment customer_id 103 shouldn't come because he didn't visited 3 months consicative. I want those customer_id who visited 3 or more times consicative (Eg. 102,104) with all moths in which he visited. your help will helpful me.Thanks In advance.

dishant · ‎04-16-2014

Hi, My data is like below. Data test; Input customer_id Month $ Month_num Product $ ; Datalines; 101 Jan 1 Cream 101 Dec 12 Powder 102 Feb 2 Cream 102 Mar 3 Paste 102 Apr 4 Brush 103 Sep 9 Cream 103 Jan 1 Paste 103 Nov 11 Cloth 104 Feb 2 Cream 104 Mar 3 Paste 104 May 5 Cloth 104 Apr 4 Brush ; Run; Now on Upon data I want those customer_id who had visited Consitative 3 or more times. Your help will mean a lot. Thanks In Advance. regards, Dishant Parikh.

dishant · ‎02-17-2014

Hi Tarunkumar, Thanks and Appreciate For your help and time. This Takes me a new level of Thinking .

dishant · ‎02-17-2014

Hi, I Have data like this, data t2; input subjid rowno tmpoint & $25.; datalines; 101 1 4 hr 101 2 8 hr 101 3 12 hr 101 4 16 hr 102 1 4 hr 102 3 12 hr 102 4 16 hr 102 2 8 hr run; Now In Upper data I want output those observations which are not sorted.How?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: How to stop the saving my code

How to stop the saving my code

Re: How to find fancy number from the variable

Re: How to find fancy number from the variable

Re: How to find fancy number from the variable

How to find fancy number from the variable

Re: How to control the editior window

Re: How to control the editior window

How to control the editior window

How to avoid the conversion Note

How to output those customers who visited continous 3 times

Re: How to filter dates between two specific dates in SAS?

Re: How to get position Of Miss mattch

How to get position Of Miss mattch

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

Re: How to output those customers who visited continous 3 times

How to output those customers who visited continous 3 times

Re: How to Output Unsorted data

Re: How to Output Unsorted data