About DavidBesaev

DavidBesaev · ‎10-15-2018

Hello, @Ronein I change that row and it has worked: set sashelp.cars(where=(origin='tt')); to: set sashelp.cars(where=(origin="&tt")); proc sql noprint; select distinct ORIGIN into :valList separated by '+' from SASHELP.CARS trimmed; quit; %put &valList; /*Asia+Europe+USA*/ %let No_arguments=%sysfunc(countw(%str(&valList.),'+')); %put &No_arguments.; %macro mmacro1; %do i=1 %to &No_arguments.; %let tt=%scan(&valList.,&i.,+); data out_&tt.; set sashelp.cars(where=(origin="&tt")); run; %end; %mend;

DavidBesaev · ‎08-21-2018

@Patrick Not quite, I need like at pic. below. I need it because not all devices correctly display the report in the letter and there is a need to duplicate in the PDF format. Thx for helping!

DavidBesaev · ‎08-17-2018

@Patrick Thank you for answer! Good rule 🙂 One more little question: is it done on the date step? How to put this doc (or pdf) file in the body of the letter in this case, if possible? Like example: data _null_; file outmail to="wenjie_wang@merck.com" subject="Sales Report" attach="c:\reports\Sales Report.doc"; put 'Dear team,'; run;

DavidBesaev · ‎08-15-2018

Hi everyone! How can I duplicate my few reports (proc report) in email body and like attachment pdf? mayby you know some examples? I find only like attachment or in body messege, bot not both together. Thx for help!

DavidBesaev · ‎02-13-2018

Yeap, outlook. I solved this problem by changing the style from noline to snow. It's looks like i can chage it by some parameter at style. But I didn't find. 😞

DavidBesaev · ‎02-13-2018

Hello! I trying to customize my table, but can change border in email. I just need some border like first screenshot. options emailsys=smtp; options emailport=25; options emailauthprotocol=none; filename temp email /*финальная*/ to=(ASD@somemail.com) type='text/html' subject='Отчет Предпочтения новых игроков на сайте' ; options orientation=landscape; ods html body=temp style=noline; ods html text = "Good Morning,"; ods html text = ""; proc print data=work.report_first_game_2 label noobs style(report)={posttext="Рассматриваются не уникальные игроки." }; title1 'Предпочтения новых игроков сайта'; format date nldate20. game_rl game_6_45 nlnum10.; label date="Дата" game_12_24="12/24" game_4_20="4х20" game_5_36="5x36" game_6_36="6x36" game_6_45="6x45" game_matchbol="МатчБол" game_7_49="7x49" game_bonus="БИ" game_duel="Дуэль" game_keno="Кено" game_prikup="Прикуп" game_rapido="Рапидо" game_rl="РЛ" game_top_3="Топ-3" game_zl="ЖЛ" game_zp="ЗП" total="Всего"; var date / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center background=#dbdbdb borderwidth=2pt bordercolor=black] style(head)=[borderwidth=3pt bordercolor=black height=40pt width=60pt TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ]; var game_4_20 game_5_36 game_6_45 game_matchbol game_7_49 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ TEXTALIGN=CENTER background=#ffe4c4 VERTICALALIGN=center width=40pt]; var game_rl game_zl game_6_36 game_zp / style(head)=[width=40pt TEXTALIGN=CENTER background=#98c793 VERTICALALIGN=center] style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ]; var game_duel game_keno game_prikup / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center]; var game_rapido / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ width=44pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center]; var game_top_3 game_12_24 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center]; var game_bonus /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ TEXTALIGN=CENTER width=40pt background=#cda4de VERTICALALIGN=center]; var total / style(data)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ] style(head)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center]; footnote; run; ods _all_ close; In SAS EG it looks like but in email it doesn't change:

DavidBesaev · ‎02-09-2018

Thank you so much for your help, MikeStockstill ! I will try to get to know these sources more closely. So, if we look at my plot of CCC, that good performance will be, if there are more than 4 clusters ( more 2000 points)? Thank you!

DavidBesaev · ‎02-07-2018

Hi! It's my first encounter with the CCC. I'm trying to figure out the outflow model. I am a beginner and met this clustering assessment. Can you explain in simple terms how best to interpret this estimate? I'm not very good at English specialized literature, find SAS TR A-108, but can't understand main point. Thank you!

DavidBesaev · ‎01-23-2018

Thank you very much! Now it work perfectly

DavidBesaev · ‎01-23-2018

