About AncaTilea

AncaTilea · ‎07-24-2013

In your code would you please try the following: (see my red markings) %macro modeltest(Dept=,holdoutweeks=); %let modelname1=simple; %let modelname2=double; %let modelname3=linear; %let modelname4=damptrend; %let modelname5=addseasonal; %let modelname6=multseasonal; %let modelname7=winters; %let modelname8=addwinters; %do J = 1 %to 2; **loops through the 8 different model choices and does the 6 weeks of forecasting for each**; %let modelspec=&&modelname&j; (*********THE PROBLEM OCCURS HERE********) %DO I = 1 %TO 1; %let backpd=%eval((&holdoutweeks+1)*7 - (&i*7)); **backpd = # of days to go back but divided by i so it loops through one week at a time**; proc esm data=&Dept back=&BackPd lead=14 seasonality=7 nooutall outfor=fcast_&Dept._&i._&modelspec outstat=metrics_&Dept._&i._&modelspec out=_null_; (*****THE PROBLEM IS HERE*****) by queue_nm lob; id date interval=day zeromiss=left; forecast effort/ model=&modelspec; run; %end; %end; %mend; %modeltest(Dept=OSS,holdoutweeks=6); PS: has a nice, straightforward paper that explains the use of double ampersand.

AncaTilea · ‎07-24-2013

Hi. Yes I can, however your post is very poorly written. I wouldn't attach a PowerPoint file that doesn't display anything since the EXCEL (I assume) file is not avaialble to display the data. I assume (again) that you'd like the boxplot to be created in SAS? Please see this post: https://communities.sas.com/message/151228#151228 PS: you should search the community, as it is often the case that someone else may have asked the question. Good luck, Anca.

AncaTilea · ‎07-11-2013

Arthur and all this sounds like a great idea. However, my one thought is that while the experts of the community may find an answer "more correct" or efficient than other answers, the user that asked the question may not have the SAS skills required to grasp the "more correct" answer. As a quick example, I don't know/understand (yet) hash tables. I know they can accomplish things rather more efficient than other methods. If I were to ask a question about reading some data, merging, I don't know this and that, and I get one answer using data steps, one answer using SQL (perhaps) and one answer using hash tables...I would prefer as the best fit for me the SQL one. maybe the experts would find the hash tables as "best"...so, I can mark the SQL answer as correct, and community users can mark/vote whichever answer they find more useful. To finally get to my point, I am afraid to not lose the more "simplistic" answers. That's all. Cheers.

AncaTilea · ‎07-03-2013

Hi, the first thing that comes to mind is that you are missing the letter 't' in the &format in this statement: proc gchart data=sashelp.stocks ( where= (stock="IBM") ) ; vbar date / discrete sumvar=open ; format date &forma; run ; Try and see what happens now?

AncaTilea · ‎07-02-2013

Hi. This is a nice problem. I unfortunately only were able to solve the simple part of it, but by replying now, it will bring it to the attention of those that will find the elegant solution in a blink: DATA WANT; INPUT STRING $80.; ref_no = scan(string,1, ""); mode = scan( string, 2, "" ); price = scan( string, -1, "" ); name = compbl(prxchange("s/.*MARS|PLAN|Family|Revenue|LifeLong|Vriddhi|BEST|Live|Smart|Builder|Young Scholar|Secure|[0-9]|Varsha/ /i", -1,string)); DATALINES; Y10800539 YEARLY MARS Family REVENUE Builder Mrs. sina Manahattan 970 Y10800542 YEARLY MARS PLAN Vriddhi Mr. Surendra gita Kumar 100.4 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Rahul kapu Man 969.83 Y10800539 YEARLY MARS Family REVENUE Builder Mrs. sina Manahattan 970 Y10800539 YEARLY MARS LifeLONG BEST Mr Virag Bashmukh 86 Y10800539 YEARLY MARS LifeLONG BEST Mr. Tricky behoshi H 94.5 Y10800539 YEARLY MARS Young Scholar Secure Mr. Joyton Flavian sequence 500 Y10800543 YEARLY MARS Family REVENUE Builder Mr. Suraj putraJoban 5000 Y10800543 YEARLY MARS PLAN Varsha Ms. Mahalakshmi krishnanram 504 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Himanshu Pahwa 3003.75 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Sanjay Vaarma 213.54 Y10800543 YEARLY MARS PLAN Vriddhi Mrs. Jane Saggarwal 3327 Y10800543 YEARLY MARS LIVE SMART Mr Syed husain Jasmeet 800 Y10800543 YEARLY MARS PLAN Vriddhi Mr Rajesh babr 1000.69 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Rajan visal 241.53 ; Basically you will have to use some character function (scan, substr, findw...) to parse the string...I am still working on it. Got the name down. Cheers! Anca.

AncaTilea · ‎07-02-2013

Something like this: proc sgplot data=sashelp.heart; histogram systolic / transparency=0.5 binwidth=5 ; density systolic / type=kernel (c = 0.75); histogram diastolic / transparency=0.5 binwidth=5; keylegend / location=inside position=topright across=1; xaxis display=(nolabel); run; Good luck! Anca.

AncaTilea · ‎06-25-2013

