Search results for query: *

Right after I had attempted to create macro In Excel XP, when I tried to type "o " I get "6" instead and when I tried to type “I”, I get “5” instead (in WoRD and even Url).Os-Vista What I did wrong? How can I fix it? Would really appreciate for your help as I am unable to do anything!

Dear Experts, Not sure if it is a right forum… Please, readdressif otherwise. I have an interview in a week. In addition to my own expertise and experience they are looking for some familiarity with Business Objects. As far as I understand they just need somebody to work as Front End with BO...

I know how to do it in SAS but have no idea how to implement this conditional calculation in SQL Server 2005 The thing is that I would like to calculate HospDischDate=AdmitDt + LOSP in the body of Select Query: select field1 ,field2 ,?????? into desiredTable FROM myTable LOS is a length of...

Hello Experts! I have just faced problem of concantenating four tables with the same structure. Table1 Table2 Table3 Table4 I need the table named combined. How can I do it in SQL Server 2005? Thank you! Katrin

Hi experts, I need to append FOUR tables into one in Access 2007. Is there any way to do in by single query? Could you please help me with it? Any help will be greatly appreciated! Katrin

Hi Experts, 1. I need first to categorize patients by Age: If memberAge in (21,22,23,24 ) then AgeCat=’Age 21-24’ If memberAge in (25,26,27,28,29) then AgeCat=’Age 25-29’ and so on 2. And group them by Age Category and Gender in order to get a count. How can I implement these steps in a...

Hi Experts, I need to to calc the percentage of members who had different medicl conditions by ICD-9 codes. Not just by primary diagnosis but by five diagnosis as there are 5 diag for each patient in DW. For ex I need ICD-9 214-215.99 for diag1,diag2, diag3, diag4, diag5 I believe it should...

Hi Experts, I really need your help.Proc contents gave me the following: Variable Type Len Format Informat Label AdmitDate Num 8 DATETIME22.3 DATETIME22.3 AdmitDate HospDischDate Num 8 HospDischDate looks like : 1594252800 AdmitDate looks like ...

I have a list of folders and tables/fields under the folders. The problem is that I need folders in my list as the Row labels in the report while other stuff should appear on the right For example I have Folder named Asthma (1) under which I have Asthmatics(1)and Folder named...

Hi experts, For more than 10 monthes I was able to work from home throght citrix and perfectly used all employer company software and toOls. Recently something happened that I stopped get software any more. Although I am still able to log on to corporate system PC through citrix but I am...

Hi Experts, I have a population of patients=3981 with certain diagnosis . -1478 of them met a certain medical procedure 1478/3981=37.1% -while the rest of them did not 2503/3981=62.9% -Besides the 1st category should be split up into categories: Teaching hospital and...

Hi experts! I need to create a simple graph. Just to illustrate how percent rates change from the year to year I need years 2008,2009,2010, 2011 shown on the horizontal Axe while Rates 38, 36,37, 38 shown as 2-D line . Try as I might I was unable to do it . Instead I got 38, 36,37, 38 shown...

Hello experts, I wonder if you can help me with code... I have 4 files: File2008 File2009 File2010 File2011 and I need to set a field "FridayFlag" with value =1 for all fridays in each file. Proc contents for the ServiceDate look like the following: Variable Type Len Format...

Hi experts! I just wonder if it is truth? Is it a real one? I am absolutely confused. Should I provide the information they request? I am asking because this yahoo account is very important for me and I wouldn't like to loose it :(. Thank you for any responces. Katrin

It sounds like a miracle.I created two tables: for hospitalozation and Office visits.Then I merged them by memberid and get 572000 records. Then it was decided to include alternative id field for further linking to another DW. For hospitalization table as well as for Office visit I got exactly...

Good morning experts! I have list of members with : memberid ,claimid ,office Visite date ,Hospital Discharge date I need to leave unique discharges (they are about Hospital Discharge Date).However I have multiple office Visits for the discharge while I just need a list of unique discharges.It...

When I run the following code I get a bunch of DiagnosisCode values which are NULL However when I run the same code with a right join I do not get any empty/missing fields for PrimaryDiagnosisCode: Actually "DiagnosisCode" field allows null values while PrimaryDiagnosisCode from Claim table does...

1.I have AdmitDate (datetime not null) 2011-03-01 00:00:00,00 2.and I have LOS(length of stay numeric data) 1 or 2 or 3 and etc days of stay in hospital I need to calculate Dischargedate and I do not know what what be a syntax for convertion, calculating data type and concantinatiing. Could...

Hi experts, I have two tables which I am going union into one table: 1. Claims with acute hospitalization 2. Emergency Room claims I can use Union to create this common table. Something like that: However it would be just a select query while I need a table ************************ It...

I am struggling with somebody code trying to adopt it to my purposes.... It creates tables but I am unable to find then in the DW. select * into ##XX from...... Does it mean that these are just temporary tables and that I would not be able to find them after logoff? Thank you! Katrin