SAS Proc Report in SAS 4.3 and studio

[ramak]

Dear Sir / Madam,

I want to arrange the defined across variable headers in order manually in proc report but by default it has come in alaphabatic order. 

also i want to interlink the report like eg. when i click a state in a proc reort summary it will show the districts summary under the state and when I click on to district it will be show the citys summarys under district in sas 4.3 and sas studio programming. 

Please help me sir.

[Cynthia_sas]

Hi:
SAS Enterprise Guide is version 4.3, 5.1, 6.1 or 7.1. They all work with various version of SAS. The most current version of SAS is SAS 9. So the chances are good that you are using Enterprise Guide 4.3 with SAS 9 (probably 9.2, 9.3 or 9.4) at your company.

I don't remember the List Report Wizard from Enterprise Guide 4.3. I know that you could use ACROSS variables, but I'm not sure whether they surfaced the ability to change ORDER= on the DEFINE statement.

At any rate, you cannot change the across variable headers manually -- you have to use ORDER= to control the order. But you might have to do that using PROC REPORT code with EG 4.3.

As for your other question about "interlinking" the report -- clicking in a state and then going to a district, we call that "drill down" and one way to do it with PROC REPORT will require code to do -- either with a user-defined format to link the drill-down file to the summary report or using a CALL DEFINE technique as shown in this Tech Support note: http://support.sas.com/kb/25/394.html.

cynthia

[ramak]

this support note is not opening.

[ballardw]

---

@ramak wrote:

this support note is not opening.

---

The link probably came with the period from Cynthia's post. Delete it in the browser address bar or copy and paste to the browser without the period.

[Cynthia_sas]

oops, sorry, who cares about grammatically correct sentences, anyway?
Here's the link:
http://support.sas.com/kb/25/394.html

cynthia