You may put in a dataset and email as a table in html format. See sample code below: options emailhost=(xxxxxxx); filename myemail EMAIL TO=(&&MAIL&i) CONTENT_TYPE="text/html" subject="MAGAZA BUYUME ORANLARI "; ODS HTML BODY=myemail; ods html text='<div align="Left">Hi All,</div> <BR>'; ods html text='<div align="Left">Data as below </div> <BR>'; PROC PRINT DATA=YOURDATASETNUMBER1; RUN ; PROC PRINT DATA=YOURDATASETNUMBER2; RUN ; ods html text='<BR><div align="Left"> Any text </div> <BR>'; ods html text='<div align="Left">Any text </div> <BR>'; ods html text='<div align="Left">Any text </div> <BR>'; ODS HTML CLOSE;   ... View more

Hi,   Are you using SAS Studio? or SAS Visual Analytics?   If you are using SAS Studio, code should be the same as SAS Base. Could you please share how your data looks like and the desired outcome? ... View more

Hi  You can put inside the %BQUOTE function   %let a=%BQUOTE(abcd,efgh@hijk) ; %let b=%index(&a,c) ; %PUT &b. &a.; OUTPUT: 76 %let a=%BQUOTE(abcd,efgh@hijk) ; 77 78 %let b=%index(&a,c) ; 79 80 %PUT &b. &a.; 3 abcd,efgh@hijk ... View more

Hi JJP1,   Do you mean all your data looks like this: Year Month 2019 01 2018 02 2019 03   But you dont have a day Variable? Is your intention to get the full 12 months regardless of the date? E.g., today is Nov 25, 2019,  you want to include From Dec 01, 2018 to today? Since you don't have day variable, you can default to 01 all the days.   Then read as yyyymmdd, then use intck to count 12 months from today   data ck ; year=2019 ; month=9 ; new_month = COMPRESS(PUT(year,4.)||PUT(month,z2.)||"01") ; FORMAT inputasdate date9. ; inputasdate = INPUT(new_month,yymmdd8.) ; _12months = intck("months",inputasdate, today()) ; IF 0<= _12months <=12 ; RUN ;   Please take note that the year and month, I suppose they are numbers Please let us know if we get your issue correctly?     ... View more

Hi,   For the condition filtering, go to the filter tab. Once you apply filter, your measures will be filtered accordingly prior creating calculated values.   For the count of observations, you may use the function ByGroup (sourcevariablename) to create a newvariable in the Calculated Items of Aggregated Measure then add this new variable in the Data Role.   Hope this helps ... View more