Thank you so much ... View more

thanks for reply ... View more

  Data generated using random number with Normal distribution (mean=5 std=2) as dataset D1 which has 100 elements. Data generated using random number with Normal distribution (mean=3 std=3) as dataset D2 which has 80 elements. Based on D1 and D2, data generated with Normal distribution at 30% Normal (mean=5, std=2)+70% Normal (mean=3, std=3) as D3 which has 120 elements How to estimate proprotion of D1 and D2 in dataset D3? If any idea please let me know. ... View more

Hi, thanks for reply,   I am trying this way    proc import datafile="C:\file path.txt"              dbms=dlm             out=new data             replace;      delimiter='|';      getnames=yes;  guessinrows=100;   run;   Its working.  ... View more

Yes my data is in txt file and its not arranged in order. Is there any solution to create dataset without putting '.' for missing values in raw data. Data values are not arranged in neatly defined columns, but are separated by at least one space and contain some nonstandard characters, such as the dollar sign ($) ... View more

I agree with these codes, but If I have huge data then How will I put '.' for the all missing values. This has more than thousand observation. Is there any way for this one? Thanks alot for reply ... View more

Below is the code I have used for data creation. But table giving values to different place.   Data KRM; Input acctno  actdt mmddyy10.  deactdt mmddyy10.  deactreason$  goodcredit  rateplan  dealertype$  AGE  Province$ sales; Datalines; 1176951913656 07/01/2000 0 1 A1 57 BC $593.00 1176954000288 05/30/2000 1 2 A1 47 ON $83.00 1176969186303 12/13/2000 1 1 C1 82 BC 1176991056273 08/31/1999 09/18/2000 MOVE 1 1 C1 92 QC $1041.00 1176991866552 05/24/2000 1 1 A1 77 ON 1176992889500 11/28/2000 1 1 C1 68 AB $72.00 1177000067271 12/23/1999 0 1 B1 75 ON $134.00 1177028996676 09/21/2000 0 1 C1 QC $179.00 1177057406016 09/21/2000 0 1 C1 50 ON $529.00 1177066422248 04/26/1999 01/15/2001 NEED 0 1 A2 55 NS $44.00 1177113886410 09/13/2000 01/08/2001 COMP 0 1 C1 45 ON $63.00 1177128264924 12/10/1999 1 1 B1 38 ON $178.00 ; run; ... View more

I have tried same method given by you, but data out showing values in different column. Forxample, for one row entries are in different then other row entry. I hope you have understand my question data have; input var1 var2 mmddyy10. var3 ...; /* addapt logic names to variables */ datalines; ... View more

how can I show the acctno is unique? what will be the code to see the number of accounts activated and deactivated? Also the earliest and latest activation/deactivation dates available.   Can anyone give me code. ... View more

    Data is   1176913194483 06/20/1999 0 1 A1 58 BC $128.00 1176914599423 10/04/1999 10/15/1999 NEED 1 1 A1 45 AB $72.00 1176951913656 07/01/2000 0 1 A1 57 BC $593.00 1176954000288 05/30/2000 1 2 A1 47 ON $83.00 1176969186303 12/13/2000 1 1 C1 82 BC 1176991056273 08/31/1999 09/18/2000 MOVE 1 1 C1 92 QC $1041.00 1176991866552 05/24/2000 1 1 A1 77 ON ... View more

thanks a lot, i will try this ... View more