topic Re: SAS code examples for Query Status in SAS Data Management

SAS code examples for Query Status

doctorxg — Thu, 23 Mar 2017 17:56:51 GMT

Does anybody have sample codes for tracking query status (open,closed, updated, answered etc) for recurring report in a clinical database?

Re: SAS code examples for Query Status

ballardw — Thu, 23 Mar 2017 18:35:32 GMT

Please expand on that question. What is open/close/whatever? A table, a report object? A variable in a data table?

It may help if you have data and specific questions to post some example data, please recode an sensitive variables and provide an example of desired output from that example data. If you have data in a SAS data set there are tools to turn your SAS data into data step code. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: SAS code examples for Query Status

doctorxg — Thu, 23 Mar 2017 19:00:21 GMT

Sorry, just trying to get sas codes examples on tracking clinical data query in a typical clinical database.

Re: SAS code examples for Query Status

TomKari — Thu, 23 Mar 2017 19:50:11 GMT

Well, @ballardw is expressing it exactly right, people need a little more information to go on.

However, here is the hypothetical simplest query that I can imagine, to give you an idea of what they look like:

/* Create a textual format for the status field */

proc format lib=work;

value STf

1 = "open"

2 = "closed"

3 = "updated"

4 = "answered"

;

run;

/* Create some test data */

data ClinicalData;

informat TreatmentDate date9.;

format TreatmentDate yymmdd10. TreatmentStatus STf.;

input TreatmentDate TreatmentStatus;

cards;

20Mar2017 2

20Mar2017 3

20Mar2017 2

21Mar2017 1

21Mar2017 2

21Mar2017 1

21Mar2017 4

22Mar2017 1

22Mar2017 3

22Mar2017 1

run;

/* A couple of sample queries */

/* Get the treatment status for a given date */

proc sql;

select TreatmentStatus, count(*)

from ClinicalData

where TreatmentDate = "21mar2017"d

group by TreatmentStatus

order by TreatmentStatus;

quit;

/* Get the treatment status by date */

proc sql;

select TreatmentDate, TreatmentStatus, count(*)

from ClinicalData

group by TreatmentDate, TreatmentStatus

order by TreatmentDate, TreatmentStatus;

quit;