You can create create a Databricks table by using PROC SQL, but you cannot insert data into the table. PROC APPEND cannot create a new table or append data to an existing table.

A DATA step and PROC SQL can round numeric values while creating and loading data into a new Databricks table via JDBC.

When you bulk load data into a Google BigQuery database, you might encounter this error: "Error while reading data, error message: CSV table encountered too many errors, giving up...Error detected while parsing row starting at position: 0...Data

When you add one row to an Oracle table using DBIDIRECTEXEC, you see the following misleading trace message: "ORACLE: 4294967296 rows inserted/updated/deleted." You should see something similar to the following: "ORACLE: 1 rows inserte

If your SAS Visual Analytics report contains many sections and objects, you might encounter performance problems when you are editing the report.   A hot fix is planned for this issue.

Severity: Medium Description: PROC PRINT might fail with a buffer overrun when you submit it in conjunction with certain malformed SAS statements.

Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact:

A custom sort might be sorted incorrectly when the data item is used in a custom category, which is then used in a hierarchy. The issue can occur in the following scenario:

In SAS  High-Performance Risk, a STRESS task might fail with a message like the following in the SAS log while the compute server is sending the ScenarioCF/Value data to the HPRisk Engine:

A set of PROC SQL queries that create a view, contain a constant column, contain a computed column, and a create a table do not generate a unique set of rows in the table that is created.

An issue occurs when code contains a complex SQL procedure query with a WHERE clause that contains multiple subselects. Incorrect results might be returned. Click the Hot Fix tab in this note to

When you read in a BigQuery table, the length of string variables might be longer than the length specified with the MAX_CHAR_LEN= option when running your SAS software   with UTF-8. By

You might see the following error in SAS Workflow Studio when you try to open the CECL_Cycle_AFS workflow template that is shipped with SAS Solution for CECL:

Under UNIX, the process of updating a lookup table in SAS Business Rules Manager does not work properly. The problem occurs when you perform these steps:  Open a lookup table. Cl

SAS Visual Data Builder might not enable you to create multiple time-event triggers. The + button to add another trigger is not available to select, as shown in the following display: imgalt="" src="{fusion_658

When you attempt to save a report distribution in SAS Visual Analytics Designer, you might see the error shown in the following display:  imgalt="" src="{fusion_65868_1_distributionerror.png}" />

All 30 Major League teams will wear special "MLB 150" patches on their uniforms for the entire 2019 season in honor of the 150th anniversary of the 1869 Cincinnati Red Stockings, the first openly all-salaried professional baseball team.

Brendan McKay is still going to be a two-way player, but the Rays are planning to narrow his focus on the hitting side by keeping him to designated hitter-only duties, a source confirmed to MLB.com's Juan Toribio on Monday.

The 30 prospects below all are getting very long looks this spring with an eye toward breaking camp with the parent club. Even if they start the year in the Minors, they all should get the chance to contribute at some point in the very near future.

Colin Poche's fastball won't light up the radar gun, but it proved to be one of the most effective pitches in the Minors last season.

Who do the Rays have in the pipeline? Get scouting reports, video, stats, projected ETAs and more for Tampa Bay's Top 30 Prospects on MLB Pipeline's Prospect Watch.

Numerous zinc ectoenzymes are metalated by zinc and activated in the compartments of the early secretory pathway before reaching their destination. Zn transporter (ZNT) proteins located in these compartments are essential for ectoenzyme activation. We have previously reported that ZNT proteins, specifically ZNT5–ZNT6 heterodimers and ZNT7 homodimers, play critical roles in the activation of zinc ectoenzymes, such as alkaline phosphatases (ALPs), by mobilizing cytosolic zinc into these compartments. However, this process remains incompletely understood. Here, using genetically-engineered chicken DT40 cells, we first determined that Zrt/Irt-like protein (ZIP) transporters that are localized to the compartments of the early secretory pathway play only a minor role in the ALP activation process. These transporters included ZIP7, ZIP9, and ZIP13, performing pivotal functions in maintaining cellular homeostasis by effluxing zinc out of the compartments. Next, using purified ALP proteins, we showed that zinc metalation on ALP produced in DT40 cells lacking ZNT5–ZNT6 heterodimers and ZNT7 homodimers is impaired. Finally, by genetically disrupting both ZNT5 and ZNT7 in human HAP1 cells, we directly demonstrated that the tissue-nonspecific ALP-activating functions of both ZNT complexes are conserved in human cells. Furthermore, using mutant HAP1 cells, we uncovered a previously-unrecognized and unique spatial regulation of ZNT5–ZNT6 heterodimer formation, wherein ZNT5 recruits ZNT6 to the Golgi apparatus to form the heterodimeric complex. These findings fill in major gaps in our understanding of the molecular mechanisms underlying zinc ectoenzyme activation in the compartments of the early secretory pathway.

