About tmm

tmm · ‎05-08-2012

and now I am running 10 like queries with each of the claim numbers. I just had to do it that way cuz they want to see all the 01, 02, 03 etc on up to 50 if they have that many pages

tmm · ‎05-08-2012

Yeah I know about substr but they want to see the 01, 02, 03's etc on each of the 10 claims. I guess I will have to do a like and then 1 claim at a time

tmm · ‎05-08-2012

I have this code and do not think it is 100% correct: proc sql; create table implants.test1 as (select * from implants.alldrgs_asofi where clm_aud_nbr in ('%1111111111%', '%2222222222%', '%3333333333%', '%4444444444%', '%5555555555%', '%6666666666%', '%7777777777%', '%8888888888%', '%9999999999%') group by clm_aud_nbr); run; The numbers in the in are just made up since I cannot give you actual claim numbers due to privacy laws. But each claim is actually 12 digits in length and the 01, 02, 03 etc that follows the 10 digit claim number notes pages. We do not know how many pages are associated with each claim so all we want to do is pull all the pages associated with that 10 digit claim number without trying to figure out who has 01, 02, 03 etc. They can go on up to 50 pages in length.

tmm · ‎05-08-2012

The output was not what I needed. The code I have outputs all that is requested of me but they also want expected to be in that readm.final table. It is in the .rtf file. Will post that portion as well. ODS RTF FILE='C:\documents and settings\tmill29\my documents\my sas files\9.2\readmin\readm.RTF'; PROC FREQ DATA = ReAdm.CHI2 ORDER = DATA; BY COMPARISON; WEIGHT COUNT; TABLES SVRTY_LVL_CD*WHO*ADMISSION/CMH EXPECTED OUTEXPECT; EXACT OR; OUTPUT OUT = ReAdm.Final OR CMH; RUN; ODS RTF CLOSE; My output say for my first who which is a taxID has the expected for readmit of 0.1767 and expected for admit of 3.8233 in the rtf file created and then it has the other items associated with code above. When I look at that final for the output out all items for cmh and or are in there but the expected does not fee over to that. I tried putting expected outexpect in the output out = after the OR and CMH but that did not work.

tmm · ‎05-08-2012

I am trying to get the expected also in my chi sq information and this is the code I am using. PROC FREQ DATA = ReAdm.CHI2 ORDER = DATA; BY COMPARISON; WEIGHT COUNT; TABLES SVRTY_LVL_CD*WHO*ADMISSION/ CMH EXPECTED; EXACT OR; OUTPUT OUT = ReAdm.Final; RUN; When I view my final items I do not see expected anywhere in the columns. I can see the rest. How can I get expected in there as well?

tmm · ‎05-07-2012

Ah that distinct. I took that out and got the correct claim counts now. I also think that the reason I am confused on the monetary is because when it sums it up by the sys_drg_cd or groups by I should say, it takes all DRG's that are 0001 which is a heart transplant and totals those claims and then I get the sum of the alloc_amt and epd_amt which is not within the 0.01 or 0.05 cents however I am asking for each claim to be within that monetary amount, not the final sum of information. So I can see why some of these are off by more than 0.05 cents.

tmm · ‎05-07-2012

Without the distinct it does not distinctly count my claimnums. If I take it out for example it will group the sys_drg_cd that is 0001 as 479 distinct claim numbers. By putting in distinct it does the correct claim count of 173 and sum the monetary columns as it should. All I need is to have the between stuff work right. That is what the problem is.

tmm · ‎05-07-2012

I have to have the sys_drg_cd and sys_drg_desc This is how I am group by and must have the group by these.

tmm · ‎05-07-2012

I have this as my code: proc sql; create table implants.implants_sum2 as (select distinct sys_drg_cd, drg_desc, count(distinct claimnum) as Total_Claims, sum(alloc_allw_amt) as Total_Allowed, sum(epd_calc_allw_amt) as Total_EPD from implants.implants_sum where epd_calc_allw_amt= alloc_allw_amt or (epd_calc_allw_amt between (alloc_allw_amt + 0.01) and (alloc_allw_amt + 0.05)) or (epd_calc_allw_amt between (alloc_allw_amt - 0.01) and (alloc_allw_amt - 0.05)) group by sys_drg_cd, drg_desc); run; It is only supposed to return any alloc_allw_amt that is between 0.01 cent and 0.05 cents compared to the epd_calc_allw_amt so if the column looks like the below a X is what should be returned based on code above: alloc_allw_amt epd_calc_allw_amt check 1010.00 1010.00 X 1010.05 1010.00 X 1010.10 1010.00 1010.01 1010.00 X 1010.02 1010.00 X 1010.06 1010.02 X 1010.09 1010.20 1010.01 1010.00 X The problem is I am getting all those amounts you see in alloc_allw_amt column returned. It should not be returning the .10 and the .11 cent differing ones.

