Date: Fri, 18 May 2007 17:14:23 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Unexpected Data type conversion
In-Reply-To: <207252.39231.qm@web51610.mail.re2.yahoo.com>
Content-Type: text/plain; format=flowed
Irin ,
Check your log to make sure everything ran okay then check your code:
ICD_PROC1_DESC is in your proc contents but not in your SQL code, which is
telling me that the proc contents you are looking at is not on the data set
that was generated by your SQL code.
Toby Dunn
On the other hand, you have different fingers. ~ LCG
The early bird may get the worm, but the second mouse gets the cheese in the
trap. ~ LCG
What happens if you get scared half to death, twice? ~ LCG
From: Irin later <irinfigvam@YAHOO.COM>
Reply-To: Irin later <irinfigvam@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Unexpected Data type conversion
Date: Fri, 18 May 2007 09:58:04 -0700
I ran the following code:
PROC SQL;
CREATE TABLE out.medclaimsComb AS
(SELECT Distinct g.icd_diag_grp_key,
max(g.ICD_DIAG1_DESC),max(g.ICD_DIAG1_CD),
max(m.received_dt),max(m.last_process_dt)
FROM out.Merge_Main_icddiagGrp g INNER JOIN DW.V_MEDICAL_CLAIM m ON
m.ICD_DIAG_GRP_KEY=g.ICD_DIAG_GRP_KEY
GROUP BY g.icd_diag_grp_key
);
When I did Proc Content for data= out.medclaimsComb I got the following
listing:
# Variable Type Len Pos
-------------------------------------------
5 ICD_DIAG1_CD Num 8 16
1 ICD_DIAG_GRP_KEY Num 8 0
2 ICD_PROC1_DESC Char 100 24
4 last_process_dt Num 8 8
3 received_dt Char 5 124
When I did Proc Content for data= DW.V_MEDICAL_CLAIM I got the following
listing:
# Variable Type Len Pos
Format Informat Label
------------------------------------------------------------------------------------------------------------
59 LAST_PROCESS_DT Num 8 504 DATE9. DATE9.
LAST_PROCESS_DT
62 RECEIVED_DT Num 8 544 DATE9.
DATE9. RECEIVED_DT
For some reason received_dt showed me a CHAR data type while the second
one shows NUMERIC. Even the size differs
However out.medclaimsComb table was built on DW.V_MEDICAL_CLAIM TABLE
(which was only of merged table that had received _dt at all)
What I am doing wrong?
Thank you in advance,
Irin
---------------------------------
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
_________________________________________________________________
More photos, more messages, more storage—get 2GB with Windows Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507
