sas: sum of values ​​in the same column,

Considering the following HIV bank:

ID  DT_INI  DT_FIN  CD4 VL  ART TEMPO

1 9673 2018-01-25 2018-04-09 0 2 0 74
2 9673 2018-04-09 2018-08-28 0 0 0 141
3 15049 2010-08-26 2010-12-22 0 2 0 118
4 15049 12-22-2010 2011-04-19 0 0 0 118
5 15049 2011-04-19 2012-09-12 0 0 1 512
6 15049 2012-09-12 2013-07-10 0 1 0 301
7 15049 2013-07-10 2014-04-09 0 1 0 273
8 15049 2014-04-09 2014-09-10 0 1 0 154
9 15049 2014-09-10 2015-03-11 0 1 1 182
10 15049 2015-03-11 2015-10-14 0 1 1 217
11 15049 2015-10-14 2016-08-10 0 1 1 301
12 15049 2016-08-10 2017-03-08 0 1 0 210
13 15049 2017-03-08 2017-09-13 0 0 0 189

I need to transform the intervals that have the same values ​​as the CD4, VL and ART variables into a single interval and then add the respective times (TP). But the intervals must be in the same chronological sequence. In the case of this bank, I would add the ranges of lines 6, 7 and 8 in one, but I could not join the range of line 12 because it has the same values ​​as the variables CD4, VL and ART are out of time sequence . . In this database, other ranges that could be joined in a single range would be lines 9,10 and 11. Through SAS I could access the script:
Process type; data = HIV; by DT_INI ID
HIV1 date; establish HIV; by DT_INI ID; if ID = delay1 (ID) and CD4 = delay (CD4) and VL = delay (VL) and ART = delay (ART), then TP1 = sum (TP, delay (TP)); otherwise, TP1 = TP; RUN;

But this script does not work for all situations.

Could someone suggest me a command that I am missing? ABS and thanks

Cable for SFF-8087 to SAS drives

I have a lot of 3.5 "SAS hard drives that I deleted from one of my raid cabinets that has a backplane and I want to reuse those disks with a Perc H700 controller on a PC that is a complete tower system so it doesn't have a plane later on it.But I want to reuse the drives there.Any recommendations for a cable that would go from SFF-8087 to 4 powered SAS connectors? I thought the disconnect cables I had were what I needed, but they were only 8087 connectors to SATA .

Thank you.

JR

zfs: maximum bandwidth of the old 3GB / s SAS JBOD

I just acquired a JBOD that was manufactured in 2011, it has 60 SATA 2 TB 7.2k disks but uses SATA to SAS adapters on each disk. There are two IO modules in the cabinet, each module offers 4 SFF-8088 ports, the speed of these SAS ports is 3Gb / s. It was connected to a controller box equipped with 2 SAS3160E (SAS1068E) HBA LBA cards, executing some type of software incursion. When connected, the LSI HBA cards present 120 disks to the controller (but in reality only 60 disks, for example, sdcc and sddj are the same disk). I removed the software raid and managed to run CentOS 7 and zfs on it. If I run two sas cables from an HBA card to two IO modules, the write bandwidth is 1100MB / s. If I run two sas cables from two HBA cards to two IO modules, the write bandwidth is 1445 MB / s.

I read that the SAS1068E LSI has poor performance issues. Is it possible to maximize bandwidth using a somewhat newer controller box (the servers used are so cheap anyway)? I am looking at the DELL R620 1U box, equipped with an SAS9207-8e HBA LSI card. The R620 has PCIe-3.0 slots and the SAS 9207-8e is 6 Gb / s, will I get a better bandwidth?

Suggestions appreciated. Thank you.

[DE/LT/MD/NL/UK/USA] KVM VPS, SAS and SSD storage reliable, from 2 EUR / m

Benefit from our long experience and reliability! For more than 19 years in the market, today we are among the most professional suppliers in Europe. With our new KVM virtual servers we offer you a cost-effective, scalable and reliable alternative to dedicated servers.

