[PDF] Efficient Implementation and Applications of PROC

PATCH • CREATE proc http url="https://clinicaltrialsapi cancer gov/v1/terms? Authors: Joseph Henry and Chris Hemedinger from SAS •'POST' method

6 avr 2020 · Form parameters are normally sent as a POST request with the content-type application/x-www-form-urlencoded Like query parameters, the content is typically

[PDF] REST at Ease with SAS® - SAS Support

15 jan 2016 · put "username=&username nrstr(&password)=&pwd"; run; proc http method=" POST" url="http:// SASLogon server:7980/SASLogon/v1/tickets"

[PDF] Efficient implementation and applications of PROC - LexJansen

locate and import files from SharePoint to SAS are explored, followed by a look at two Out is the output file destination for the response from the HTTP request

[PDF] Efficient Implementation and Applications of PROC - LexJansen

PATCH • CREATE proc http url="https://clinicaltrialsapi cancer gov/v1/terms? Authors: Joseph Henry and Chris Hemedinger from SAS •'POST' method

[PDF] Web Scraping in SAS - Squarespace

The METHOD= option indicates what type of request method PROC HTTP should send to the website identified in the URL= option While there are several HTTP

[PDF] PROC SOAP, PROC HTTP und der ganze REST - SAS-Wiki

Das Transportprotokoll, das für die Übermittlung von Request und Response verwendet wird, ist HTTP, das Protokoll des World Wide Web – daher also auch die

[PDF] Using the REDCap API for Data Import and Export Look for

SAS macro******** macro _transfr(_typ=0,_url=,_ct=,_in=,_out=,_hdrout=); proc http in=&_in out=&_out headerout=&_hdrout url="&_url" method="post"

[PDF] Retrieving Survey Data using the Qualtrics REST API with SAS

the HTTP procedure first introduced in SAS® 9 2, SAS has the ability to interface directly or REST-based API protocol, which uses HTTP requests to post, read and modify data Qualtrics API response from the PROC HTTP get data request

[PDF] Import sas Dataset to Redcap

proc http in = in out = out headerout = status url = myurl (location of redcap database api) method = 'post'; run; /*now read csv file into SAS*/ proc import

[PDF] eg, SOAP and REST - PharmaSUG

paper will also show how SAS programmers can create a SOAP request using 10 will show how to call REST using PROC HTTP and save CSV response files

[PDF] sas proc http sharepoint

[PDF] sas proc https

[PDF] sas proc json write values

[PDF] sas proc sql create table as select

[PDF] sas proc sql create table join

[PDF] sas proc sql create table like

[PDF] sas proc sql create table replace

[PDF] sas proc sql create table syntax

[PDF] sas proc sql format

[PDF] sas proc sql; create table as select example

[PDF] sas retain array

[PDF] sas sum(of array name * )

[PDF] sascrunch arrays

[PDF] sassen cities in a world economy pdf

[PDF] sassen the global city new york london tokyo

Efficient Implementation and Applications of PROC HTTP in Analysis and ReportingSimon Todd

Project Background

SAS CodeMicrosoft Graph® APIMicrosoft Sharepoint®Icons made by Freepik & Eucalypfromwww.flaticon.comRequestResponse(e.g. SAS Datasets)

PROC HTTP

Method Verb Examples:•PUT•POST•PATCH•CREATEprochttpurl="https://clinicaltrialsapi.cancer.gov/v1/terms?term=metastatic&term_type=official_title"method="GET"out=outfile;run;

PROC HTTP

prochttpurl="https://clinicaltrialsapi.cancer.gov/v1/terms?term=metastatic&term_type=official_title"method="GET"out=outfile;run;%* Set up libname for JSON file output *;libnamenciterms json fileref=outfile;

PROC HTTP

Utility Access Macros

•%get_token•Acquire access token•%refresh_token•Uses Refresh token to update access token in case of expiry•%process_token_file•Set token values to macro variablesAuthors: Joseph Henry and Chris Hemedinger from SAS

Locating and Importing a file

•ID values used to build full URL•Return all groups user has access to•'GET' methodhttps://graph.microsoft.com/v1.0/groupshttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid.

Locating and Importing a file

•ID values used to build full URL•Return all groups user has access to•'GET' methodhttps://graph.microsoft.com/v1.0/groupshttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid.

Locating and Importing a file

•ID values used to build full URL•Query strings -OData System Query Options •Prevent 'overfetching'https://graph.microsoft.com/v1.0/groups?$filter=displayname eq 'Example Project'&$select=DisplayName,IDhttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid.

Locating and Importing a file

•ID values used to build full URL•'Content' action parameter•'GET' methodhttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid.https://graph.microsoft.com/v1.0/groups/Ab321C789d/drive/items/M09s6sa5/content

File Import Application

•Validation Tracker -Titles and Footnotes•Automation of key locations:•SAS_EXECFILENAME•SAS_EXECFILEPATH•Instant update timing•Files not locked when open for manual edit

File Export Process

•'PUT' method•'Content' action parameter•Relative path URL ':' •SAS Datasets exported to work library as xlsx•Only works for files <4MB•'413 -Payload Too Large'•FSIZE functionhttps://graph.microsoft.com/v1.0/groups/&groupid./drive/root:/example.xlsx:/content

File Export Process

File Export Application

•Raw data issue reports•Can be shared automatically with non-organisation team members •'Invite' action parameter•'POST' method •Read/Write access control•'423 -Locked'https://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid./invite

File Export Application

•Raw data issue reports•Can be shared automatically with non-organisation team members •'Invite' action parameter •'POST' method•Read/Write access control•'423 -Locked'https://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid./invite

Workbook manipulation

•Retrieve and edit specific cell content•Not restricted by sheets open for editing•'PersistChanges' header•'POST' method•'CreateSession' action parameter •Session ID key value for subsequent requests•'RefreshSession' action parameterhttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid./workbook/createSession

Workbook manipulation

•Sheet name or ID required for URL•'Range(address='A1:B2')' action parameter•'PATCH' method•Value for cell update as inputhttps://graph.microsoft.com/v1.0/groups/&groupid./drive/items/&fileid./workbook/worksheets/&sheetname./range(address='A1')

Workbook manipulation

Workbook manipulation application

•Validation tracker can be updated automatically•Instant date updates•Log and compare summaries•No chance for human error•Determining correct row to edit

Workbook manipulation application

•Validation tracker can be updated automatically•Instant date updates•Log and compare summaries•No chance for human error•Determining correct row to edit:•Import and subset•Workbook: 'UsedRange'•Excel function: Match

Workbook manipulation application

Conclusion

•Minor manual setup•Huge potential for automation of processes•Access token security considerations•Alternative API and cloud storage providers

Questions

Simon ToddPhastarUnit 2, 2a Bollo LaneChiswick, London, W4 5LEEmail: simon.todd@phastar.comWeb: www.phastar.com

quotesdbs_dbs17.pdfusesText_23

[PDF] [PDF] Efficient Implementation and Applications of PROC - LexJansen

Project Background

PROC HTTP

PROC HTTP

PROC HTTP

PROC HTTP

PROC HTTP

PROC HTTP

PROC HTTP

Utility Access Macros

Locating and Importing a file

Locating and Importing a file

Locating and Importing a file

Locating and Importing a file

File Import Application

File Export Process

File Export Process

File Export Process

File Export Application

File Export Application

Workbook manipulation

Workbook manipulation

Workbook manipulation

Workbook manipulation

Workbook manipulation

Workbook manipulation

Workbook manipulation application

Workbook manipulation application

Workbook manipulation application

Workbook manipulation application

Conclusion

Questions