Hello all, Thanks again for the great code on creating a butterfly chart. Here's the basic code I'm using but now I'd like to enhance it to include both the value in parentheses below the percentage. (see picture).   Thanks for your great help! proc format; picture posval low-<0='00000%' (prefix='-') 0='9%' 0<-high='00000%'; run; data have; call streaminit(123); do date='01jan2022'd to '20jan2022'd; value=rand('integer',-100,100); group=ifc(value>0,'pos_diff','neg_diff'); output; end; format date date9. value posval.; run; proc sgplot data=have; hbarparm category=date response=value/group=group datalabel=value GROUPDISPLAY=CLUSTER DATALABELFITPOLICY=INSIDEPREFERRED ; keylegend /title=''; yaxis label=''; xaxis label=''; run; ... View more

Hi there, I am trying to create a butterfly graph and it's almost there but not yet. I need to add the values of the bars and convert everything to percentages. I would also like to add 2 vertical dashed lines at -20% and + 20%.    I've done what I can so can someone get me a bit further?   Thank you so much!   Paula   proc format; picture posval low-<0='00000%' (prefix='-') 0='9%' 0<-high='00000%'; run; data sales; set sales; if pct_diff < 0 then neg_diff = pct_diff; if pct_diff >= 0 then pos_diff = pct_diff; zero = 0; run; title1 '% Change of Sales between Dates'; proc sgplot data=sales; format pct_diff posval.; hbarparm category=rundt response=neg_diff / datalabel=pct_diff datalabelattrs=(size=10); hbarparm category=rundt response=pos_diff / datalabel=pct_diff datalabelattrs=(size=10); xaxis values=(-10 to 10 by .25) display=(nolabel) grid; yaxis display=(nolabel); run; ... View more

Hello all, I have a Linux file location where we store our output files for processing. What I want to do is look into that Linux location and list ALL the .txt files in there and read them in as separate SAS datasets. The core files names are the same WEEKLY_SALES_yyyymmdd with the yyyymmdd varying with no patters (sometimes weekly, sometimes daily depending on the needs).    How can I list all those .txt files and import them into SAS? There could be as many as 150 .txt files in the folder.   After I assign the libref, then what?   libname sales '/sasdata/data/UX/sales/';   Thank you   Paula ... View more

Hello all, Sorry for the confusing title -- not sure how to phrase it. In the code below, I'm looking into a Netezza table (Data step won't work) and deleting current period records if they exist. The issue is, how to represent the value of 202212 as ym_id is a character/text field (don't ask me, I didn't create the database).   If I hard-code '202212' then it works I need to keep &period as 202212 since it's used throughout the program. If I use &period then I get ERROR: Expression using equals (=) has components that are of different data types. If I use &qperiod it resolves to '202212' but then I get the error  ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, *, +, -, ALL, ANY, BTRIM, CALCULATED, CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE, USER Would anyone help me please with this macro issue?   Thank you   /******** CODE IN QUESTION **************/   %let period = 202212; %let qperiod = %str(')&period%str(');   proc sql noerrorstop; delete from core.mytable where ym_id = &period; quit;          ... View more

Hello, I'm trying to grab a date from one table, convert it to a macro, and use it extract data from other tables. The issue is the date extracted (&asof) and using it in the 2nd sql. The table variable (proc_date) uses data in the format 2022-12-15. I've tried some other solutions but nothing seems to work.   Any and all suggestions are appreciated.   Thank you   Paula   proc sql;       connect to odbc as odbc(dsn='mine');          create table dates as              select * from connection to odbc                    (select date as asof                               from myperfectdatabase                               where month = 12);           disconnect from odbc;                  select asof into :asofdt from dates; quit;     %put &asofdt;    /* date retrieved shows as 15dec2022 */   proc sql;       connect to odbc as odbc(dsn='mine');          create table otherdata as              select * from connection to odbc                    (select var1, var2, var3                               from myotherperfectdatabase                               where proc_date = &asofdt );    /*<--- the issue is using the macro here. orig data in 2022-12-15 format */           disconnect from odbc;  quit;         ... View more

Hello all, Thanks to you, I "almost" have my answer for emailing embedded results. But I have two questions on formats:   1. How do I get rid of the box around the title? This shows up in the e-mail but not the actual HTML output. 2. General PROC REPORT question (but this in particular) -- how do I automatically create the proc report outputs so it looks like below (with the same alignment) but doesn't have the extra width AND doesn't wrap titles? See screen shot below.   Thank you. All ya'all are the best!   Paula     ... View more

Hello, I created a report using PROC REPORT and was able to email the results (via SAS). Now my manager wants me to embed the report into an e-mail (so as not to open a file). Is that possible? If so -- how? Can anyone point me to any papers with examples?   Thank you   Paula ... View more

Hello, I'm trying to insert a footer on a pdf that consists of a base line followed by the logo, Page X of Y, and run date. I am having a problem with centering the Page X of Y and the run date on the page and aligning the text within the size of the logo (sample below). Here's my code. What can I correct to get what I want?   Thank you     options papersize = (8.5in 11in)   orientation = portrait   leftmargin = .5in   rightmargin = .5in   topmargin = .25in   bottommargin = .25in   nodate   nonumber; ods escapechar="^"; title; footnote; ods pdf file=&pdffile nogtitle notoc startpage = never;    title1 "^{style [just = r                    width = 100pct                    cellheight = 12pt                    font_size = 10pt                     color = white                     font_face = 'MyFont'                     background = &MyBlue.] Data Review}"; title2 "^{style [just = r                       width = 100pct                       font_size = 9pt                          cellheight = 11pt                       color = white                           fontstyle = italic                       font_face = 'MyFont'                          background = &MyBlue.] For Production Period: &sysdate().}"; footnote1 "^{style [just = r                       width = 100pct                           cellheight = 2pt                            background = &MyBlue.] }"; footnote2 j = l "^{style [preimage= '/sasdata/MyLogoWhite.png'                                   font_face= 'MyFont'                                  font_size = 7pt ] Page ^{thispage} of ^{lastpage} Date run: %sysfunc(today(),mmddyy10.) }"; proc print data = summary (obs = 5); run;   title; footnote; ods pdf close;     ... View more

Hello all, I'm hoping you might be able to help me with the following issue. I'm trying to recreate a report that resembles pg 5 of Microsoft Word - 313-2009.docx (lexjansen.com) (The Power to Show: Ad Hoc Reporting, Custom Invoices, and Form Letters by Daniel O’Connor, SAS Institute Inc.)   What's getting me are: 1. I'm using SAS EG with output to PDF so I must use GRIDDED layout 2. I can't get the heading to work for me. I get both but the image is huge and I want the text to be along side, to the right of, the image. I'm shooting for about a .75in header height. How do I make the image fit a smaller area?   Could someone point me to a similar paper that uses GRIDDED layout with examples (my brain is fried looking at this)? I've seen many with absolute but I'm not sure what to do to convert to GRIDDED. Also, here's just my heading code that's not working. Can someone please help?   Thank you so very much!   options orientation = portrait papersize = letter nodate nonumber topmargin = .001in bottommargin = .001in leftmargin = .001in rightmargin = .001in; ods noproctitle; ods escapechar = "^"; title; footnote; ods pdf file="/sasdata/team_files/testing.pdf" ; ods layout start columns = 2; ods text = "^{style[preimage='/sasdata/team_files/logo_on_blue.jpg']}"; ods text = "^{style[fontsize=20pt just=left fontweight=bold] Departmental Information}"; ods layout end; ods pdf close;     Paula     ... View more