All virtual servers include:

– Secure and reliable KVM virtualization
– Only first class enterprise class hardware
– High performance ZFS storage system with enterprise grade SAS and SSD drives
– Server locations: Duesseldorf (Germany), Chișinău (Moldova), Amsterdam (Netherlands) and Los Angeles (USA), Siauliai (Lithuania)
– 1 IPv4 address and 10 native IPv6 addresses included
– 24×7 premium support
– Easy to use control panel (developed internally)

Mirrors

– Amsterdam, Holland
– Chișinău, Moldova
– Dallas, USA UU.
– Duesseldorf, Germany
– London, United Kingdom
– Los Angeles, USA UU.
– Siauliai, Lithuania

VPS with SAS storage

UltraKVM-15

– 512 MB of RAM
– 1 Core CPU
– 15 GB of storage
– 1 TB monthly transfer
– Contract term: 6 months.

2.00 euros / m. incl. VAT (1.68 euros / m. Without VAT *)

(More information)

UltraKVM-30

– 1.5 GB of RAM
– 1 Core CPU
– 30 GB of storage
– 1 TB monthly transfer
– Contract term: 6 months.

3.00 euros / m. incl. VAT (2.52 euros / m. Without VAT *)

(More information)

UltraKVM-50

– 3 GB of RAM
– 2 CPU cores
– 50 GB of storage
– Monthly transfer of 2 TB
– Term of the contract: 3 months.

6.00 euros / m. incl. VAT (5.04 euros / m. Without VAT *)

(More information)

UltraKVM-75

– 4 GB of RAM
– 4 CPU cores
– 75 GB of storage
– Monthly transfer of 2 TB
– Contract term: 1 month

10.00 euros / m. incl. VAT (10.08 euros / m. Without VAT *)

(More information)

UltraKVM-200

– 4 GB of RAM
– 4 CPU cores
– 200 GB of storage
– 5 TB monthly transfer
– Contract term: 1 month

15.00 euros / m. incl. VAT (16.81 euros / m. Without VAT *)

(More information)

UltraKVM-250

– 8 GB of RAM
– 4 CPU cores
– 250 GB of storage
– 5 TB monthly transfer
– Contract term: 1 month

20.00 euros / m. incl. VAT (25.21 euros / m. Without VAT *)

(More information)

VPS with SSD storage

Cloud-30

– 2 GB of RAM
– 2 CPU cores
– 30 GB of all flash storage
– Monthly transfer volume of 2TB
– Contract term: 1 month

4.50 euros / m. incl. VAT (3.78 euros / m. Without VAT *)

(More information)

Cloud-50

– 4 GB of RAM
– 2 CPU cores
– 50 GB of all flash storage
– Monthly transfer volume of 2TB
– Contract term: 1 month

9.00 euros / m. incl. VAT (7.56 euros / m. Without VAT *)

(More information)

Cloud-100

– 8 GB of RAM
– 4 CPU cores
– 100 GB of all flash storage
– Monthly transfer volume of 5 TB
– Contract term: 1 month

18.00 euros / m. incl. VAT (15.12 euros / m. Without VAT *)

Cloud-200

– 16 GB of RAM
– 4 CPU cores
– 200 GB of all flash storage
– Monthly transfer volume of 5 TB
– Contract term: 1 month

29.00 euros / m. incl. VAT (24.37 euros / m. Without VAT *)

(More information)

Cloud-300

– 32 GB of RAM
– 4 CPU cores
– 300 GB of all flash storage
– Monthly transfer volume of 5 TB
– Contract term: 1 month

49.00 euros / m. incl. VAT (32.77 euros / m. Without VAT *)

(More information)

Cloud-500

– 32 GB of RAM
– 6 CPU cores
– 500 GB of all flash storage
– Monthly transfer volume of 5 TB
– Contract term: 1 month

69.00 euros / m. incl. VAT (41.18 euros / m. Without VAT *)

(More information)

* Prices include 19% VAT. If you are domiciled outside the EU or have a valid VAT ID, you do not have to pay VAT.