Contact between inflammatory cells and endothelial cells (ECs) is a crucial step in vascular inflammation. Recently, we demonstrated that the cell-surface level of endomucin (EMCN), a heavily O-glycosylated single-transmembrane sialomucin, interferes with the interactions between inflammatory cells and ECs. We have also shown that, in response to an inflammatory stimulus, EMCN is cleared from the cell surface by an unknown mechanism. In this study, using adenovirus-mediated overexpression of a tagged EMCN in human umbilical vein ECs, we found that treatment with tumor necrosis factor α (TNF-α) or the strong oxidant pervanadate leads to loss of cell-surface EMCN and increases the levels of the C-terminal fragment of EMCN 3- to 4-fold. Furthermore, treatment with the broad-spectrum matrix metalloproteinase inhibitor batimastat (BB94) or inhibition of ADAM metallopeptidase domain 10 (ADAM10) and ADAM17 with two small-molecule inhibitors, GW280264X and GI254023X, or with siRNA significantly reduced basal and TNFα-induced cell-surface EMCN cleavage. Release of the C-terminal fragment of EMCN by TNF-α treatment was blocked by chemical inhibition of ADAM10 alone or in combination with ADAM17. These results indicate that cell-surface EMCN undergoes constitutive cleavage and that TNF-α treatment dramatically increases this cleavage, which is mediated predominantly by ADAM10 and ADAM17. As endothelial cell-surface EMCN attenuates leukocyte–EC interactions during inflammation, we propose that EMCN is a potential therapeutic target to manage vascular inflammation.

Objective:

GPR40 is a G protein-coupled receptor regulating free fatty acid-induced insulin secretion. We have generated transgenic mice overexpressing the human GPR40 gene (hGPR40-Tg) under control of the mouse insulin II promoter and have used them to examine the role of GPR40 in the regulation of insulin secretion and glucose homeostasis.

To ensure fetal lipid supply, maternal blood triglyceride (TG) concentrations are robustly elevated during pregnancy. Interestingly, a lower increase in maternal blood TG concentrations has been observed in some obese mothers. We have shown that high-fat (HF) feeding during pregnancy significantly reduces maternal blood TG levels. Therefore, we performed this study to investigate if and how obesity alters maternal blood TG levels. Maternal obesity was established by prepregnant HF feeding (ppHF), which avoided the dietary effect during pregnancy. We found that maternal blood TG concentrations in ppHF dams were not only remarkably lower than control dams, but the TG peak occurred earlier during gestation. Hepatic TG production and intestinal TG absorption were unchanged in ppHF dams, but systemic lipoprotein lipase (LPL) activity was increased, suggesting that increased blood TG clearance contributes to the decreased blood TG concentrations in ppHF dams. Although significantly higher levels of UCP1 protein were observed in iBAT of ppHF dams, Ucp1 gene deletion did not restore blood TG concentrations in ppHF dams. Expression of the angiopoietin-like protein 4 (ANGPTL4), a potent endogenous LPL inhibitor, was significantly increased during pregnancy. However, the pregnancy-induced elevation of blood TG was almost abolished in Angptl4^-/- dams. Compared with control dams, Angptl4 mRNA levels were significantly lower in iBAT, gWAT and livers of ppHF dams. Importantly, ectopic overexpression of ANGPTL4 restored maternal blood TG concentrations in ppHF dams. Together, these results indicate that ANGPTL4 plays a vital role in increasing maternal blood TG concentrations during pregnancy. Obesity impairs the rise of maternal blood TG concentrations by reducing ANGPTL4 expression in mice.

