Search results for query: *

Dear Experts, I am trying to create a column with values through the SELECT statement just adding 21 days: SELECT DISTINCT cde_proc, i.cde_proc_mod, i.num_pa_line_item , i.dte_received stat.dsc_pa_status, i.qty_unt_svc_ath...

Hi Experts, I have to answer certain questions for my VPN Access Request. I am supposed to work from home once in a while using my own PC laptop. One of the question is about Microsoft Patches up to date. How would I know if I do have Patches on my home PC? Could you please tell me how can I...

How to convert SAS logic into a Oracle SQL syntax? Hi Experts, Having below algorithm in SAS I am struggling to build a code in Oracle SQL. Could you please help me with code? Thank you! Estersita --This is what I have in SAS data mytable; set have; elig.DTE_Effective <...

Dear Experts, I want to set the condition where dte_received is between today date and the date 12 months ago.So far I tried the following statement: WHERE dte_received between (sysdate,-12) and sysdate; (at which System generated an error message) I run the following: SELECT SYSDATE FROM...

Dear Experts, Being in a process of importing Microsoft Excel Comma Separated Values File (.csv)file into MS ACCESS 2010 table I face an obstacle because a certain field was truncated. Then I have configured the table with field Memo type instead of text 255 barrier. However, try as I might...

I am trying to understand the folowing piece of code: data long (keep=icd9 icd10); set cwalk_wide; array _in(*) $ icd10:; i=1; do while (i le dim(_in)); if not missing(_in{i}) then do; icd10=_in(i); output; i+1; end; else i=dim(_in)+1; end; run; Could...

Hi, I am confused with a following statement from somebody code as I do not understand the syntax (never worked with SAS before): proc sql; connect to odbc as ...; * Transient table is created and loaded execute( create table &TmpSchema..G (ID CHAR(30) ,tag char (3) ,Mydate...

Hi I have a small table Source (100 rec) and I have a big table MedClaim (3000 rec) Some of Souce IDs are the same as in MedClm. Also Med Clm have a lot of duplicates. All I want is just to add some additional fields from Medclm to Source in order to add certain fileds from MedClm to...

Hi, I wonder if I can use a view which was based on the table which was deleted? Thank you in advance Estersita

Hi I have beaten my head to resolve this duplicate problem that appeared to be more complicated than I asked before. I used the query below and it does eleiminate earlier DATE OF QUESTION record (which is my purpose) but unfortunately in case there are 3 records with 2 of them equal with...

Hi , I am trying to delete duplicate records considering that their date of question fields are not the same and I want to remain later date record I never happened to submit delete query in access before. When I try to run my query I got the following message: Specify the table containing the...

Hello, I submitted an SQL query in order to find members with the same Member ID and different Source field value . In order to do it I created a copy of Flue_2003 and named it FluNODupl. My query looks like the following: SELECT [FLUE_2003].[MEMBER ID],[FLU_2003].[SOURCE],[FLUNODUPL].[MEMBER...

Hi! I am trying to count occurrences (rows) which contain equal strings break on the same fileld In other words I need counting subtotal and total but I do not need computation as these are just strings For example I have: Code Zp Zp Zp Zp No No No Yes Yes What I need is: Zp...

Hi everybody, I wonder if anybody can help me. I need to set environment variable TWO_TASK to have the value for the instance ISY01B WHAT should be the UNIX command string that I should issue? Thank you in advance, Estersita

Hi, Recently I got a great help from SantaMufasa (thread 759-911843) with resolving totals calculations problem.I did got totals I needed! Now I realized I also need other fields (except err_num)to be dispayed. Since the nature of Group by does not allow it, I assumed I need a subquery for that...

Hi, Could you please help me with the following problem? I have a following table name Messages: ****************** msg_code totals ****************** sssss 2 ccccc 3 sssss 5 ccccc 1 I would like to get a sum of totals by msg_code ****************** msg_code totals...