Hi All, I want to create a folder ('07 - 2018 JUL' which is dynamic based on the previous month) and a sub folder ('Personal') at the same time under the location 'C:\Temp\2018 - 2019'. I figured out the folder part, but don't know how to create a sub folder. Can any one help please. Thanks. My ultimate folder hierarchy will be  'C:\Temp\2018 - 2019\07 - 2018 JUL\Personal'   DATA _NULL_; rootdir='C:\Temp\2018 - 2019'; today=today(); lastmonth=intnx('month',today,-1); dir1=catx(' ',put(month(lastmonth),z2.),'-',year(lastmonth),UPCASE(put(lastmonth,monname3.))); newdir1=dcreate(dir1,rootdir); RUN;         ... View more

Hi All, I am stuck with highlighting some cells of a column based on a comparison of cells of another column. In the following code I tried to use CALL DEFINE so that it highlights when column _c2_ is bigger than _c3_. Can someone help me please.   PROC SQL; CREATE TABLE sale AS SELECT country, region, prodtype, product, actual LABEL=''FORMAT=comma10.2, predict LABEL=''FORMAT=comma10.2, month FROM sashelp.prdsale WHERE mod(monotonic(),75)=0 ORDER BY ranuni(94612); QUIT; PROC REPORT DATA=sale NOWINDOWS MISSING HEADLINE HEADSKIP OUT=test; COLUMN country (region prodtype) , predict; DEFINE country / GROUP; DEFINE region / ACROSS; DEFINE prodtype / ACROSS; RBREAK AFTER / SUMMARIZE SKIP ol; COMPUTE predict; IF _c2_>_c3_.sum THEN CALL DEFINE (_Col_, "style", "style={background=Yellow}"); ENDCOMP; RUN;       ... View more

Hi All, I have one report which contain PROC SGPLOT and PROC TABULATE for my whole dataset. I want separate report (separate PDF file) for each by group (which is 'zip' in my database). I would appreciated if anyone can help me with this.   part of the code was taken from: https://communities.sas.com/t5/SAS-Procedures/ODS-Need-bar-chart-and-proc-report-results-on-same-page/m-p/57507#M16053   DATA monthly_sales; LENGTH zip $ 5 cty $ 8 Type $ 10; INPUT zip $ cty $ Type $ sales Date; INFORMAT Date Date9.; FORMAT Date Date9.; LABEL zip="Zip Code" cty="County" sales="Monthly Sales"; DATALINES; 52423 Scott Merlot 186. 05APR2018 52423 Scott Chardonnay 156.61 11AUG2017 52423 Scott Zinfandel 35.5 11Feb2017 52423 Scott Merlot 55.3 03JAN2018 52388 Scott Merlot 122.89 01APR2016 52388 Scott Chardonnay 78.22 05Jan2018 52388 Scott Zinfandel 15.4 12MAY2018 52200 Adams Merlot 385.51 09DEC2015 52200 Adams Chardonnay 246 15JUL2016 52200 Adams Zinfandel 151.1 19SEP2017 52200 Adams Chardonnay 76.24 25MAR2018 52199 Adams Merlot 233.03 10OCT2016 52199 Adams Chardonnay 185.22 12Jan2017 52199 Adams Zinfandel 95.84 09Jan2018 ; PROC PRINT DATA=monthly_sales; TITLE "Monthly Sales"; RUN; ODS LISTING CLOSE; OPTIONS NODATE NONUMBER; ODS GRAPHICS / RESET=ALL; ODS PDF FILE='C:\TEMP\TWOTHINGS.PDF' STARTPAGE=NO STYLE=EGDEFAULT; ODS RTF FILE='C:\TEMP\TWOTHINGS.RTF' STARTPAGE=NO STYLE=EGDEFAULT; ODS HTML PATH='C:\TEMP' (URL=NONE) FILE="TWOTHINGS.HTML"; OPTIONS(PAGEBREAK='NO') STYLE=EGDEFAULT; PROC SGPLOT DATA=Monthly_sales; VBAR cty/GROUP=type GROUPDISPLAY=CLUSTER; XAXIS TYPE=DISCRETE; RUN; TITLE 'PROC TABULATE'; PROC TABULATE DATA=Monthly_sales; CLASS cty type; VAR sales; TABLE cty ALL, type='SALES STATISTICS BY TYPE'*sales=' '*(N MEAN); RUN; TITLE; ODS _ALL_ CLOSE;   ... View more

Hi, I want to create letters to all students using my sas dataset. Can someone help how I can do it please.    data have; input Name $ Class $ ST_ID $ Course $ Score date; informat date ddmmyy8.; format date date9.; cards; John Grade10 101 Eng 20 01/01/82 Mary Grade11 105 Bio 25 25/11/99 Paul Grade11 105 Math 18 23/09/00 Jenny Grade11 105 Eng 15 11/12/01 ; RUN;   Here is my output letter that I want to print in pdf.   Dear Name, Your Course Grade is Score. You will be attending to the graduation on Date.   Thank You,   School Principal     ... View more

Here is what my data situation and what I want.  My fiscal year goes from March 1 to end of February. At any given day (let's say today) I have my current fiscal year data until today (Mar 01 2018 - May 19 2018) and data from last 2 full fiscal year. For example today I have: FiscalYear 2018-2019: Mar 01 2018 - May 19 2019 Fiscal Year 2017-2018: Mar 01 2017 - Feb 28 2018 Fiscal Year 2016-2017: Mar 01 2016 - Feb 28 2017 WHAT I WANT: ------------------- Filter the data until the end of last month (in my case April of 2018-2019 Fiscal Year) and I want the code to determine that from system date. Filter the data from each last 2 fiscal year until the end of April of each year. In my example it will be April 2017 & April 2016. Every month when I will run my code, I don't want to change my Year/Fiscal year manually on my code. My output table should look like this:   16Mar2016 Bio2 01Mar2018 Eng1 15Mar2018 Bio1 27Apr2018 Bio1   HERE IS MY Example DATA DATA have; INPUT Date Course_ID $4.; INFORMAT Date Date9.; FORMAT Date Date9.; DATALINES; 05Jan2018 ENG1 16Aug2017 Bio2 11MAY2015 Eng2 28Feb2018 Geo2 16Mar2016 Bio2 01Mar2018 Eng1 09Feb2017 Che1 19Jan2015 Phy2 15Mar2018 Bio1 12Mar2015 Phy2 19May2018 Che1 27Apr2018 Bio1 ; PROC PRINT NOOBS; RUN; ... View more