Hi All! I am running a very simple PROC HTTP to download an Excel spreadsheet from Google docs, and then a subsequent import step to load the data into SAS. I get a "401 Unauthorized" note in my log for the PROC HTTP, and the imported file contains the following:   Allow Google Sheets access to your necessary cookies You won't be able to access this content if necessary cookies are turned off Learn moreAllow cookies Sign in to your Google Account You must sign in to access this content Sign in Can't access your Google Account We can't sign you in when the necessary cookies are turned off Learn more   So I am obviously able to reach the site, but then need to sign in. I have searched and searched on the web for information on how to handle this, but have just been going down rabbit holes. Here is my code:   filename _httpin temp;   proc http  url="https://docs.google.com/spreadsheets/d/1sFshkC35_cY2qwinv1hNHoFjC7u965yhiHV9ga8t9lk/edit?pli=1#gid=503427334" method="get"  out=_httpin WEBUSERNAME="my email" WEBPASSWORD='my google password'; debug level=3; run;   proc import file=_httpin out=test dbms=csv replace; getnames=no; datarow=1; run;   I am able to access the file via my browser, and when I submit the GET method in Postman I get the same output. Please can someone who has successfully downloaded Google docs files provide some assistance?   Thanks! ... View more

Hi All I am trying to POST issues to Data Remediation using the REST API, but keep getting 500 Internal Server Error. I am just trying with one issue at the moment just to get the logging sorted out, and then I will start looking at logging multiple issues. Here is my SAS Enterprise Guide code and I have attached the input file. Please could you assist if possible?       filename in "/sas/batch/sasdata/dataremediation/tables/json_manual.txt"; filename out "/sas/batch/sasdata/dataremediation/tables/json_out.txt";   proc http in=in out=out url="https://server:port/SASDataRemediation/rest/groups"     method="POST"     ct="application/json; charset=utf-8" /* webauthdomain="LinuxAuth"*/ webusername="heididt" webpassword="{SAS002}66B564224EE630732E6388E0395887EC37DCE27D300D953A"       ; run; ... View more

Hi All I am brand new to Data Remediation and need some help with getting started. Our design is as follows (steps 1-3 have already been developed, I need help with the following steps): 1. Data Quality assessment is run to identify any records that violate business rules 2. These records are written to a SQL table and surfaced in a view (v_AllRuleViolations) 3. SAS code is run to derive suggested remediation values for these rule violations, and the relevant data is written to a SQL table (Remediation) 4. Violation records, together with the suggested remediation value, are extracted from the Remediation table and sent to SAS Data Remediation 5. Workflow is instantiated: Data Steward accepts or rejects suggested remediation Accept: Remediation table updated (FinalRemediation=SuggestedRemediation and ProcessedDttm populated with current date and time) SQL script is invoked to apply final remediation to source data Reject: (Optional) Data Steward enters alternative remediation: populates Remediation table (AlternativeRemediation) Enters reason for rejection: populates Rejection table (Rejector = username, RejectionReason = reason entered, ValueRejected=SUGGESTED and RejectedDttm=current date and time) Workflow advances to next task: Alerts data owner Data owner may accept or reject either the suggested or alternative remediation, suggest another remediation or reject all remediation suggestions Accept suggested remediation Populates Remediation table (FinalRemediation = SuggestedRemediation, ProcessedDttm = current date and time) Invokes SQL script to apply Remediation.FinalRemediation to source data Accept alternative remediation Populates Remediation table (FinalRemediation = AlternativeRemediation, ProcessedDttm = current date and time) Invokes SQL script to apply Remediation.FinalRemediation to source data Enter alternative remediation Populates Remediation table (FinalRemediation = newly supplied value) Invokes SQL script to apply FinalRemediation to source data Reject Populates RemediationRejection table (Rejector = username, RejectionReason = reason entered, ValueRejected=ALL and RejectedDttm=current date and time) Manual intervention will be required – process tbc If anyone is able and willing to assist me, please could you let me know? Unfortunately there is currently no Data Remediation training available, and the documentation does not provide enough guidance w.r.t. the integration between the assessment and remediation.   Thanks! ... View more