Hi,   I've been trying to deploy SAS Viya Pay as you go to Azure for almost a month without success.   Regardless of what options and settings, I get the following message "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.  I've now got a screeen full of unsuccessful deployments.   I see others have had similar issues, but even after following Rich Main's youtube video https://youtu.be/kHYaj5qiPow I am unable to successully deploy.  I've spoken with SAS tech support and they say that they don't provide support to Viya on Azure and I should speak with Microsoft or post here.  The doc links on other posting don't open for me so I can't find any solutions here that work for me.   I have a pay as you go subscription to Azure, so not the trial version. Also I'm using a SSH public key stored in Azure - not sure if that is the problem. I'm in South East Australia and I believe that deployment isn't possible at this location, so I've tried several others, such as East and West USA, but still no luck.   Appreciate it if anyone has successfully deployed and can share settings or any way to get beyond the error.  Are there any prerequisites or post creation steps that I can use? Do I need to set up a VM in Azure first to host Viya? ... View more

Hi   I have a large SAS EG project that creates, reads and joins 12 tables from a variety of sources.  Occasionally one of the tables that is joined in the final SQL stage has zero rows, but normally all tables have at least one row.  When SAS SQL sees the table with zero rows it throws an error stating that tables must have more than zero rows - but I am unable to control for that with the basic input tables.   I'm thinking to insert a dummy row into the problematic table if there are zero rows, to allow for the project to run through to completion.  This would enable the join to occur without actually generating any additional rows of data.     I have two questions that I would appreciate assistance with: 1. is there a better way to prevent this error? 2. how should i place a dummy row into a table (whether or not it has existing data)?   Thanks for any suggestions.   Doug ... View more

I have created output for a customer that has (in very simple form): id1 vara varb varc vard vare id2 varf varg varh. id1 has a numeric value of, say 42, id2 will always have a value of id1+1 (i.e. 43 in this case). vara-varh are character values.   i now need to split each row into based on the values of id1 and id2 to be: id vara varb varc vard vare varf varg varh 42 ........ 43........   I've been trying to read id1 and then say if id2 =id1+1 then output but I still don't get the split right. I've been thinking how to force SAS to stop reading the line after vare then to drop down to the next line but don't know how to do that.   I don't want to go back to square 1 and start the job again as i think the customer may want the data in the original format once they test it.   Any assistance or tips appreciated.   Gordon ... View more

I'm a little bit stuck with a request from my boss who wants to know how long it takes a customer to spend 75% of a credit voucher.  The customer can use the voucher many times for many variously priced goods but she wants the time period that it takes to meet or exceed 75% of the value. Vouchers can be for any amount but are normally in the non-rounded hundreds to a few thousands (i.e $543.00 may be a value).   I was planning to firstly get the value of each voucher, then to begin adding up the purchases until the sum is equal to or exceeds 75% of the voucher value, then taking the date when that happens and subtracting the issue date of the voucher (or the date of the voucher's first use).  Not sure how to go about the coding yet but conceptually I'm looking to try something like (plain text version as opposed to an attempt to code): eg, for a voucher that is $1000.00,   array(date_of_purchase) _temp_; do I = 1 to (total number of purchases on a voucher); running_value=_value +purchase_value do until (running_value =1000 *0.75); Number_purchases=I; duration=date_of_purchase(I) - voucher_issue_date; end; end;   The data are structured in SAS with each row having a customer id, date of purchase, value of purchase and an indicator if the purchase is from a voucher (as well as the goods, quantity etc.)     Has anyone done anything similar that they could please share with me?  My boss knows that this is likely on the verge of my skill set and that I'm seeking help to get this done ("it's a learning experience!"). I'm not sure if this is a simple process that I am over complicating.   Thanks   Gordon     ... View more