附件为我在pubmed下载的medline结果,为37篇英文文章(我们这里称作记录),文件中以"PMID-"隔开的为一个记录
我要生成一个SAS数据集,每个记录(即文章)为一个观测,其中的变量需要包含以下几个:PMID;TI;AB;MH。其它的可有可无。
这四个东西分别代表我文章的id, title, abstract 和 mesh terms,其中变量的值是短杠“-”后面的文字,当然,有些文字可能跨行。
另外,MH可能有多个,我需要将所有的MH合并成一个变量
如何有效地利用infile, input进行导入,望高手指点
非常感谢,些许论坛币,聊表寸心
- PMID- 23495623
- OWN - NLM
- STAT- MEDLINE
- DA- 20130318
- DCOM- 20130411
- IS- 1049-510X (Print)
- IS- 1049-510X (Linking)
- VI- 23
- IP- 1
- DP- 2013 Winter
- TI- Depression and type 2 diabetes among Alaska Native primary care patients.
- PG- 56-64
- AB- OBJECTIVES: To assess whether type 2 diabetes mellitus (DM2) and DM2
- complications are associated with presence and severity of depression among
- Alaska Native and American Indian people (AN/Als). DESIGN: Retrospective,
- cross-sectional analysis of medical records. SETTING: Southcentral Foundation
- Primary Care Center (SCF-PCC) in Anchorage, Alaska. PARTICIPANTS: Total of 23,529
- AN/AI adults. PRIMARY OUTCOME MEASURES: Patient Health Questionnaire (PHQ) scores
- (0-9 negative, 10-14 mild, 15-19 moderate, 20+ severe) and DSM-IV depression
- diagnosis. RESULTS: DM2 prevalence was 6% (n=1,526). Of those with DM2, 19% (n =
- 292) had one or more DM2 complications and average HbAlc was 7.1%. Prevalence of
- depression diagnosis was similar between AN/Als with and without DM2 (P = .124).
- Among those screened for depression (n = 12,280), there were similar rates of PHQ
- severity between those without and with DM2; respectively 4% (n = 452) vs 4% (n =
- 42) mild, 4% (n = 404) vs 3% (n = 29) moderate, and 4% (n = 354) vs 4% (n = 38)
- severe. In multivariable logistic regression, DM2 was not associated with PHQ
- severity (OR 1.02, 95% CI 0.81-1.27) or depression diagnosis (OR 1.27, 95% CI
- 1.00-1.62). Increased odds of depression and higher depression severity were
- associated with female sex, younger age, being unmarried, substance
- abuse/dependence, and increased ambulatory visits. Depression was associated with
- number of other chronic conditions among AN/Als with DM2 but not with number of
- complications. CONCLUSIONS: Presence and severity of depression among AN/Al
- primary care patients was not significantly associated with DM2 nor DM2
- complications, despite a slightly higher rate of depression diagnosis among those
- with DM2.
- AD- Research Department, Southcentral Foundation, Anchorage, Alaska 99508, USA.
- ddillard@scf.cc
- FAU - Dillard, Denise A
- AU- Dillard DA
- FAU - Robinson, Renee F
- AU- Robinson RF
- FAU - Smith, Julia J
- AU- Smith JJ
- FAU - Khan, Burhan A
- AU- Khan BA
- FAU - Dubois, Edward W
- AU- Dubois EW
- FAU - Mau, Marjorie K
- AU- Mau MK
- LA- eng
- GR- P20 MD000173/MD/NIMHD NIH HHS/United States
- PT- Journal Article
- PT- Research Support, N.I.H., Extramural
- PL- United States
- TA- Ethn Dis
- JT- Ethnicity & disease
- JID - 9109034
- SB- IM
- MH- Adolescent
- MH- Adult
- MH- Alaska
- MH- Depression/epidemiology/*ethnology
- MH- Diabetes Mellitus, Type 2/*complications/epidemiology/*ethnology
- MH- Female
- MH- Humans
- MH- *Indians, North American
- MH- Logistic Models
- MH- Male
- MH- Middle Aged
- MH- Primary Health Care
- MH- Young Adult
- EDAT- 2013/03/19 06:00
- MHDA- 2013/04/12 06:00
- CRDT- 2013/03/19 06:00
- PST - ppublish
- SO- Ethn Dis. 2013 Winter;23(1):56-64.
- PMID- 22089223
- OWN - NLM
- STAT- MEDLINE
- DA- 20111117
- DCOM- 20120319
- IS- 1760-4788 (Electronic)
- IS- 1279-7707 (Linking)
- VI- 15
- IP- 9
- DP- 2011 Nov
- TI- Older people with diabetes have higher risk of depression, cognitive and
- functional impairments: implications for diabetes services.
- PG- 751-5
- AB- OBJECTIVES: To examine the relationship between diabetes and impairments in
- functional and cognitive status as well as depression in older people. DESIGN:
- Cross-sectional study. SETTING: Elderly Health Centres (EHC) in Hong Kong.
- PARTICIPANTS: 66,813 older people receiving baseline assessment at EHC in 1998 to
- 2001. MEASUREMENTS: Diabetes status was defined by self-report and blood glucose
- tests. Functional status was assessed by 5 items of instrumental activities of
- daily living (IADL) and 7 items of activities of daily living (ADL). Cognitive
- status was screened by the Abbreviated Mental Test-Hong Kong version (AMT).
- Depressive symptoms were screened by the Geriatric Depression Scale-Chinese
- version (GDS). RESULTS: Among the subjects, 10.4% reported having regular
- treatment for diabetes, 3.4% had diabetes but were not receiving regular
- treatment, and 86.2% did not have diabetes. After controlling for age, sex and
- education level, those having regular treatment for diabetes were 1.7 times more
- likely (OR=1.65, 95% CI: 1.51-1.80) to have functional impairment, 1.3 times more
- likely (OR=1.28, 95% CI: 1.11-1.48) to have cognitive impairment and 1.3 times
- more likely (OR=1.35, 95% CI: 1.25-1.46) to have depression, than older people
- without diabetes. CONCLUSION: Older people with diabetes may be less capable of
- managing the disease than the younger ones as a result of increased risk of both
- physical and cognitive impairment. This study provided further evidence for the
- need of an international consensus statement regarding care of diabetes in older
- people.
- AD- Faculty of Social Sciences, The University of Hong Kong, Hong Kong.
- phchau@graduate.hku.hk
- FAU - Chau, P H
- AU- Chau PH
- FAU - Woo, J
- AU- Woo J
- FAU - Lee, C H
- AU- Lee CH
- FAU - Cheung, W L
- AU- Cheung WL
- FAU - Chen, J
- AU- Chen J
- FAU - Chan, W M
- AU- Chan WM
- FAU - Hui, L
- AU- Hui L
- FAU - McGhee, S M
- AU- McGhee SM
- LA- eng
- PT- Journal Article
- PT- Research Support, Non-U.S. Gov't
- PL- France
- TA- J Nutr Health Aging
- JT- The journal of nutrition, health & aging
- JID - 100893366
- SB- IM
- MH- Activities of Daily Living/psychology
- MH- Aged
- MH- Aged, 80 and over
- MH- Cognition Disorders/*epidemiology/psychology
- MH- Cross-Sectional Studies
- MH- Depression/*epidemiology/psychology
- MH- Diabetes Mellitus/*epidemiology/psychology
- MH- Educational Status
- MH- Female
- MH- Geriatric Assessment/*statistics & numerical data
- MH- Hong Kong/epidemiology
- MH- Humans
- MH- Logistic Models
- MH- Male
- MH- Prevalence
- MH- Risk Factors
- EDAT- 2011/11/18 06:00
- MHDA- 2012/03/20 06:00
- CRDT- 2011/11/18 06:00
- PST - ppublish
- SO- J Nutr Health Aging. 2011 Nov;15(9):751-5.
- PMID- 21357362
- OWN - NLM
- STAT- MEDLINE
- DA- 20110301
- DCOM- 20110608
- LR- 20130630
- IS- 1935-5548 (Electronic)
- IS- 0149-5992 (Linking)
- VI- 34
- IP- 3
- DP- 2011 Mar
- TI- Prevalence of depression in individuals with impaired glucose metabolism or
- undiagnosed diabetes: a systematic review and meta-analysis of the European
- Depression in Diabetes (EDID) Research Consortium.
- PG- 752-62
- LID - 10.2337/dc10-1414 [doi]
- AB- OBJECTIVE: Meta-analyses have shown that the risk for depression is elevated in
- type 2 diabetes. Whether this risk in individuals with impaired glucose
- metabolism (IGM) or undiagnosed diabetes (UDD) is elevated relative to normal
- glucose metabolism (NGM) or decreased relative to previously diagnosed type 2
- diabetes (PDD) has not been the subject of a systematic review/meta-analysis.
- This study examined the prevalence of depression in IGM and UDD subjects relative
- to each other and to NGM and PDD subjects by reviewing the literature and
- conducting a meta-analysis of studies on this topic. RESEARCH DESIGN AND METHODS:
- EMBASE and MEDLINE databases were searched for articles published up to May 2010.
- All studies that compared the prevalence of depression in subjects with IGM and
- UDD were included. Odds ratios (ORs) were calculated using fixed and
- random-effects models. RESULTS: The meta-analysis showed that the risk for
- depression was not increased in IGM versus NGM subjects (OR 0.96, 95% CI
- 0.85-1.08). Risk for depression did not differ between individuals with UDD and
- individuals with either NGM (OR 0.94, 95% CI 0.71-1.25) or IGM (OR 1.16, 95% CI
- 0.88-1.54). Finally, individuals with IGM or UDD both had a significantly lower
- risk of depression than individuals with PDD (OR 0.59, 95% CI 0.48-0.73, and OR
- 0.57, 95% CI 0.45-0.74, respectively). CONCLUSIONS: Results of this meta-analysis
- show that the risk of depression is similar for NGM, IGM, and UDD subjects. PDD
- subjects have an increased risk of depression relative to IGM and UDD subjects.
- AD- School of Psychology, University of Birmingham, Birmingham, UK. f.pouwer@uvt.nl
- FAU - Nouwen, Arie
- AU- Nouwen A
- FAU - Nefs, Giesje
- AU- Nefs G
- FAU - Caramlau, Isabela
- AU- Caramlau I
- FAU - Connock, Martin
- AU- Connock M
- FAU - Winkley, Kirsty
- AU- Winkley K
- FAU - Lloyd, Cathy E
- AU- Lloyd CE
- FAU - Peyrot, Mark
- AU- Peyrot M
- FAU - Pouwer, Francois
- AU- Pouwer F
- CN- European Depression in Diabetes Research Consortium
- LA- eng
- PT- Journal Article
- PT- Meta-Analysis
- PT- Review
- PL- United States
- TA- Diabetes Care
- JT- Diabetes care
- JID - 7805975
- RN- 50-99-7 (Glucose)
- SB- IM
- MH- Depression/*epidemiology
- MH- Diabetes Mellitus/*diagnosis/*psychology
- MH- Glucose/metabolism
- MH- Glucose Intolerance/*psychology
- MH- Humans
- PMC - PMC3041222
- OID - NLM: PMC3041222
- EDAT- 2011/03/02 06:00
- MHDA- 2011/06/09 06:00
- CRDT- 2011/03/02 06:00
- AID - 34/3/752 [pii]
- AID - 10.2337/dc10-1414 [doi]
- PST - ppublish
- SO- Diabetes Care. 2011 Mar;34(3):752-62. doi: 10.2337/dc10-1414.
复制代码
|