10-11-2013 05:03 AM
Sorry that I always trouble myself in interacting with Excel and come to back to you guys. Here I've another issue and dont know if it is possible to resolve.
I've a regular report sharing to various clients which has got about few numeric variables(values with amounts, so needed to be numeric) and for some reasons I had to generate this as XML file rather than Excel(because excel cant serve my pupose to load data into multible tabs with needed formats like WRAP the grouped observations).
So here I've a certain requirement where we got to block with showing up of amounts for specific observations(records) and thereby my clients are requesting me to put a text like 'BLOCKED' on such numeric fields:smileyshocked:. I never knew that we programmers do need to think to this extent while developing technologies . ...might be we need to think about another new datatype.. Opportunity!! I doubt if it is really possible but anyways if someone has some ideas pls do share to help me.
Also, it will be greatly appreciated if you suggest me the best way to convert XML files back into Excel files without disturbing the formats like Word WRAP, MERGE, etc..
10-11-2013 09:01 AM
10-11-2013 07:55 AM
Something like perhaps.
10-11-2013 08:10 AM
Thanks, But I got to use conditional formatting based on the values of one or more other variables rather than from the values of the same variable on which the format is applied. I think this should be done someway in the COMPUTE BLOCK..
10-11-2013 08:23 AM
Yes how about you post some sample data then we don't have to guess what you want.:smileyshocked:
10-11-2013 08:41 AM
Oops, sorry for the confusion..:smileymischief: Here is an ex. as below
PROC REPORT DATA=sashelp.shoes;
DEFINE region / GROUP;
DEFINE product / GROUP;
DEFINE sales / DISPLAY FORMAT=dollar10.2;
For the output, I would like to block the amounts of SALES wherever REGION is either 'Africa' or 'Canada' and PRODUCT is 'Slippers', so that SALES value is shown as BLOCKED.
Thanks for your support.
Message was edited by: Pawan Kumar
10-11-2013 09:01 AM