About Mikey03

SASKiwi · ‎08-01-2018

The easiest way to fix this issue is to transform the data before loading into VA LASR. You can run the code I've provided in SAS Studio which is available in SAS VA. PROC TRANSPOSE also requires SAS code so I suggest you stick with the code in my example.

Madelyn_SAS · ‎05-24-2018

There are a couple of notes that discuss that message. For an intermittent issue, it is usually the network connection. http://support.sas.com/kb/53/054.html It can also be that the midtier cannot communicate with the port used by the Operating System Services. http://support.sas.com/kb/61/198.html

FredrikE · ‎05-21-2018

Maybe a stored process can help you: http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#p0x3cm87j971dun11jt9al9uquz5.htm Note in 7.4 but should be similiar in 7.3 //Fredrik

SASKiwi · ‎05-11-2018

In VA 7.4 the List Table object has an Enable Sorting check box. If you sort your columns in the order you want using Cntrl mouse click on the column headers to select more than one column at a time I think you will be able to get the sort order you want - you then save the report. By leaving the Enable Sorting check box un-ticked then you can't change the sort order in the Report Viewer.

SASKiwi · ‎04-30-2018

@Mikey03 - I didn't see any content shrinkage when I tested this in 7.4 - all the text was perfectly readable, so I suspect it is fixed in this release. Do you have any plans to upgrade?

Mikey03 · ‎04-30-2018

Thanks Anna. I'm still interested if people have had any success with creating a patient profile report from within SAS VA and what approach they have taken.

Jay54 · ‎03-10-2018

Use VALUESHINT on the XAXIS statement. This still keeps the axis range to what comes from the data. The tick values are displayed as you specify in the VALUES option, without increasing or decreasing the axis range.

Mikey03 · ‎03-09-2018

Thanks for the overlay idea. It sounds like it may get around the requirement to denormalise datasets. In one of my graphs I have a dataset that is used to create reflines - the number of lines can be anything between 0 through 15 per plot. So currently i am joining this refline dataset with the "main" dataset and have 15 denormalised columns (one for each refline.) It sounds that using this overlay approach I dont need to join the datasets. I will look into your 2 techniques - hope they arent too difficult to follow!

Online Status	Offline
Date Last Visited	‎08-06-2018 09:26 AM

Re: How to normalise a dataset in SAS VA 7.3

How to normalise a dataset in SAS VA 7.3

Scheduling a data query "run now" issue

Using ODS in VA 7.3

Re: Sorting a table across multiple columns

Sorting a table across multiple columns

Re: Clinical Patient Profile reports

Re: Split a dataset row across 2 lines

Re: Clinical Patient Profile reports

Clinical Patient Profile reports

Re: Clinical Patient Profile reports

Re: Clinical Patient Profile reports

Re: How to normalise a dataset in SAS VA 7.3

Re: Scheduling a data query "run now" issue

Re: Using ODS in VA 7.3

Re: Sorting a table across multiple columns

Re: Split a dataset row across 2 lines

Re: Clinical Patient Profile reports

Re: Sgplot: controlling the xaxis with macro variables

Re: Graphic visualisations across multi-datasets