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}" />

Over the past couple of weeks leading up to Spring Training, MLB.com went around the horn to examine each area of the Rays' 2019 roster. The final installment focuses on Tampa Bay's outfield and designated hitters.

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.

After a pair of seasons -- and a World Series title -- with the Astros, Rays pitcher Charlie Morton is confident that his new team has what in takes to make a postseason run in 2019.

When Tyler Glasnow heard the news that the Rays were signing Charlie Morton, he couldn't help but get even more excited for the 2019 season.

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.

As Emilio Pagan enters his first Spring Training with the Rays, he's looking to prove that he can perform well against hitters on either side of the plate.

After a disappointing 2018 season, Jake Faria is looking to show that last season isn't reflective of the type of pitcher he is.

Tyler Glasnow is hoping to build off a positive 2018, but his delivery is going to look a little different this season.

On this opening week of Spring Training, all 30 Major League teams have one thing in common: optimism. Here's an optimism cheat sheet for each of them.

Sulfur is essential for biological processes such as amino acid biogenesis, iron–sulfur cluster formation, and redox homeostasis. To acquire sulfur-containing compounds from the environment, bacteria have evolved high-affinity uptake systems, predominant among which is the ABC transporter family. Theses membrane-embedded enzymes use the energy of ATP hydrolysis for transmembrane transport of a wide range of biomolecules against concentration gradients. Three distinct bacterial ABC import systems of sulfur-containing compounds have been identified, but the molecular details of their transport mechanism remain poorly characterized. Here we provide results from a biochemical analysis of the purified Escherichia coli YecSC-FliY cysteine/cystine import system. We found that the substrate-binding protein FliY binds l-cystine, l-cysteine, and d-cysteine with micromolar affinities. However, binding of the l- and d-enantiomers induced different conformational changes of FliY, where the l- enantiomer–substrate-binding protein complex interacted more efficiently with the YecSC transporter. YecSC had low basal ATPase activity that was moderately stimulated by apo FliY, more strongly by d-cysteine–bound FliY, and maximally by l-cysteine– or l-cystine–bound FliY. However, at high FliY concentrations, YecSC reached maximal ATPase rates independent of the presence or nature of the substrate. These results suggest that FliY exists in a conformational equilibrium between an open, unliganded form that does not bind to the YecSC transporter and closed, unliganded and closed, liganded forms that bind this transporter with variable affinities but equally stimulate its ATPase activity. These findings differ from previous observations for similar ABC transporters, highlighting the extent of mechanistic diversity in this large protein family.

Type 2 diabetes mellitus (T2DM) is characterized by impaired glucose-stimulated insulin secretion and increased peripheral insulin resistance. Unremitting endoplasmic reticulum (ER) stress can lead to beta-cell apoptosis and has been linked to type 2 diabetes. Although many studies have attempted to link ER stress and T2DM, the specific effects of ER stress on beta-cell function remain incompletely understood. To determine the interrelationship between ER stress and beta-cell function, here we treated insulin-secreting INS-1(832/13) cells or isolated mouse islets with the ER stress–inducer tunicamycin (TM). TM induced ER stress as expected, as evidenced by activation of the unfolded protein response. Beta cells treated with TM also exhibited concomitant alterations in their electrical activity and cytosolic free Ca2+ oscillations. As ER stress is known to reduce ER Ca2+ levels, we tested the hypothesis that the observed increase in Ca2+ oscillations occurred because of reduced ER Ca2+ levels and, in turn, increased store-operated Ca2+ entry. TM-induced cytosolic Ca2+ and membrane electrical oscillations were acutely inhibited by YM58483, which blocks store-operated Ca2+ channels. Significantly, TM-treated cells secreted increased insulin under conditions normally associated with only minimal release, e.g. 5 mm glucose, and YM58483 blocked this secretion. Taken together, these results support a critical role for ER Ca2+ depletion–activated Ca2+ current in mediating Ca2+-induced insulin secretion in response to ER stress.

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.

