BookmarkSubscribeRSS Feed
arslan
Calcite | Level 5

Hi All,

I have a problem with show/hide rows in proc report by stored process.

I want to move the row below and above in the proc report. (like the following example )

http://www.pengoworks.com/workshop/jquery/tablesorter/tablesorter.htm

does anybody have any ideas, documents or code?

thanks a lot,

Celal

3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  It looks to me like you don't really want to show/hide rows in PROC REPORT. To me, it looks like you want to add functionality in the browser, by implementing some type of Javascript code to expand and contract the rows once the output is opened in the browser. By default, neither PROC REPORT nor ODS will do this for you.

  This is going to be a question for Tech Support. Whether your JavaScipt will work will depend on the client application that is going to execute the stored process -and- you will probably have to customize the data because normally, you could not "stack" one variable value on top of another variable value without data manipulation of the data. You might even have to generate your own HTML, but I'm not sure, which is why I suggested Tech Support.

cynthia

arslan
Calcite | Level 5

HI,

you are right. it 's the Javascript code. But i don't know how to use Javascript code(hide/show code) in Proc Report. I don' have a lot of experience in this area.

i need some materials about hide/show code in proc report.

thanks,

Celal

Cynthia_sas
SAS Super FREQ

Hi:

  I don't believe you need help about "hide/show code" in PROC REPORT -- I don't know what you mean by "hide/show code" anyway. As I explained in my earlier post: "To me, it looks like you want to add functionality in the browser, by implementing some type of Javascript code to expand and contract the rows once the output is opened in the browser. By default, neither PROC REPORT nor ODS will do this for you." Javascript "belongs" to a web browser. Web browser output is created with ODS HTML or HTML-based destinations. If you want to add JavaScript into your HTML output, you need to

1) know what JavaScript you want to add

2) figure out WHERE the JavaScript needs to go in the HTML

3) figure out HOW to get the JavaScript where you need it to go (in the <HEAD> section of the HTML page; in the <TABLE>, etc, etc.)

  These Tech Support examples show a few ways to insert JavaScript into ODS HTML output:

http://support.sas.com/kb/24/068.html

http://support.sas.com/kb/23/381.html

http://support.sas.com/kb/23/645.html

http://support.sas.com/kb/23/327.html

  If you need more specific help with this question, then you may want to open a track with Tech Support. Since you have posted this in the Stored Process Forum, you will have to be very careful with your Stored Process output. There are only a few client applications that use HTML output from Stored Processes on the BI Platform. Tech Support can collect system information, client information and other information from you and make sure that you are on the right track.

cynthia

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1837 views
  • 0 likes
  • 2 in conversation