Hi All,   Can I implement  a data query in sas va which may run for 2 hours or more ? or should I use EG? ... View more

Hi All,   I have created a cross tab with eight character cloumns and one measure(price) . I need to create an additional measure as subtotal price ratio[ price/subtotal of price within first two column cobination,country/region)  based on the first two character columns(country&region).I know percent of subtotal option in cross tab;but i want to display subtotal for first two columns only[dont want subtotal for each of the eight column level) and also need to use that to calcualte the price ratio. In excel, this is pretty much possible, but i cannot doany option to do this in sas va......   Please provide me a solution for this  as I am stuck with simple stuff from excel perspective...   Regards, JG     ... View more

Hi  Folks,   I made a button  bar to receive input to display top 5 /top 10 customers and I am forced to use text parameter since my button bar selection contains 'TOP 5' 'TOP 10' etc.I am using this parameter directly in rank filter and rank filter allows only numeric parameter.Could you please provide me a solution for this,.   Do you know how to create a numeric paramter from the text parameter or is there any way I can use numeric paramter in button bar which has Text selections('TOP 5').   Please provide your valuable thoughts on this.   Regards, J George ... View more

    Hello Folks,   I need to give some constant values(say, 12 13 14 151 6) to a button bar.I dont have any dataitem ... Please provide your valuable thoughts on this.   Regards, Jithu ... View more

ifrs_id report_date ead ecl period_id crr_stage_identifier stage_movement  X1 20161231 8 77 current period 2 stage 1 to stage 2 X2 20161231 6 55 current period 1 stage 3 to stage 1 X1 20161130 6 45 previous period 1   X2 20161130 4 34 previous period 3     Hi folks,   I have all historial reords in a single lasr dataset as shown above ;I also got period_id to show period data in addtion to report_date.The credit rating field (crr_stage_identifier),a numeric item needs to be compared with previous period record and create the calculated character field, stage_movement with message as shown in the data above.   For example, IFRS_ID,X1 moved from credit rating stage 1 in previous period  to stage 2 in current period and hence stage_movement got value as 'stage 1 to stage 2'. same way, I would like to create caluated fields for ead and ecl differences from previous period. ... View more

Hi  SAS VA experts,   I  am working for a bank  and currrently created a number of reports and explorations in Developemnt/UAT  folder (LASR) and now I need to copy them to production along with changes to the datasource names(same dataset with production names). I am doing this manually now ( copying to production folder and linking to production data source) and ought to do 100's of reports and explorations.  I would like to do this via  program /script and automate this copying process.Could you please help and let me know your vaulable thoughts on this.   thanks JP ... View more

Hi Folks,   I recently started using SAS VA and found that I can  delete parent folder only after deleting all sub folders within it. Is there any shortcut to delete the folder along with sub folders in one click..   Regards, J George ... View more