Hi. this code should get you somehow started. It is a bit confusing to me how you want the new_variable to be displayed at the end, how did you chose it to show on the first two rows? Anyway, take a look. data in; input category_1 category_2 $ result; datalines; 1 a 10 2 a 20 1 b 30 2 b 40 ; run; proc sort data = in;by category_1 category_2; proc transpose data = in out = want(drop = _NAME_); by category_1 ;id category_2; var result; run; data really_want; set want; new_variable = a/b; run; data final; merge in really_want(rename = (a = result) drop = b); by category_1 result; run; Good luck! Anca.

AncaTilea · ‎06-25-2013

Hi. Without a specific example, I don't have a ready code, but yes, it is possible to for SAS to handle proportions of the text. If you have prior knowledge of what the 'goal' is for each graph, then you can use a macro to create sepcific annotate data sets for specific graphs. %macro test(var = , value = ); data anno; length color function $8; retain xsys ysys '2' hsys '4' when 'a' color 'black' size 5; set sashelp.class; if &var. = "&value." then do; function = "label"; color = "red" ;style = '"Arial/bold"' ; position = "2"; size = 1.2 ; text = "Goal";midpoint = sex; output; end; run; proc gchart data = sashelp.class ; vbar sex/anno = anno sumvar = age ; run;quit; %mend test; %test(var = sex, value = M); %test(var = sex, value = F);

AncaTilea · ‎06-25-2013

So, here is for example one link that shows ANCOVA analysis with SAS: http://www.stat.sc.edu/~hitchcock/crackersasexample.txt and this one: SAS/STAT(R) 9.2 User's Guide, Second Edition What I need to know from you is what is your X (independent variable) and what is your Y (dependent variable)? I assume that your X is the ActLevel (as per the sasuser.admit data set). But what is the Y? What I mean is that you need to set up a (simple) model where the group variable is your X and you need a Y so you can conclude if there are differences in Y between the X's groups. Anyway.... Yes, there are ways to output the results by using either ods statement or the output out...

AncaTilea · ‎06-25-2013

Yes, the easiest would be with the annotate. if you provide a sample code, then I can figure it out. But in a nut-shell: Something like this: data anno; length color function $8; retain xsys ysys '2' hsys '4' when 'a' color 'black' size 5; set sashelp.class; if sex = "M" then do; function = "label"; color = "red" ;style = '"Arial/bold"' ; position = "2"; size = 1.2 ; text = "Goal";midpoint = sex; output; end; run; proc gchart data = sashelp.class ; vbar sex/anno = anno sumvar = age ; run;quit; Is this sort of what you'd like? Anca.

AncaTilea · ‎06-25-2013

Hi. I don't have access to sasuser.admit; so,I used sashelp.class (which is not suitable for what you want, but it will give you an idea); proc glm data = sashelp.class; class sex; *need to put your group variable in the class statement model age = sex; lsmeans sex/stderr cl; run;quit; Good luck! Anca.

AncaTilea · ‎06-20-2013

Abe, your question is very vague and Reeza's answer is correct: yes, you can control the bar outline in proc sgplot/vbar... so, there are a couple of websites that I find extremely helpful when dealing with graphs in SAS http://blogs.sas.com/content/graphicallyspeaking/?s=vbar and Robert Allison's SAS/Graph Examples! Good luck! PS: here is a final link on how to ask a question on the forum:

AncaTilea · ‎06-19-2013

Please provide some sample data (take ou the real ID and physicians, but make up some data). Thanks.

AncaTilea · ‎06-19-2013

Hi. Have you checked this site? Support.sas.com

AncaTilea · ‎06-18-2013

Hi. What happens if you take the format statement out. I ran your code (using SASHELP.class) and attached is what I got: proc sgplot data=sashelp.class; loess x=age y=height/smooth=0.4 group=sex nomarkers lineattrs= (thickness=2); keylegend / title="Sex Category"; yaxis label='Height' grid values = (30 to 100 by 20); xaxis label='Age' grid values = (10 to 15 by 1); run; Is this sort of what you want?

Online Status	Offline
Date Last Visited	‎11-18-2024 07:33 PM

Re: Crosstab Dates

Re: why repeated observations??

Re: why repeated observations??

Re: why repeated observations??

Re: Add rivers to US map

Re: Add rivers to US map

Add rivers to US map

Re: # of months between two date vars

Re: ODS Tagsets ExcelXP Creating Multiple Workbooks

Re: Histogram with different fill colors beyond a specified point

Re: Add rivers to US map

Re: Spliting a string into variable

Re: Spliting a string into variable

Re: Histogram with different fill colors beyond a specified point

Re: Anagrams Within Words

Re: Default "view" preferences at startup of SAS

Re: Turn off title in BoxPlots

Re: How to use "labels" (Excel column headers) instead of SAS "names" ...

Re: Residuals in logistic regression

Re: Adding a Variance column in a table

Re: Problem embedding macro variable string in output data set name

Re: can any body please tell me how to annotate for legend in box plot...

Re: A thought about making the forum even more useful

Re: SGPLOT VBAR and a user defined format on the category variable

Re: Call data using Cards/dataline option

Re: proc univariate - kernel

Re: Create a new variable by calculating values from a single column?

Re: Is there a way to have SAS write the word "Goal" on a specific bar...

Re: How to Calculate LS Mean,95%CI and p-value.

Re: Is there a way to have SAS write the word "Goal" on a specific bar...

Re: How to Calculate LS Mean,95%CI and p-value.

Re: Bar outline in sgplot

Re: Proc Summary : Class Stmt

Re: Can any one provide me the full document which contain the instruc...

Re: Proc SGPLOT