Use proc format with cntlout -option to save the format definition to a dataset, than modify the dataset an use proc format with cntlin to update the format definition. Having a backup of the catalog is recommended.
proc format cntlout=work.format_def;
select $nypark;
run;
/* update dataset work.format_def */
proc format cntlin=work.format_def;
run;
... View more
In 7.3, measures cannot be on the rows in a crosstab. The ability to put measures on the rows is planned for 8.2, although features for software in development are not guaranteed.
... View more
Hi Ole.
You are not the first to struggle with this issue, but this cannot be done directly in VA Designer / Explorer 7.3, but it can be done in VA 8.2. See more at https://www.sas.com/va
If you want this, then you need to prepare your data before VA, just like the other answer suggested. Either in SAS og VA data builder.
/ Steffen
... View more