Swi-independent 3a and 3b (Sin3a and Sin3b) are paralogous transcriptional coregulators that direct cellular differentiation, survival, and function. Here, we report that mouse Sin3a and Sin3b are co-produced in most pancreatic cells during embryogenesis but become much more enriched in endocrine cells in adults, implying continued essential roles in mature endocrine-cell function. Mice with loss of Sin3a in endocrine progenitors were normal during early postnatal stages but gradually developed diabetes before weaning. These physiological defects were preceded by the compromised survival, insulin-vesicle packaging, insulin secretion, and nutrient-induced Ca²⁺ influx of Sin3a-deficient β-cells. RNA-seq coupled with candidate chromatin-immunoprecipitation assays revealed several genes that could be directly regulated by Sin3a in β-cells, which modulate Ca²⁺/ion transport, cell survival, vesicle/membrane trafficking, glucose metabolism, and stress responses. Lastly, mice with loss of both Sin3a and Sin3b in multipotent embryonic pancreatic progenitors had significantly reduced islet-cell mass at birth, caused by decreased endocrine-progenitor production and increased β-cell death. These findings highlight the stage-specific requirements for the presumed "general" coregulators Sin3a and Sin3b in islet β-cells, with Sin3a being dispensable for differentiation but required for postnatal function and survival.

Insulin is first produced in pancreatic β-cells as the precursor prohormone proinsulin. Defective proinsulin processing has been implicated in the pathogenesis of both type 1 and type 2 diabetes. Though there is substantial evidence that mouse β-cells process proinsulin using prohormone convertase 1/3 (PC1/3) then prohormone convertase 2 (PC2), this finding has not been verified in human β-cells. Immunofluorescence with validated antibodies reveals that there was no detectable PC2 immunoreactivity in human β-cells and little PCSK2 mRNA by in situ hybridization. Similarly, rat β-cells were not immunoreactive for PC2. In all histological experiments, PC2 immunoreactivity in neighbouring α-cells acts as a positive control. In donors with type 2 diabetes, β-cells had elevated PC2 immunoreactivity, suggesting that aberrant PC2 expression may contribute to impaired proinsulin processing in β-cells of patients with diabetes. To support histological findings using a biochemical approach, human islets were used for pulse-chase experiments. Despite inhibition of PC2 function by temperature blockade, brefeldin-A, chloroquine, and multiple inhibitors that blocked production of mature glucagon from proglucagon, β-cells retained the ability to produce mature insulin. Conversely, suppression of PC1/3 blocked processing of proinsulin but not proglucagon. By demonstrating that healthy human β-cells process proinsulin by PC1/3 but not PC2 we suggest that there is a need to revise the longstanding theory of proinsulin processing.

Clinical studies have shown a link between hyperuricemia (HU) and diabetes, while the exact effect of soluble serum urate on glucose metabolism remains elusive. This study aims to characterize the glucose metabolic phenotypes and investigate the underlying molecular mechanisms using a novel spontaneous HU mouse model in which the Uricase (Uox) gene is absent. In an attempt to study the role of HU in glycometabolism, we implemented external stimulation on Uox-knockout (KO) and wild-type (WT) males with a high-fat diet (HFD) and/or injections of multiple low-dose streptozotocin (MLD-STZ) to provoke the potential role of urate. Notably, while Uox-KO mice developed glucose intolerance in the basal condition, no mice spontaneously developed diabetes, even with aging. HFD-fed Uox-KO mice manifested similar insulin sensitivity compared with WT controls. HU augmented the existing glycometabolism abnormality induced by MLD-STZ and eventually led to diabetes, as evidenced by the increased random glucose. Reduced β-cell masses and increased terminal deoxynucleotidyl TUNEL-positive β-cells suggested that HU-mediated diabetes was cell death dependent. However, urate-lowering treatment (ULT) cannot ameliorate the diabetes incidence or reverse β-cell apoptosis with significance. ULT displayed a significant therapeutic effect of HU-crystal– associated kidney injury and tubulointerstitial damage in diabetes. Moreover, we present transcriptomic analysis of isolated islets, using Uox-KO versus WT mice and streptozotocin-induced diabetic WT (STZ-WT) versus diabetic Uox-KO (STZ-KO) mice. Shared differentially expressed genes of HU primacy revealed Stk17β is a possible target gene in HU-related β-cell death. Together, this study suggests that HU accelerates but does not cause diabetes by inhibiting islet β-cell survival.

