Date: Thu, 20 May 1999 12:13:33 PDT
Reply-To: Larisa vaysblat <calgary52@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Larisa vaysblat <calgary52@HOTMAIL.COM>
Subject: #2 Re-Problem with funny char $,#,@
Content-type: text/plain; format=flowed;
This is what happens and I read about it in the procedure quide and under id
it discusses this situation, but how do I combat it!!! Any suggestions.
OBS CC6 DAY QUANT
1 ABP$ 17 2298.252
2 ABP$ 18 1973.508
3 ABP$ 19 1972.889
4 ABP# 17 2788.678
5 ABP# 18 1597.670
6 ABP# 19 1599.186
7 ACF2CP 17 34.767
8 ACF2CP 18 34.767
9 ACF2CP 19 34.767
10 ACICS 17 321.081
11 ACICS 18 321.082
12 ACICS 19 321.079
13 ACIIS 17 5603.540
14 ACIIS 18 5581.812
39 ADS$ 17 6143.957
40 ADS$ 18 6250.361
41 ADS$ 19 6499.672
42 AJS$ 17 2143.015
43 AJS$ 18 2158.417
44 AJS$ 19 2119.937
45 AJS@ 17 393.974
46 AJS@ 18 317.706
47 AJS@ 19 372.218
48 AMA$ 17 622337.650
49 AMA$ 18 600742.244
50 AMA$ 19 610733.637
51 AMA# 17 257634.209
52 AMA# 18 255772.787
PROC TRANSPOSE DATA = SUMS OUT= TRANSOUT;
VAR QUANT;
ID COSTCTR6;
BY DAY;
RUN;
ERROR: The ID value "ABP_" occurs twice in the same BY group.
ERROR: The ID value "ABP_" occurs twice in the same BY group.
ERROR: The ID value "ACT_" occurs twice in the same BY group.
ERROR: The ID value "ACT_" occurs twice in the same BY group.
ERROR: The ID value "ACT_" occurs twice in the same BY group.
ERROR: The ID value "AJS_" occurs twice in the same BY group.
ERROR: The ID value "AJS_" occurs twice in the same BY group.
ERROR: The ID value "AJS_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMA_" occurs twice in the same BY group.
ERROR: The ID value "AMB_" occurs twice in the same BY group.
ERROR: The ID value "AMB_" occurs twice in the same BY group.
ERROR: The ID value "AMB_" occurs twice in the same BY group.
ERROR: The ID value "ARB_" occurs twice in the same BY group.
ERROR: The ID value "ARB_" occurs twice in the same BY group.
ERROR: The ID value "ARB_" occurs twice in the same BY group.
ERROR: The ID value "BDS_" occurs twice in the same BY group.
5/19/1999 2:57 PM
>
>Im running a proc transpose and some of my values in a variable have funky
>characters.
>
>i have a variable in the id part which automatically gets labelled as a
>variable when it transposes.
>
>HOwever the funky characters are causing a problem...any suggestions?
>currently Im just going to rename them but any advice would be great just
>for the future.
>
>thank you
>Larisa
>
>
>_______________________________________________________________
>Get Free Email and Do More On The Web. Visit http://www.msn.com
>
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