Thanks for the reply and help! About the problem: data can either contain or not contain a specific column (for example 'www'). If data contain this coumn - everything is ok, if not - the entire table disappears from the report completely. Then I change in "Define" point Display -> EXCLUSIVE and it works, but there is no lable, only name of the table. proc report data=work.sorttemptablesorted style(column)=[font_style=roman font_width=normal textalign=center fontsize=7pt] style(head)=[foreground=black font_weight=bold font_style=roman fontsize=7pt textalign=center width=100pt background=#afdafc verticalalign=center] missing; by channel; format count_of_com email sms www more_then_1 nlnum10.; column channel count_of_com email sms www more_then_1; define channel / "Канал" order noprint; define count_of_com / "Количество коммуникаций" display style(header)=[width=75pt]; define email / "Игроков с коммуникациями по Email" display style(header)=[width=75pt]; define sms / "Игроков с коммуникациями по SMS" display style(header)=[width=75pt]; define www / "Игроков с коммуникациями по WWW" EXCLUSIVE style(header)=[width=75pt]; define more_then_1 / "Из них получили коммуникацию более чем в одном канале" display style(header)=[width=75pt]; compute before _page_ / center style=[font_weight=bold foreground=black background= #afdafc fontsize=8pt]; pgstr = catx(' ',channel); line pgstr $varying100.; endcomp; run;

DavidBesaev · ‎01-23-2018

I change "display" to "EXCLUSIVE" and it works, BUT label doesn't work. What i can to do?

DavidBesaev · ‎01-23-2018

Hi! Need your help! I have a table, where some columns can be or disappear after TRANSSPLITCOLUMNS, it,s automatic report and if some column are dissapear, then the report is not working correctly. hear example of code: PROC Report DATA=WORK.SORTTempTableSorted style(column)=[font_style=Roman font_width=normal TEXTALIGN=CENTER FONTSIZE=7pt] style(head)=[foreground=black font_weight=bold font_style=Roman FONTSIZE=7pt TEXTALIGN=CENTER width=100pt background=#afdafc VERTICALALIGN=center] missing; BY CHANNEL; options label; label channel="Канал" COUNT_OF_COM="Количество коммуникаций" EMAIL="Игроков с коммуникациями по Email" SMS="Игроков с коммуникациями по SMS" WWW="Игроков с коммуникациями по WWW" MORE_THEN_1 = "Из них получили коммуникацию более чем в одном канале"; format COUNT_OF_COM EMAIL SMS WWW MORE_THEN_1 nlnum10.; column channel COUNT_OF_COM EMAIL SMS WWW MORE_THEN_1 ; DEFINE CHANNEL / order noprint; DEFINE COUNT_OF_COM / display style(header)=[width=75pt] ; DEFINE EMAIL / display style(header)=[width=75pt] ; DEFINE SMS / display style(header)=[width=75pt] ; DEFINE WWW / display style(header)=[width=75pt] ; DEFINE MORE_THEN_1 / display style(header)=[width=75pt] ; compute before _page_ / center style=[font_weight=bold foreground=black background= #afdafc FONTSIZE=8pt]; pgstr = catx(' ',channel); line pgstr $varying100.; endcomp; run; Can I add something in the code below with no column printed the report without the column, as in proc print?

DavidBesaev · ‎11-29-2017

It works, if "min1" will be before "total" and add define for min1 as display! Thank you! proc report data=work.norper nowd; columns min1 total maxtotal Mintotal meantotal ; define total / display format=nlnum10.; define min1 / display format=nlnum10.; compute total; if total=min1 then call define (_col_,'style','style={foreground=green font_weight=bold font_size=14pt}'); endcomp; quit;

DavidBesaev · ‎11-29-2017

Hi, thx for your answer! It doesn't change color anywhere, if i write: compute total; if total = 5907 then call define (_row_,'style','style={foreground=green font_weight=bold font_size=14pt}'); endcomp; it works, but if I want to compare the columns, nothing happens. How do I compare the values of the columns line by line in compute step? Thank you!

DavidBesaev · ‎11-29-2017

Hello, everyone! I need to find the maximum and minimum values in the lines and highlight them in different colors, how is this best done? I can not compare two columns in compute function. proc report data=work.newtemp nowd; columns total maxtotal Mintotal meantotal min1; define total / order format=nlnum10.; compute total; if total = min1 then call define (_col_,'style','style={foreground=green font_weight=bold font_size=14pt}'); endcomp; quit; Obs TOTAL mintotal maxtotal meantotal min1 2 7046 5907 8421 6937.71 6937.71 3 6071 5907 8421 6937.71 6071.00 4 5907 5907 8421 6937.71 5907.00 5 7094 5907 8421 6937.71 6937.71 6 7910 5907 8421 6937.71 6937.71 7 6115 5907 8421 6937.71 6115.00

Online Status	Offline
Date Last Visited	‎10-15-2018 08:48 AM

Re: split one data set into many

Re: Duplicate table in email letter in attachment as PDF

Re: Duplicate table in email letter in attachment as PDF

Duplicate table in email letter in attachment as PDF

Re: How i can change borders in table in email with html

How i can change borders in table in email with html

Re: Interpreting CCC values in a Cluster Analysis

Interpreting CCC values in a Cluster Analysis

Re: PROC Report with The column that may disappear

Re: PROC Report with The column that may disappear

Re: How i can change borders in table in email with html

Re: PROC Report with The column that may disappear

Re: Change max and min cell color in a row in proc report

Re: split one data set into many

Re: Duplicate table in email letter in attachment as PDF

Re: Duplicate table in email letter in attachment as PDF

Duplicate table in email letter in attachment as PDF

Re: How i can change borders in table in email with html

How i can change borders in table in email with html

Re: Interpreting CCC values in a Cluster Analysis

Interpreting CCC values in a Cluster Analysis

Re: PROC Report with The column that may disappear

Re: PROC Report with The column that may disappear

Re: PROC Report with The column that may disappear

PROC Report with The column that may disappear

Re: Change max and min cell color in a row in proc report

Re: Change max and min cell color in a row in proc report

Change max and min cell color in a row in proc report