Obesity has recently become a prevalent health threat worldwide. Although emerging evidence has suggested a strong link between the pentose phosphate pathway (PPP) and obesity, the role of transketolase (TKT), an enzyme in the non-oxidative branch of the PPP which connects PPP and glycolysis, remains obscure in adipose tissues. In this study, we specifically delete TKT in mouse adipocytes and find no obvious phenotype upon normal diet feeding. However, adipocyte TKT abrogation attenuates high fat diet (HFD)-induced obesity, reduces hepatic steatosis, improves glucose tolerance, alleviates insulin resistance and increases energy expenditure. Mechanistically, TKT deficiency accumulates non-oxidative PPP metabolites, decreases glycolysis and pyruvate input into the mitochondria, leading to increased lipolytic enzyme gene expression and enhanced lipolysis, fatty acid oxidation and mitochondrial respiration. Therefore, our data not only identify a novel role of TKT in regulating lipolysis and obesity, but also suggest limiting glucose-derived carbon into the mitochondria induces lipid catabolism and energy expenditure.

Hypo-vascularised diabetic non-healing wounds are due to reduced number and impaired physiology of endogenous endothelial progenitor cell (EPC) population that, limits their recruitment and mobilization at the wound site. To enrich the EPC repertoire from non-endothelial precursors, abundantly available mesenchymal stromal cells (MSCs) were reprogrammed into induced-endothelial cells (iECs). We identified cell signaling molecular targets by meta-analysis of microarray datasets. BMP-2 induction leads to the expression of inhibitory Smad 6/7-dependent negative transcriptional regulation of ID1, rendering the latter's reduced binding to TWIST1 during transdifferentiation of WJ-MSC into iEC. TWIST1, in turn, regulates endothelial genes transcription, positively of pro-angiogenic-KDR and negatively, in part, of anti-angiogenic-SFRP4. Twist1 reprogramming enhanced the endothelial lineage commitment of WJ-MSC, increased the vasculogenic potential of reprogrammed EC (rEC). Transplantation of stable TWIST1-rECs into full-thickness type 1 and 2 diabetic-splinted wound healing murine model enhanced the microcirculatory blood flow and accelerated the wound tissue regeneration. An increased or decreased co-localization of GFP with KDR/SFRP4 and CD31 in the regenerated diabetic wound bed with TWIST1 overexpression or silencing (piLenti-TWIST1-shRNA-GFP), respectively further confirmed improved neovascularization. This study depicted the reprogramming of WJ-MSCs into rECs using unique transcription factors, TWIST1 for an efficacious cell transplantation therapy to induce neovascularization–mediated diabetic wound tissue regeneration.

Conceivably, upregulation of myo-inositol oxygenase (MIOX) is associated with altered cellular redox. Its promoter includes oxidant-response elements, and we also discovered binding sites for XBP-1, a transcription factor of ER stress response. Previous studies indicate that MIOX’s upregulation in acute tubular injury is mediated by oxidant and ER stress. Here, we investigated if hyperglycemia leads to accentuation of oxidant and ER stress, while boosting each other’s activities and thereby augmenting tubulo-interstitial injury/fibrosis. We generated MIOX-overexpressing transgenic (MIOX-TG) and -knockout (MIOX-KO) mice. A diabetic state was induced by streptozotocin administration. Also, MIOX-KO were crossbred with Ins2^Akita to generate Ins2^Akita/KO mice. MIOX-TG mice had worsening renal functions with kidneys having increased oxidant/ER stress, as reflected by DCF/DHE staining, perturbed NAD/NADH and GSH/GSSG ratios, increased NOX-4 expression, apoptosis and its executionary molecules, accentuation of TGF-β signaling, Smads and XBP-1 nuclear translocation, expression of GRP78 and XBP1 (ER stress markers) and accelerated tubulo-interstitial fibrosis. These changes were not seen in MIOX-KO mice. Interestingly, such changes were remarkably reduced in Ins2^Akita/KO mice, and likewise in vitro experiments with XBP1-siRNA. These findings suggest that MIOX expression accentuates while its deficiency shields kidneys from tubulo-interstitial injury by dampening oxidant and ER stress, which mutually enhance each other’s activity.

