I am connecting ACCESS database using below coding Libname ACCESS "Z:\MyDept\HEM\ClinHem\CTM\Tracking_be.accdb";   and the ERROR message showing MS ACCES requires a new version. ERROR: Connect: The database you are trying to open requires a newer version of Microsoft Access. ERROR: Error in the LIBNAME statement.   Our team create lots reports in the MS Access and really don't want to update MS Access to the new version. Is there any other way I can connection to MS Access without export individual table to excel file and then import them to SAS?     ... View more

I received a raw data from other hospital and they combine individual their  all lab dates, lab names, lab values, and lab units into one column and using "|" as delimiter   I am trying combine array and scan to separate them into columns but it's not working for me,   here is my coding, ARRAY LabName(*) Lab_Name1-Lab_Name79; DO I= 1 TO dim(LabName); LabName(I)=scan(Lab_Name,I,"|"); END; DROP I; RUN;   here is the raw data looks like ID Lab Date Lab Name Lab Value Lab Unit 1 09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008|09/19/2008 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC 39.1|13.1|25.3|33.5|75.3|8.1|200|5.19|18.0|9.6|9.6 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 2 10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011|10/12/2011 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC 36.2|12.4|25.8|34.3|75.0|8.9|208|4.83|18.4|5.1|5.1 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 3 10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011|10/05/2011 Cell Morphology|Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC Yes|40.0|13.7|25.4|34.1|74.6|8.7|214|5.37|19.0|5.6|5.6 |%|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 4 09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012|09/28/2012 Cell Morphology|Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC Yes|40.2|13.2|24.6|32.8|74.8|9.2|194|5.38|18.7|8.7|8.7 |%|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 5 11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012|11/19/2012 Cell Morphology|Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Differential Type|Instr WBC|LD Yes|39.1|12.8|23.4|32.7|71.5|8.3|243|5.47|21.1|4.8|Yes|4.8|190 |%|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL|||unit/L 6 04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013|04/15/2013 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC 38.0|12.5|24.1|33.0|73.0|8.6|173|5.21|19.6|4.9|4.9 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 7 08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013|08/05/2013 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC 37.9|12.6|24.4|33.1|73.7|9.3|179|5.15|19.4|3.9|3.9 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL| 8 09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013|09/30/2013 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC|LD 38.6|12.8|24.6|33.2|74.1|8.6|207|5.21|19.0|4.2|4.2|223 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL||unit/L 9 01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014|01/21/2014 Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Instr WBC|Nucleated Red Blood Cells 37.9|12.8|24.0|33.9|70.9|8.5|181|5.34|18.7|5.0|5.0|0.2 %|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL||/100 WBC 10 06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014|06/02/2014 Albumin|Alkaline Phosphatase|ALT|Anion Gap|AST|Calcium|Carbon Dioxide|Chloride|Glucose Serum|Potassium|Sodium|Total Bilirubin|Urea Nitrogen|CREATININE|Protein Total|Cell Morphology|Hematocrit|Hemoglobin|MCH Blood|MCHC Blood|MCV Blood|MPV|Platelet Count|RBC|RDW|WBC|Differential Type|Instr WBC|Nucleated Red Blood Cells|Absolute Retic|Percent Retic|Retic RBC 3.8|83|23|6|16|8.8|27|104|117|3.9|137|0.5|12|0.80|7.9|Yes|38.6|13.0|23.8|33.7|70.7|8.2|201|5.47|19.4|4.1|Yes|4.1|0.1|109.4|2.0|5.47 g/dL|unit/L|unit/L||unit/L|mg/dL|mmol/L|mmol/L|mg/dL|mmol/L|mmol/L|mg/dL|mg/dL|mg/dL|g/dL||%|g/dL|pg|g/dL|fL|fL|thou/mcL|x10(6)/mcL|%|thou/mcL|||/100 WBC|thou/mcL|%|x10(6)/mcL ... View more

I recently received a csv file from other hospital and in the csv file they merge all the lab name into one column and separate with | as delimiter.  like below,   MRN FIN Lab Date Lab Name Lab Value 12345 567       12345 91720 10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004|10/14/2004 Absolute Basophils|% Basophils|Absolute Eosinophils|% Eosinophils|Hematocrit|Hemoglobin|Absolute Lymphs|% Lymphs|MCH Blood|MCHC Blood|MCV Blood|Absolute Monos|% Monos|MPV|Absolute Neuts|% Neuts|Platelet Count|RBC|RBC Morphology|RDW|WBC|Slide No. .005|0.1|.239|2.6|33.5|11.1|2.27|24.6|24.1|33.1|73|.564|6.1|9.3|6.14|66.6|328|4.60|AUTO ASSESSMENT OF MORPHOLOGY UNREMARKABLE|14.5|9.2|143 I try to use proc import to read the original file however it didn't bring the entire records to SAS. Can anyone suggest me the right coding to import this data? Thank you. ... View more

I have a ACCESS database which includes tons of tables and I try to import to SAS to manage those tables. I wirte Proc import but an Error message keep pop out "ERROR: Failed to connect to the Server: ." NOTE: The SAS System stopped processing this step because of errors. Here is the SAS code I write, PROC IMPORT OUT=WORK.TEST TABLE="ALL Hb ID" DBMS=ACCESSCS REPLACE; DATABASE="U:\Databases\SCD_DATA.ACCDB"; RUN;   Does any one know how to solve this problem? I don't want to export each table to EXCEL  and then import to SAS. I am so afraid that I will lost data when I export to EXCEL and import to SAS.   Thank you ... View more