Pathogenic bacteria of the genera Mycobacterium and Corynebacterium cause severe human diseases such as tuberculosis (Mycobacterium tuberculosis) and diphtheria (Corynebacterium diphtheriae). The cells of these species are surrounded by protective cell walls rich in long-chain mycolic acids. These fatty acids are conjugated to the disaccharide trehalose on the cytoplasmic side of the bacterial cell membrane. They are then transported across the membrane to the periplasm where they act as donors for other reactions. We have previously shown that transient acetylation of the glycolipid trehalose monohydroxycorynomycolate (hTMCM) enables its efficient transport to the periplasm in Corynebacterium glutamicum and that acetylation is mediated by the membrane protein TmaT. Here, we show that a putative methyltransferase, encoded at the same genetic locus as TmaT, is also required for optimal hTMCM transport. Deletion of the C. glutamicum gene NCgl2764 (Rv0224c in M. tuberculosis) abolished acetyltrehalose monocorynomycolate (AcTMCM) synthesis, leading to accumulation of hTMCM in the inner membrane and delaying its conversion to trehalose dihydroxycorynomycolate (h2TDCM). Complementation with NCgl2764 normalized turnover of hTMCM to h2TDCM. In contrast, complementation with NCgl2764 derivatives mutated at residues essential for methyltransferase activity failed to rectify the defect, suggesting that NCgl2764/Rv0224c encodes a methyltransferase, designated here as MtrP. Comprehensive analyses of the individual mtrP and tmaT mutants and of a double mutant revealed strikingly similar changes across several lipid classes compared with WT bacteria. These findings indicate that both MtrP and TmaT have nonredundant roles in regulating AcTMCM synthesis, revealing additional complexity in the regulation of trehalose mycolate transport in the Corynebacterineae.

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.

Nonalcoholic fatty liver disease (NAFLD) is a risk factor for type 2 diabetes (T2D). We aimed to identify the peripheral blood DNA methylation signature of hepatic fat. We conducted epigenome-wide association studies of hepatic fat in 3,400 European ancestry (EA) participants and in 401 Hispanic ancestry and 724 African ancestry participants from four population-based cohort studies. Hepatic fat was measured using computed tomography or ultrasound imaging and DNA methylation was assessed at >400,000 cytosine-guanine dinucleotides (CpGs) in whole blood or CD14+ monocytes using a commercial array. We identified 22 CpGs associated with hepatic fat in EA participants at a false discovery rate <0.05 (corresponding P = 6.9 x 10^–6) with replication at Bonferroni-corrected P < 8.6 x 10^–4. Mendelian randomization analyses supported the association of hypomethylation of cg08309687 (LINC00649) with NAFLD (P = 2.5 x 10^–4). Hypomethylation of the same CpG was also associated with risk for new-onset T2D (P = 0.005). Our study demonstrates that a peripheral blood–derived DNA methylation signature is robustly associated with hepatic fat accumulation. The hepatic fat–associated CpGs may represent attractive biomarkers for T2D. Future studies are warranted to explore mechanisms and to examine DNA methylation signatures of NAFLD across racial/ethnic groups.

Diabetic retinopathy (DR) is diagnosed clinically by directly viewing retinal vascular changes during ophthalmoscopy or through fundus photographs. However, electroretinography (ERG) studies in humans and rodents have revealed that retinal dysfunction is demonstrable prior to the development of visible vascular defects. Specifically, delays in dark-adapted ERG oscillatory potential (OP) implicit times in response to dim flash stimuli (<-1.8 log cd·s/m²) occur prior to clinically-recognized diabetic retinopathy. Animal studies suggest that retinal dopamine deficiency underlies these early functional deficits. Here, we randomized persons with diabetes, without clinically detectable retinopathy, to treatment with either low or high dose Sinemet (levodopa plus carbidopa) for 2 weeks and compared their ERG findings with those of control (no DM) subjects. We assessed dim flash stimulated OP delays using a novel hand-held ERG system (RETeval) at baseline, 2 and 4 weeks. RETeval recordings identified significant OP implicit-time delays in persons with diabetes without retinopathy compared to age-matched controls (p<0.001). After two weeks of Sinemet treatment, OP implicit times were restored to control values, and these improvements persisted even after a two-week washout. We conclude that detection of dim flash OP delays could provide early detection of DR, and that Sinemet treatment may reverse retinal dysfunction.

