Date: Fri, 28 Jun 1996 19:26:22 +0000
Reply-To: blee@VAX2.CONCORDIA.CA
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Brian Lee <blee@VAX2.CONCORDIA.CA>
I have a puzzle. A variable, rdate, is included in out2, using the formate
of Julian5. When out2 is read into the other data, the variable, rdate shows
different dates. For example, from the sas.log file below, the rdate of the
first obs is 95012. When out2 is called, the rdate of the first obs is
changed to 20050. I would want to know how the same variable has
inconsistent values in the same program.
I am using vax/vms. I am enclosing a part of my sas.log for your suggestions.
Thanks in advance.
42 proc sort data=out2;
43 by itick;
NOTE: The data set WORK.OUT2 has 8893 observations and 17 variables.
44 data out2;
45 set out2 (obs=20);
46 put itick= '1' rdate=;
ITICK=AA 1RDATE=95012
ITICK=AA 1RDATE=96010
ITICK=AADV 1RDATE=94308
ITICK=AADV 1RDATE=95307
ITICK=AAL1 1RDATE=91042
ITICK=AAL1 1RDATE=93042
ITICK=AAL1 1RDATE=94056
ITICK=AAM 1RDATE=92219
ITICK=AAM 1RDATE=93217
ITICK=AAM 1RDATE=94214
ITICK=AAM 1RDATE=95214
13 The SAS System 19:01 Friday, June 28, 1996
ITICK=AAPL 1RDATE=90291
ITICK=AAPL 1RDATE=91294
ITICK=AAPL 1RDATE=92290
ITICK=AAPL 1RDATE=93288
ITICK=AAPL 1RDATE=94290
ITICK=AAPL 1RDATE=95292
ITICK=AB 1RDATE=91030
ITICK=AB 1RDATE=92030
ITICK=AB 1RDATE=93028
NOTE: The data set WORK.OUT2 has 20 observations and 17 variables.
47 data out2;
48 format date1 mmddyy8.;
49 format week3fr mmddyy8.;
50 format rdate julian5.;
51 set out2 (obs=20);
52 put itick= '2' rdate=;
53 mon=month(rdate);
54 yr=mod(year(rdate),100);
55 date1=mdy(mon,1,yr);
56 week3fr=intnx('week',date1,2)+5;
57 if rdate ge week3fr then indx1=yr*100+mon;
58 else do;
59 if mon=1
60 then indx1=(yr-1)*100+12;
61 else indx1=yr*100+mon-1;
62 end;
63 put itick= '3' rdate= rdate julian5. mon= yr= date1=
week3fr= ;
64
65 /*
66 data out2;
67 merge out2(in=x) out1(in=y);
68 by itick;
69 if indx1 eq sdate;
70 if x and y;
71 */
ITICK=AA 2RDATE=20050
ITICK=AA 3RDATE=20050 20050MON=2 YR=20 DATE1=02/01/20 WEEK3FR=02/20/20
ITICK=AA 2RDATE=22317
ITICK=AA 3RDATE=22317 22317MON=11 YR=22 DATE1=11/01/22 WEEK3FR=11/17/22
ITICK=AADV 2RDATE=18076
ITICK=AADV 3RDATE=18076 18076MON=3 YR=18 DATE1=03/01/18 WEEK3FR=03/15/18
ITICK=AADV 2RDATE=20345
ITICK=AADV 3RDATE=20345 20345MON=12 YR=20 DATE1=12/01/20
WEEK3FR=12/17/20
ITICK=AAL1 2RDATE=09097
ITICK=AAL1 3RDATE=09097 09097MON=4 YR=9 DATE1=04/01/09 WEEK3FR=04/16/09
ITICK=AAL1 2RDATE=14271
ITICK=AAL1 3RDATE=14271 14271MON=9 YR=14 DATE1=09/01/14 WEEK3FR=09/18/14
ITICK=AAL1 2RDATE=17189
ITICK=AAL1 3RDATE=17189 17189MON=7 YR=17 DATE1=07/01/17 WEEK3FR=07/20/17
ITICK=AAM 2RDATE=12179
ITICK=AAM 3RDATE=12179 12179MON=6 YR=12 DATE1=06/01/12 WEEK3FR=06/14/12
ITICK=AAM 2RDATE=15081
ITICK=AAM 3RDATE=15081 15081MON=3 YR=15 DATE1=03/01/15 WEEK3FR=03/19/15
ITICK=AAM 2RDATE=17347
14 The SAS System 19:01 Friday, June 28, 1996
ITICK=AAM 3RDATE=17347 17347MON=12 YR=17 DATE1=12/01/17 WEEK3FR=12/14/17
ITICK=AAM 2RDATE=20252
ITICK=AAM 3RDATE=20252 20252MON=9 YR=20 DATE1=09/01/20 WEEK3FR=09/17/20
ITICK=AAPL 2RDATE=07077
ITICK=AAPL 3RDATE=07077 07077MON=3 YR=7 DATE1=03/01/07 WEEK3FR=03/15/07
ITICK=AAPL 2RDATE=09349
ITICK=AAPL 3RDATE=09349 09349MON=12 YR=9 DATE1=12/01/09 WEEK3FR=12/17/09
ITICK=AAPL 2RDATE=12250
ITICK=AAPL 3RDATE=12250 12250MON=9 YR=12 DATE1=09/01/12 WEEK3FR=09/20/12
ITICK=AAPL 2RDATE=15152
ITICK=AAPL 3RDATE=15152 15152MON=6 YR=15 DATE1=06/01/15 WEEK3FR=06/18/15
ITICK=AAPL 2RDATE=18058
ITICK=AAPL 3RDATE=18058 18058MON=2 YR=18 DATE1=02/01/18 WEEK3FR=02/15/18
ITICK=AAPL 2RDATE=20330
ITICK=AAPL 3RDATE=20330 20330MON=11 YR=20 DATE1=11/01/20
WEEK3FR=11/19/20
ITICK=AB 2RDATE=09085
ITICK=AB 3RDATE=09085 09085MON=3 YR=9 DATE1=03/01/09 WEEK3FR=03/19/09
ITICK=AB 2RDATE=11355
ITICK=AB 3RDATE=11355 11355MON=12 YR=11 DATE1=12/01/11 WEEK3FR=12/15/11
ITICK=AB 2RDATE=14257
ITICK=AB 3RDATE=14257 14257MON=9 YR=14 DATE1=09/01/14 WEEK3FR=09/18/14
NOTE: The data set WORK.OUT2 has 20 observations and 22 variables.
Sincerely,
Brian Lee
------------------------------------------------------------
Department of Accountancy Voice 514-848-4102
Concordia University FAX 514-848-8645
1455 de Maisonneuve Blvd. W. GM 600-19
Montreal, Quebec, Canada H3G 1M8
------------------------------------------------------------