Obesity is a risk factor for type 2 diabetes (T2D), however not all obese individuals develop the disease. In this study, we aimed to investigate the cause of differential insulin secretion capacity of pancreatic islets from T2D and non-T2D (ND) especially obese donors (BMI ≥30 kg/m²). Islets from obese T2D donors had reduced insulin secretion, decreased β-cell exocytosis and higher expression of fatty acid translocase CD36. We tested the hypothesis that CD36 is a key molecule in the reduced insulin secretion capacity. Indeed, CD36 overexpression led to decreased insulin secretion, impaired exocytosis and reduced granule docking. This was accompanied with reduced expression of the exocytotic proteins, SNAP25, STXBP1 and VAMP2, likely because CD36 induced down-regulation of the IRS proteins, suppressed insulin signaling PI3K-AKT pathway and increased nuclear localization of the transcription factor FoxO1. CD36 antibody treatment of the human β-cell line, EndoC-βH1, increased IRS1 and exocytotic protein levels, improved granule docking and enhanced insulin secretion. Our results demonstrate that β-cells from obese T2D donors have dysfunctional exocytosis likely due to an abnormal lipid handling represented by differential CD36 expression. Hence, CD36 could be a key molecule to limit β-cell function in T2D associated with obesity.

Mobilization of hematopoietic stem/progenitor cells (HSPCs) from the bone marrow (BM) is impaired in diabetes. Excess oncostatin M (OSM) produced by M1 macrophages in the diabetic BM signals through p66Shc to induce Cxcl12 in stromal cells and retain HSPCs. BM adipocytes are another source of CXCL12 that blunts mobilization. We tested a strategy of pharmacologic macrophage reprogramming to rescue HSPC mobilization. In vitro, PPAR- activation with pioglitazone switched macrophages from M1 to M2, reduced Osm expression, and prevented transcellular induction of Cxcl12. In diabetic mice, pioglitazone treatment downregulated Osm, p66Shc and Cxcl12 in the hematopoietic BM, restored the effects of granulocyte-colony stimulation factor (G-CSF), and partially rescued HSPC mobilization, but it increased BM adipocytes. Osm deletion recapitulated the effects of pioglitazone on adipogenesis, which was p66Shc-independent, and double knockout of Osm and p66Shc completely rescued HSPC mobilization. In the absence of OSM, BM adipocytes produced less CXCL12, being arguably devoid of HSPC-retaining activity, whereas pioglitazone failed to downregulate Cxcl12 in BM adipocytes. In diabetic patients under pioglitazone therapy, HSPC mobilization after G-CSF was partially rescued. In summary, pioglitazone reprogrammed BM macrophages and suppressed OSM signaling, but sustained Cxcl12 expression by BM adipocytes could limit full recovery of HSPC mobilization.

A failure in self-tolerance leads to autoimmune destruction of pancreatic β-cells and type 1 diabetes (T1D). Low molecular weight dextran sulfate (DS) is a sulfated semi-synthetic polysaccharide with demonstrated cytoprotective and immunomodulatory properties in vitro. However, whether DS can protect pancreatic β-cells, reduce autoimmunity and ameliorate T1D is unknown. Here we report that DS, but not dextran, protects human β-cells against cytokine-mediated cytotoxicity in vitro. DS also protects mitochondrial function and glucose-stimulated insulin secretion and reduces chemokine expression in human islets in a pro-inflammatory environment. Interestingly, daily treatment with DS significantly reduces diabetes incidence in pre-diabetic non-obese diabetic (NOD) mice, and most importantly, reverses diabetes in early-onset diabetic NOD mice. DS decreases β-cell death, enhances islet heparan sulfate (HS)/heparan sulfate proteoglycan (HSPG) expression and preserves β-cell mass and plasma insulin in these mice. DS administration also increases the expression of the inhibitory co-stimulatory molecule programmed death-1 (PD-1) in T-cells, reduces interferon-+ CD4+ and CD8+ T-cells and enhances the number of FoxP3+ cells. Collectively, these studies demonstrate that the action of one single molecule, DS, on β-cell protection, extracellular matrix preservation and immunomodulation can reverse diabetes in NOD mice highlighting its therapeutic potential for the treatment of T1D.

