Hi, This link can help you. http://blogs.sas.com/content/sgf/2016/06/21/need-an-aggregation-of-an-aggregation-use-visual-data-builder-to-pre-aggregate-your-data/ If you schedule your query, it is automatized. I hope it is useful for you. ... View more

Thanks For response , However i am looking into SAS VA. To make it more explanatory. I am using Hierarchy in line /Time series chart Just take an example Have hierarchy as "Country->Seasons->Fruits"  on Y axis and Year on X axis. So if we club the percentage for each year (may be just by seeing the graph) that should make 100% irrespective on which hierarchy (Category) we choosing and irrespective of their Hierarchy structure. Hope i am clear. ... View more

thankyou .. It worked  ... View more

You can try from below sample, its working for me :    proc sql; CREATE TABLE t1 AS select * from abc; run;   proc sql; CREATE TABLE t2 AS select * from def; run;   proc sql; CREATE TABLE t3 AS select * from ghi; run;   proc sql; CREATE TABLE t4 AS select * from jkl; run;   ods TAGSETS.EXCELXP body=outbox rs=none style=styles.HTMLBlue; ods TAGSETS.EXCELXP text="test sample text";        ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="abc");      proc print data=t1 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="def");      proc print data=t2 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="ghi");      proc print data=t3 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="jkl");      proc print data=t4 noobs;      run; ods TAGSETS.EXCELXP close;   filename outbox email            to='abc@abc.com'            from='def@def.com'            type='application/vnd.ms-excel'           subject='Sample First Program';   Creating excel sheet with 4 different tabs   ... View more

Thanks a lot.. Sorry for mess .. ... View more

Thanks ,I Identified the case. ... View more

I'm assuming you actually used semicolons to end your statements, and you merged using a MERGE statement rather than a SET statement.   The basic problem is that you have a common variable, SUBJECT, in both data sets.  There are a couple of ways to deal with that.  To ignore all SUBJECT values in one data set, you could just drop it:   data final; merge new (drop=subject in=a) new1; by name class; if a; run;   I would assume you are merging by both variables, and not just by NAME.   The problem gets a little more complex if you need to compare the SUBJECT values in the two data sets, to see which you want to use.   Good luck. ... View more

If you have a later version of SAS try DBMS=XLSX However there's no absolute way to specify the variable type while using Excel so you may need to implement fixes after the initial import.  ... View more

I'm not sure what you are asking exactly - but I think you have a horizontal container that you want to automatically advance.  If that is your question, then the product does not do that.  I suggest you request the feature in the SAS Ballot.   However, if you are just trying to figure out a workaround that lets the user know how to navigate your report better then I suggest you try a Stack Container and place the controls in the upper left (or somewhere the user is more likely to notice them.  You can also play with colors to make the buttons stand out more.   Here's an example I built in VA 7.3 using the SASHELP.STOCKS table: ... View more

If you are unable to change your apperance to modern, it is possible that your admin has set a sitewide property to force the use of classic. In that case, you cannot change your individual preference. ... View more

Hi,   The ODS output statement needs to be before the procedure which creates the object.  The proc format does not create objects, hence the onewayfreq is not found.  This code should work: data new; set sashelp.class; umra=put(age,$2.); run; ods listing close; proc format; value $age low-<15 = 'child' 16-< 30 = 'adult'; run; ods trace on; ods output OneWayFreqs=app; proc freq data=new; tables _char_; format umra $age.; run; ods trace off; ods output close; ... View more

For the analysis of seasonality I suggest to look into PROC X11 and PROC X13 (formerly X12) which are part of SAS/ETS. They offer a wide range of analysis and detection methods for seasonality in your data. The online help contains some examples for that. e.g. http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_x11_examples01.htm For smoothing of your data you might want to take a look at the EXPAND procedure of SAS/ETS. Regards, Gerhard ... View more

For the analysis of seasonality I suggest to look into PROC X11 and PROC X13 (formerly X12) which are part of SAS/ETS. They offer a wide range of analysis and detection methods for seasonality in your data. The online help contains some examples for that. e.g. http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_x11_examples01.htm For smoothing of your data you might want to take a look at the EXPAND procedure of SAS/ETS. Regards, Gerhard ... View more