tmm · ‎05-04-2012

I figured it out based on some of the responses I received. I should be grouping by tin then svrty_lvl_cd. the output just doing it by tin was this: tin admit svrty_lvl_cd desc 1111 12 1 minor 1111 12 2 major 1111 12 3 extreme Chging and grouping by tin and svrty_lvl_cd outputs this: tin admit svrty_lvl_cd desc 1111 1 1 minro 1111 8 2 major 1111 3 3 extreme Thanks

tmm · ‎05-04-2012

PROC SQL; CREATE TABLE ReAdm.TINCounts AS (SELECT DISTINCT TIN, COUNT(ADMIT) AS ADMIT, SVRTY_LVL_CD, SVRTY_LVL_DESC FROM ReAdm.ReAdm1 GROUP BY TIN); RUN; This code works but the ReAdm1 table it is pulling from looks like this: mbr_id tin fst_srvc_dt admit readmit svrty_lvl_cd svrty_lvl_desc 11111 xyz 24aug2010 1 0 1 minor 11111 xyz 22mar2011 1 0 2 major 11111 xyz 16sep2009 1 0 3 extreme The output from my code above is: tin admit svrty_lvl_cd svrty_lvl_desc xyz 3 1 minor xyz 3 2 major xyz 3 3 extreme I need the output to show 1 for each of the svrty_lvl_cd and not sum the admits all into one.

tmm · ‎05-02-2012

You are a genius. This works perfectly. ABS did not return correctly but what you provided is perfect.

tmm · ‎05-02-2012

I don't think my where statements are right. I want to say if the epd is a certain amount or if it is between 1 and 5 cents higher or lower than the allw_amt that I want the information to return in the sum2 table I am creating. So example info epd_amt alloc_amt 1010.00 1010.00 1010.01 1010.00 1010.02 1010.00 1010.03 1010.00 1010.04 1010.00 1010.05 1010.00 1010.06 1010.00 1010.12 1010.00 With this information the only items that should return are anything that is equal which there is 1 and the the ones that are .01 to .05 cents. The .06 and .12 should not be in my table. proc sql; create table sum2 as (select distinct drg_cd, drg_desc, count(claimnum) as TotalClaims, sum(alloc_allw_amt) as TotalAllowed, sum(epd_calc_allw_amt) as TotalEPD from sum where epd_calc_allw_amt = alloc_allw_amt or epd_calc_allw_amt between + 0.01 and + 0.05 = alloc_allw_amt or epd_calc_allw_amt between -0.01 and -0.05 = alloc_allw_amt group by sys_drg_cd, drg_desc); run;

tmm · ‎05-01-2012

I need the substr to take the first 10 characters of the 12 characters. It is a text and looks similiar to this: 11111111101 I need to drop the 01 off the end. proc sql; create table implants.alldrgs_sum as (select distinct substr(clm_aud_nbr,2,10) as ClaimNum, sys_drg_cd, drg_desc, alloc_rvnu_cd, funding, alloc_allw_amt, epd_calc_allw_amt, alloc_net_pd_amt from implants.implants_aso_alldrgs_copy group by clm_aud_nbr); run;

tmm · ‎04-30-2012

I want to trim the end 2 numbers from a column and normally can just do a trim statement but not working right. Here is my code: proc sql; create table implants.alldrgs_sum as (select distinct trim(left(clm_aud_nbr),10) as ClaimNum, sys_drg, drg_desc, alloc_rvnu_cd, funding, alloc_allw_amt, epd_calc_allw_amt, alloc_net_pd_amt from implants.implants_aso_alldrgs_copy group by clm_aud_nbr); run;

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

Place quotes around column header and data

Re: Point = error

Point = error

Re: Insert into confusion

Re: Insert into confusion

Insert into confusion

Re: create a proc sql without the need for multiple proc sqls

create a proc sql without the need for multiple proc sqls

Re: how to combine 2 inner joins to proc sql

how to combine 2 inner joins to proc sql

format max date

concatenating number columns

Re: Like with In statement

Re: Like with In statement

Like with In statement

Re: chi sq with expected

chi sq with expected

Re: SAS Calc code not working quite right

Re: SAS Calc code not working quite right

Re: SAS Calc code not working quite right

SAS Calc code not working quite right

Re: Help with code

Help with code

Re: Little help with between

Little help with between

substr problem

proc sql trim