Islet transplantation is an emerging therapy for type 1 diabetes (T1D) and hypoglycaemic unawareness. However, a key challenge for islet transplantation is cellular rejection and the requirement for long-term immunosuppression. In this study we established a diabetic-humanized NOD-scidIL2R^null(NSG) mouse model of T cell mediated human islet-allograft rejection and developed a therapeutic regimen of low-dose recombinant human interleukin2(IL-2) combined with low-dose rapamycin to prolong graft survival. NSG-mice that had received renal-subcapsular human islet-allografts and were transfused with 1x10⁷ of human-spleen-mononuclear-cells (hSPMCs), reconstituted human CD45⁺ cells that were predominantly CD3⁺ T cells and rejected their grafts with a median survival time of 27 days. IL-2 alone (0.3x10⁶ IU/m² or 1x10⁶ IU/m²), or rapamycin alone (0.5-1mg/kg) for 3 weeks did not prolong survival. However, the combination of rapamycin with IL-2 for 3 weeks significantly prolonged human islet-allograft survival. Graft survival was associated with expansion of CD4⁺CD25⁺FOXP3⁺ Tregs and enhanced TGF-β production by CD4⁺ T cells. CD8⁺ T cells showed reduced IFN- production and reduced expression of perforin-1. The combination of IL-2 and rapamycin has the potential to inhibit human islet-allograft rejection by expanding CD4⁺FOXP3⁺ Tregs in vivo and supressing effector cell function, and could be the basis of effective tolerance-based regimens.

Mesencephalic astrocyte-derived neurotrophic factor (MANF) is a neurotrophic factor widely expressed in mammalian tissues, and it exerts critical protective effects on neurons and other cell types in various disease models, such as those for diabetes. However, to date, the expression and roles of MANF in the cornea, with or without diabetic keratopathy (DK), remain unclear. Here, we demonstrate that MANF is abundantly expressed in normal corneal epithelial cells; however, MANF expression was significantly reduced in both unwounded and wounded corneal epithelium in streptozotocin-induced type 1 diabetic C57BL/6 mice. Recombinant human MANF significantly promoted normal and diabetic corneal epithelial wound healing and nerve regeneration. Furthermore, MANF inhibited hyperglycemia-induced endoplasmic reticulum (ER) stress and ER stress–mediated apoptosis. Attenuation of ER stress with 4-phenylbutyric acid (4-PBA) also ameliorated corneal epithelial closure and nerve regeneration. However, the beneficial effects of MANF and 4-PBA were abolished by an Akt inhibitor and Akt-specific small interfering RNA (siRNA). Finally, we reveal that the subconjunctival injection of MANF-specific siRNA prevents corneal epithelial wound healing and nerve regeneration. Our results provide important evidence that hyperglycemia-suppressed MANF expression may contribute to delayed corneal epithelial wound healing and impaired nerve regeneration by increasing ER stress, and MANF may be a useful therapeutic modality for treating DK.

The increasing prevalence of type 2 diabetes poses a major challenge to societies worldwide. Blood-based factors like serum proteins are in contact with every organ in the body to mediate global homeostasis and may thus directly regulate complex processes such as aging and the development of common chronic diseases. We applied a data-driven proteomics approach, measuring serum levels of 4,137 proteins in 5,438 elderly Icelanders and identified 536 proteins associated with prevalent and/or incident type 2 diabetes. We validated a subset of the observed associations in an independent case-control study of type 2 diabetes. These protein associations provide novel biological insights into the molecular mechanisms that are dysregulated prior to and following the onset of type 2 diabetes and can be detected in serum. A bi-directional two-sample Mendelian randomization analysis indicated that serum changes of at least 23 proteins are downstream of the disease or its genetic liability, while 15 proteins were supported as having a causal role in type 2 diabetes.