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 <...

carp, I tried to do it but get an error ORA-00932: inconsistent datatypes: expected NUMBER got DATE Actually for SYSDATE it is for sure ( 5/7/2018 10:49:07 AM) . As for dte_received it looks like a string 20171213. I tried to convert but failed. This is my problem as I am new in Oracle...

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...

Sorry, I meant being in Access I imported source file into a table in the current database. Now I tried another option. I link the data source by creating a linked table. There were no error anymore . Now the table looks OK. In this case I am not sure, howeve,r if I would be able to manipulate...

Then I imported the file from MS ACCESS 2010. It was not imported successfully. About 35,000 records were truncated .

I was sent .csv and tried to open it with Excel. System message said, “.csv may contain features that are not compatible with csv(comma delimited). Do you want to keep the work book in this format? -to keep this format which leaves out any incompatible features, click Yes -To preserve the...

SkipVought, Thanks for the prompt response. I have just look at the file which is huge in Excel and used Find and select option to find comma if any. It was not found.... Estersita

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...

Klaz, Does it mean that I could eliminate the NOT LOGGED INITIALLY statement and et it just slower ? execute( create table &TmpSchema..G (ID CHAR(30) ,tag char (3) ,Mydate date ) in "&twotblspc" )by Mconnect; Thank you! Estersita

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...

I included both source.id and medclm.id fields into my query and they are all equal. It looks like that happened because there are a lot of duplicate IDs in the bigger table MEDclm which ALL match SOURCE.ID! So, in order to add a couple of fields from MEDCLM one have to have criteria based on...

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

It works! God bless You!

I have 87 records in my makepart1 table. These both queries return 86 records. I wonder...probably it happens because my table have not just duplicates but also includes singe records (which NEVER had duplicates). That is why I tried the relation which I mentioned above... But it didn't work...

This query WITH INT() does work! I got just “correct” duplicates (those ones with the same MEMBER ID and same DATE OF QUESTION values The last step I need is to eliminate duplicates (do not care about criteria anymore) I assume I should create a query NODUPL with one field {MEMBER ID] and I...

Yes, they are Date/Time and I made sure they have short format. The only thing is...I inherited the initial table and it looks like it was created in Access 2000 while I work in Access 2002 xp. Could it affect?