Despite considerable progress, development of glucose-responsive insulins (GRI) still largely depends on empirical knowledge and tedious experimentation – especially on rodents. To assist the rational design and clinical translation of the therapeutic, we present a Pharmacokinetic Algorithm Mapping GRI Efficacies in Rodents and Humans (PAMERAH), built upon our previous human model. PAMERAH constitutes a framework for predicting the therapeutic efficacy of a GRI candidate from its user-specified mechanism of action, kinetics, and dosage, which we show is accurate when checked against data from experiments and literature. Results from simulated glucose clamps also agree quantitatively with recent GRI publications. We demonstrate that the model can be used to explore the vast number of permutations constituting the GRI parameter space, and thereby identify the optimal design ranges that yield desired performance. A design guide aside, PAMERAH more importantly can facilitate GRI’s clinical translation by connecting each candidate’s efficacies in rats, mice, and humans. The resultant mapping helps find GRIs which appear promising in rodents but underperform in humans (i.e. false-positives). Conversely, it also allows for the discovery of optimal human GRI dynamics not captured by experiments on a rodent population (false-negatives). We condense such information onto a translatability grid as a straightforward, visual guide for GRI development.

Amylin, a pancreatic hormone and neuropeptide, acts principally in the hindbrain to decrease food intake and has been recently shown to act as a neurotrophic factor to control the development of AP->NTS and ARC->PVN axonal fiber outgrowth. Amylin is also able to activate ERK signaling specifically in POMC neurons independently of leptin. To investigate the physiological role of amylin signaling in POMC neurons, the core component of the amylin receptor, calcitonin receptor (CTR) was depleted from POMC neurons using an inducible mouse model. The loss of CTR in POMC neurons leads to increased body weight gain, increased adiposity, and glucose intolerance in male knockout mice, characterized by decreased energy expenditure (EE) and decreased expression of uncoupling protein 1 (UCP1) in brown adipose tissue (BAT). Furthermore, a decreased spontaneous locomotor activity and absent thermogenic reaction to the application of the amylin receptor agonist were observed in male and female mice. Together, these results show a significant physiological impact of amylin/calcitonin signaling in CTR-POMC neurons on energy metabolism and demonstrate the need for sex-specific approaches in obesity research and potentially treatment.

Lipid droplets (LDs) are frequently increased when excessive lipid accumulation leads to cellular dysfunction. Distinct from mouse beta cells, LDs are prominent in human beta cells, however, the regulation of LD mobilization (lipolysis) in human beta cells remains unclear. We found that glucose increases lipolysis in non-diabetic human islets, but not in type 2 diabetic (T2D) islets, indicating dysregulation of lipolysis in T2D islets. Silencing adipose triglyceride lipase (ATGL) in human pseudoislets (shATGL) increased triglycerides, and the number and size of LDs indicating that ATGL is the principal lipase in human beta cells. In shATGL pseudoislets, biphasic glucose-stimulated insulin secretion (GSIS) and insulin secretion to IBMX and KCl were all reduced without altering oxygen consumption rate compared with scramble control. Like human islets, INS1 cells showed visible LDs, glucose responsive lipolysis, and impairment of GSIS after ATGL silencing. ATGL deficient INS1 cells and human pseudoislets showed reduced Stx1a, a key SNARE component. Proteasomal degradation of Stx1a was accelerated likely through reduced palmitoylation in ATGL deficient INS1 cells. Therefore, ATGL is responsible for LD mobilization in human beta cells and supports insulin secretion by stabilizing Stx1a. The dysregulated lipolysis may contribute to LD accumulation and beta cell dysfunction in T2D islets.