Hello,  I have a question about using proc surveyfreq procedure to examin the relationship between two categorical variables.   Currently I use chisq to perform chi-square statics but my colleague use chisq1 to performa chi-square statics.   The same dataset and same variables, when I run the proc surveyfreq procefure with chi-sq and obtained p value 0.0503. My colleague will get a different p value (0.0463) by using chisq1 to run chi-square statistics.   I know chisq1 is requested Rao-Scott modified chi-square test. My question is how do I know which chi-square statictics I should apply? Does anyone know what's difference between chisq and chisq1?  ... View more

I have some data abstracting from EHR system and all variables in this dataset are visit_id, pat_id, DEPT_KEY, PAYOR_KEY,CONTACT_DT_KEY,DICT_ENC_TYPE_KEY, APPT_CHECKOUT_DT, APPT_CHECKIN_DT,HOSP_ADMIT_DT,HOSP_DISCHRG_DT,do b Here are some example 1520,3811,5035,2311,20130327,83,3/29/2013 21:38:38,3/29/2013 19:14:56,3/29/2013 19:13:58,3/30/2013 10:20:58,6/3/1997 10:21:58 3094,3812,0,2387,20130322,83,,,4/1/2013 10:44:29,4/1/2013 15:00:29,2/4/1997 20:16:29 2173,3813,0,2611,20130313,83,,,3/20/2013 13:51:06,3/21/2013 14:31:06,2/12/1997 0:29:06 2559,3814,4825,2358,20130317,108,3/23/2013 8:15:14,3/23/2013 6:54:57,,,1/10/2001 20:28:46 1870,3815,5417,2368,20130322,83,3/25/2013 9:46:58,3/25/2013 12:21:20,3/25/2013 12:20:45,3/25/2013 20:41:45,1/3/1997 20:42:45 886,3816,0,2366,20130301,83,,,3/13/2013 10:55:22,3/13/2013 18:08:22,2/4/1997 23:28:22 I try to import these data by using EXCEL and text file, but SAS keeps showing Error message in the log window. Here is the coding that I wrote LIBNAME myxlsx XLSX '\\client\c\Pei-Lin\chop\\visit\VISIT.xlsx'; data VISIT; set myxlsx."VISIT$"n(dbSASType=(APPT_CHECKOUT_DT=datetime APPT_CHECKIN_DT=dateTime HOSP_ADMIT_DT=dateTime HOSP_DISCHRG_DT=dateTime dob=dateTime)); run; 685  LIBNAME xlsx '\\client\c\Pei-Lin\chop\\visit\VISIT.xlsx'; ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. 686  data VISIT; 687  set xlsx."VISIT$"n(dbSASType=(APPT_CHECKOUT_DT=datetime APPT_CHECKIN_DT=dateTime 687! HOSP_ADMIT_DT=dateTime HOSP_DISCHRG_DT=dateTime dob=dateTime)); ERROR: Libref XLSX is not assigned. 688  run; And then I try to import those data using text file DATA visit; INFILE '\\client\C\Pei-Lin\chop\data\visit.txt' dlm="," dsd truncover; Input visit_id pat_id DEPT_KEY PAYOR_KEY CONTACT_DT_KEY DICT_ENC_TYPE_KEY APPT_CHECKOUT_DT ymddttm20.2 APPT_CHECKIN_DT ymddttm20.2 HOSP_ADMIT_DT ymddttm20.2 HOSP_DISCHRG_DT ymddttm20.2 dob ymddttm20.2; format visit_id 4. pat_id 4. DEPT_KEY 5. PAYOR_KEY 4. CONTACT_DT_KEY 8. DICT_ENC_TYPE_KEY 3. APPT_CHECKOUT_DT datetime20. APPT_CHECKIN_DT datetime20. HOSP_ADMIT_DT datetime20. HOSP_DISCHRG_DT datetime20. dob datetime20.; run; I still got many ERROR messages and SAS didn't read the raw data correctly. NOTE: The infile '\\client\C\Pei-Lin\chop\data\visit.txt' is:       (no system-specific pathname available),       (no system-specific file attributes available) NOTE: Invalid data for APPT_CHECKOUT_DT in line 1 33-52. NOTE: Invalid data for APPT_CHECKIN_DT in line 1 53-72. NOTE: Invalid data for HOSP_ADMIT_DT in line 1 73-92. NOTE: Invalid data for HOSP_DISCHRG_DT in line 1 93-112. NOTE: Invalid data for dob in line 1 113-125. RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9 1         1520,3811,5035,2311,20130327,83,3/29/2013 21:38:38,3/29/2013 19:14:56,3/29/2013 19:13:58,3       91  /30/2013 10:20:58,6/3/1997 10:21:58 125 visit_id=1520 pat_id=3811 DEPT_KEY=5035 PAYOR_KEY=2311 CONTACT_DT_KEY=20130327 DICT_ENC_TYPE_KEY=83 APPT_CHECKOUT_DT=. APPT_CHECKIN_DT=. HOSP_ADMIT_DT=. HOSP_DISCHRG_DT=. dob=. _ERROR_=1 _N_=1 NOTE: Invalid data for APPT_CHECKOUT_DT in line 2 30-49. Can anyone tell me which step I did wrong? Thank you so muche NOTE: Invalid data for APPT_CHECKIN_DT in line 2 50-69. NOTE: Invalid data for HOSP_ADMIT_DT in line 2 70-84. ... View more