If you have any questions, feel free to email us sales@providerservice.com.

vmware esxi: SAS Expander p410 card is not detected on the supermicro server

I am trying to update the sas p410 expander but every time I try to detect the expander card the only thing shown in lsscsi -g | grep HP is HP Storage

Any ideas on how to make it detect the expansion card or update the firmware?

I tried to put the expansion and raid card on my old server, but it still shows the same result. Any help is appreciated thanks!

12gb 7.2k rpm SAS vs 6gb 10k rpm sas

Which is faster? … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1782817&goto=newpost

hmac: is it safe to share an Azure SAS token with an untrusted client?

We need to host files in Azure Blob Store and allow end users access to their generated "declarations" (pdf) for a short period of time.

We are considering achieving this by generating a short-lived SAS token and sending it to the user (this user can be anyone on the Internet, therefore, "untrustworthy").

Are SAS tokens safe enough? They are HMAC-SHA256 tokens, so I am not sure if a person could try to discover our genuine secret account key by brute force (that is, generate tokens with random keys until a key matches the hmac-sha256 signature).

SAS Online – Review 2019

SAS Online is one of the most experienced discount brokers in India. Incorporated in 2013 as the discount broker arm of South Asian Stock Limited, SAS Online has grown at an accelerated pace by acquiring new customers at high speed.

As of August 2019, they have more than 300,000 customers spread across India with a daily turnover of more than 10000cr + representing more than 1% of the total market share. One of the main reasons for this growth is its focus on providing low-intermediation and high-quality trading and customer service platforms that exceed the expectations of its customers.

Why invest with SAS online?
SAS Online is one of the most reliable online discount brokers in India, as it offers its customers an easy account opening, good trading software, cheap brokerage plans and good customer service.

They participate in the deposit with NSDL and allow their clients to trade cash, intraday, futures and options, currencies and raw materials in NSE, BSE and MCX.

The company originally started as a team of 3 people and gradually grew in terms of working clients and professionals. They have a centralized office in Delhi and do not have branches, therefore they take advantage of technology and save costs on real estate, human resources and other operating costs.

Online trading platforms
Trading platforms have become a necessity for brokers and their clients these days and it is known that SAS Online develops reliable trading platforms thanks to its team of developers.

SAS Online provides the ALPHA platform to its customers for commercial purposes. ALPHA is a brand new Omnesys NEST trading platform that is known for its reliable performance among merchants in India. Here is a look at the features it has to offer:

ALFA merchant
Alpha Trader is the desktop or software based version of the Alpha Platform. It comes in an executable .exe file that must be downloaded to your desktop to begin operating. These are some of the features of this platform:

Alpha trader

  • This platform has superior graphics that include more than 80 technical indicators to help you find patterns.
  • Alpha Trader offers power, flexibility, reliability and speed to meet a merchant's demand.
  • You can browse through quotes and quotes BSE, NSE and MCX using a single window.
  • You can configure scripting alerts that notify you of any emerging opportunity by comparing your ideas with real market data in no time.

ALFA web

Alpha Web is a web-based trading platform for fast web operations. You do not need to install any software to access it, just click on the URL and enter your login credentials to start operating. These are some of its features:

Alpha web

  • You can use keyboard shortcuts with which you are familiar to execute orders or navigate the platform.
  • The availability of keyboard shortcuts allows customers to instantly make sales and purchases of securities whenever they want.
  • You can easily customize the features of various graphics with Alpha Web, with more than 80 technical indicators.
  • Set price alerts, buy / sell scripts in one click, add scripts in the watch list, different types of orders and many more advanced features for traders and investors.

Click here to start using your Web Alpha

To know more about SAS Online, click here

sas: Dell R640 + NVMe drives

I have a Dell R640 server with two Dell SAS 600GB 10K drives and I am trying to add a Samsung DCT 983 NVMe drive.

I can plug in the unit and the power lights are one, however, IDRAC9 does not detect it.

