About dal233

dal233 · ‎09-22-2014

Yes, all I can see is RESDEV too.

dal233 · ‎09-22-2014

I would like to use proc genmod to output DevianceResidualPlot as outlined here: http://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_genmod_sect051.htm I start by writing: ods graphics on; proc genmod data=train plots=DevianceResidualPlot; etc. etc. But I get an error like this: ERROR 22-322: Syntax error, expecting one of the following: (, ALL, CLEVERAGE, CLUSTERCOOKSD, CLUSTERDFIT, COOKSD, DCLS, DFBETA, DFBETAC, DFBETACS, DFBETAS, DOBS, LEVERAGE, MCLS, NONE, PREDICTED, PZERO, RESCHI, RESDEV, RESLIK, RESRAW, STDRESCHI, STDRESDEV. ERROR 76-322: Syntax error, statement will be ignored. So the option I want doens't seem to be loaded. How come?

dal233 · ‎02-07-2014

I do believe that is it! Thanks.

dal233 · ‎02-07-2014

The sort order is Pol Nbr, Pol Eff. Dt., Location and Sublocation. And I would like to keep it in that order.

dal233 · ‎02-07-2014

That's not quite what I want. In that case it will not only flag the change in subloc_addr, but also the first instance of the sublocation (i.e the first "1" above). I don't want to flag the first instance.

dal233 · ‎02-07-2014

POL_NBR_ID POL_EFF_DT Location SubLocation BUS_DESC SUBLOC_ADDR1 SUBLOC_ADDR2 CITY building_age Switch Location Flag 1 06/29/2005 1 1 REAL ESTATE MANAGEMENT 8550 Pearl CHICAGO 1 06/29/2006 1 1 REAL ESTATE MANAGEMENT 8550 Pearl CHICAGO 1 06/29/2007 1 1 OFFICE BLDG. 8550 Pearl CHICAGO 1 06/29/2008 1 1 OFFICE BLDG. 8550 Pearl CHICAGO 1 06/29/2009 1 1 OFFICE BLDG. 8550 Pearl CHICAGO 39 1 06/29/2010 1 1 OFFICE BLDG. 8550 Pearl CHICAGO 40 1 06/29/2011 1 1 MEDICAL OFFICE BLDG. 2401 Asylum Way GLENVIEW 10 1 1 06/29/2012 1 1 MEDICAL OFFICE BLDG. 2401 Asylum Way GLENVIEW 13 I hope the formatting of the above table comes out OK. I couldn't upload the excel file so just had to paste it in. What you see above is a dataset with Policy Number, Pol. Eff. Dt, Location, Sublocation and Subloc Address 1 (amongst other less important things). What I am trying to do is create SAS code to generate a 1 in the "Switch Location Flag" field above. Notice how the flag appears when the sublocation stays the same, but there is just a change in physical address, as you can see in the Subloc Address 1 field. It's a pity I can't upload an Excel file here so as that the data is easily portable, but hopefully you get what I mean and can help out.

dal233 · ‎04-05-2013

Thank you.

dal233 · ‎04-04-2013

I've got a macro that iterates through the variables in a dataset and outputs a table with various responses and other summary statistics. So, for example, one variable might be year and the table generated by proc tabulate would look like this: Year Exposure Frequency Loss 2008 10423 0.1 5469 2009 45390 0.12 4987 2010 100542 0.2 29801 Many tables like this are generated for variables other than year and the results are formatted and outputted to a pdf. My question is how can I accompany the tables with plots in the pdf. In the example above I would like to output the table and then above the table a plot of Year against frequency as a line chart, with year on the x-axis and frequency on the y-axis. I would like to do the same thing for every other variable that gets outputted from the proc tabulate procedure to the pdf. Any ideas or pointers from anybody?

dal233 · ‎03-20-2013

When I run the sgplot procedure to generate four plots on a page, the bottom border of the graph is blank/absent/"white-ed out" in a pdf. However when I print it out, the border is clearly there. Here is the code for one of the plots: proc sgplot data= dat.test_sas; vbar year / response=gwp legendlabel="GWP"; vline year / response=frequency y2axis lineattrs=(color=red) legendlabel="Frequency"; yaxis label="GWP"; y2axis label="Frequency"; run;

dal233 · ‎03-20-2013

I've just resolved this. I was using a series statement instead of a vline statement for the line graph. If I use vline it works with the y2axis option. proc sgplot data = test; vline year / response = frequency y2axis; vbar year / response = gwp; run; Strangely though, the vbar statement does not offer the y2axis option.

dal233 · ‎03-20-2013

I've been trying to figure out how to have a bar chart (representing exposure) on the second y axis and a line chart (representing frequency) on the first y axis in sgplot. Can anybody help?

dal233 · ‎01-02-2013

Typical. Having spent an hour on it, and then posting here, I have now, subsequently, figured it out! I just needed to go to our the network libraries on our server to find the sasautos folder.

dal233 · ‎01-02-2013

I would like to use SAS EG to output a list of macros available in SASAUTOS. How can I do that?

Online Status	Offline
Date Last Visited	‎10-31-2017 09:53 AM

Re: DevianceResidualPlot

DevianceResidualPlot

Re: Flag a new address within a sublocation group

Re: Flag a new address within a sublocation group

Re: Flag a new address within a sublocation group

Flag a new address within a sublocation group

Re: Graphing output of Proc Tabulate

Graphing output of Proc Tabulate

Bottom border of sgplot graph output is absent

Re: Overlaying bar chart and line on one graph with sgplot

Re: Graphing output of Proc Tabulate

Re: DevianceResidualPlot

DevianceResidualPlot

Re: Flag a new address within a sublocation group

Re: Flag a new address within a sublocation group

Re: Flag a new address within a sublocation group

Flag a new address within a sublocation group

Re: Graphing output of Proc Tabulate

Graphing output of Proc Tabulate

Bottom border of sgplot graph output is absent

Re: Overlaying bar chart and line on one graph with sgplot

Overlaying bar chart and line on one graph with sgplot

Re: output list of sasautos macros

output list of sasautos macros