Is it possible to combine 2 SAS drives with the NVMe drive on the same R640 server?

Are there any combination of settings I should use (such as AHCI vs RAID, UEFI, etc.)?

Available KVM, snapshots and hourly backups of RAID 10 SAS available


About CLOUD

A small introduction about the company, CloudCone, LLC is a cloud hosting service provider that provides fully managed hourly virtual private cloud servers, AnyCast DNS and high performance dedicated servers as our core services. We offer a stack of collaborating cloud services, providing a reliable infrastructure for your online presence.
Together with an international internal support team and DevOps engineers, we provide 24/7 live priority support for all our customers. The following offers are special launch that are available while stocks last. As always, we listen to all the comments provided and continually try to improve our services to better match the general demands of our customers.


We maintain an internal control and billing platform for end users with an easy-to-use user interface that includes some robust features.

– Implement virtual machines
– Start / restart / shutdown virtual machines
– Reinstall the operating system with one click
– Upload / download individual resources in one click
– VNC control panel
– SSH keys
– Reset root passwords
– rDNS update
– Snapshots
– Backups
– Managed firewall
– Free AnyCast DNS management (up to 3 domains)
– Deep server administration – https://cloudcone.com/cloud-view/
– Quick start in recovery mode
– REST API – https://api.cloudcone.com


ULT-1Y

1 vCPU core
512 MB of RAM
20 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
1 TB bandwidth
Free AnyCast DNS
$ 24.02 / year (billed $ 0.00269 / HR)
Order here: https://app.cloudcone.com/compute/476/create

ULT-2Y

1 vCPU core
1 GB of RAM
25 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
1 TB bandwidth
Free AnyCast DNS
$ 35.98 / year (billed $ 0.00403 / HR)
Order here: https://app.cloudcone.com/compute/477/create

ULT-3Y

2 vCPU Core
1 GB of RAM
50 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
2 TB bandwidth
Free AnyCast DNS
$ 42.05 / year (billed $ 0.00471 / HR)
Order here: https://app.cloudcone.com/compute/478/create

ULT-4Y

2 vCPU Core
2 GB of RAM
70 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
2 TB bandwidth
Free AnyCast DNS
$ 65.98 / year (billed $ 0.00739 / HR)
Order here: https://app.cloudcone.com/compute/479/create

ULT-5Y

2 vCPU Core
3 GB of RAM
80 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
3 TB bandwidth
Free AnyCast DNS
$ 84.01 / year (billed $ 0.00941 / HR)
Order here: https://app.cloudcone.com/compute/480/create

ULT-6Y

3 vCPU core
4 GB of RAM
100 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
3 TB bandwidth
Free AnyCast DNS
$ 89.99 / year (billed $ 0.01008 / HR)
Order here: https://app.cloudcone.com/compute/481/create

ULT-7Y

4 vCPU Core
8 GB of RAM
200 GB RAID 10 SAS
1 x IPv4 and 3 x IPv6
3 TB bandwidth
Free AnyCast DNS
$ 209.99 / year (billed $ 0.02352 / HR)
Order here: https://app.cloudcone.com/compute/482/create


Knowledgebase

Available Accessories

  • Content delivery network: $ 0.045 per GB (45 bursts in 6 quotas)
  • Additional IPv4: $ 1 per month
  • Automatic backups: $ 35% of the monthly server fee
  • Snapshots $ 0.09 per GB per month

Included Gifts

Terms and Terms

Cloudconne Net

Net Features

  • 200 Tier 1 multiple transit providers such as Amazon, Google Fiber, Japan Telecom, Etisalat, Hutchison, TATA Communications and China Telecom
  • BGP4 Best-Path Routing
  • Custom routing policies per client
  • Latency-based routing optimization
  • Redundant connections and divergent route fiber optic connections to operators that include Level3, Cogent, Savvis, ACE, TATA, China Unicom
  • Automatic fault detection and redirection

For any questions, go to cloudcone.com and visit a chat
Thank you,
CloudCone, LLC