04-13-2016
mlamias
Fluorite | Level 6
Member since
06-23-2011
- 10 Posts
- 7 Likes Given
- 0 Solutions
- 5 Likes Received
About
Statistical Consultant & Survey Methodlogist for the US Centers for Disease Control and Prevention
Statistical Consultant, Survey Sampling, Survey Methodology
-
Latest posts by mlamias
Subject Views Posted 3782 03-25-2016 03:21 PM 3801 03-24-2016 05:22 PM 4004 03-07-2013 12:23 PM 537 03-07-2013 12:19 PM 4004 03-07-2013 11:17 AM 27690 03-07-2013 11:00 AM 17561 03-07-2013 10:22 AM 882 10-11-2012 11:37 AM 4269 04-16-2006 04:31 AM 1978 04-16-2006 04:22 AM -
Activity Feed for mlamias
- Got a Like for Re: Importing date-time variables from Excel into SAS. 11-28-2017 11:50 AM
- Posted Re: Difference between COVB in genmod's model statement versus repeated statement? on Statistical Procedures. 03-25-2016 03:21 PM
- Liked Re: Difference between COVB in genmod's model statement versus repeated statement? for Rick_SAS. 03-25-2016 03:20 PM
- Tagged Difference between COVB in genmod's model statement versus repeated statement? on Statistical Procedures. 03-24-2016 06:36 PM
- Tagged Difference between COVB in genmod's model statement versus repeated statement? on Statistical Procedures. 03-24-2016 06:36 PM
- Tagged Difference between COVB in genmod's model statement versus repeated statement? on Statistical Procedures. 03-24-2016 06:36 PM
- Liked Re: Value of a E number for Reeza. 03-24-2016 05:28 PM
- Liked Re: Value of a E number for Reeza. 03-24-2016 05:28 PM
- Posted Difference between COVB in genmod's model statement versus repeated statement? on Statistical Procedures. 03-24-2016 05:22 PM
- Got a Like for Re: Dynamic Libname Path. 09-01-2015 04:24 AM
- Liked Re: PROC GENMOD: no automatic selection method? for JacobSimonsen. 02-07-2015 05:24 PM
- Liked Re: correlation for PGStats. 02-02-2015 01:28 AM
- Liked Re: SAS 9.3 won't uninstall properly for Macaraeg. 09-04-2014 12:47 AM
- Posted Re: Dynamic Libname Path on SAS Programming. 03-07-2013 12:23 PM
- Posted Re: Creating a stacked bar chart with continuous data? on Graphics Programming. 03-07-2013 12:19 PM
- Got a Like for Re: Importing date-time variables from Excel into SAS. 03-07-2013 11:30 AM
- Liked Re: Importing date-time variables from Excel into SAS for Mercator. 03-07-2013 11:27 AM
- Posted Re: Dynamic Libname Path on SAS Programming. 03-07-2013 11:17 AM
- Posted Re: Importing date-time variables from Excel into SAS on Microsoft Integration with SAS. 03-07-2013 11:00 AM
- Posted Re: Importing date-time variables from Excel into SAS on Microsoft Integration with SAS. 03-07-2013 10:22 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 2 1 3 1 -
My Liked Posts
Subject Likes Posted 3 03-07-2013 12:23 PM 2 03-07-2013 11:00 AM
03-25-2016
03:21 PM
Perfect. Thanks so much! If I couldn't find this information under the COVB option in the genmod documenation, then no, the documenation didn't make it clear. I'd ask that this information be added or at least hyperlinked to in the genmode documentation under the COVB options.
... View more
03-24-2016
05:22 PM
I noticed that that you can place the "COVB" option after the model statement or after the repated statement when building a GEE model using genmod. The resulting matrices are totally different. Does anyone know what the difference is between the covariance matrices that are produced? I realize that the COVB after the reapeated statement produces both a model-based covariance matrix as well as the empiracal-based one, but I would have thought the COVB option on the model statement would have been the same. The documentation doesn't make it clear how these are different.
Thanks.
... View more
- Tags:
- covariance
- GEE
- genmod
03-07-2013
12:23 PM
3 Likes
The last poster is correct. It appears you are missing the dot (.) in the your code (if I interpreted your file naming conventions correctly). I could also see the leading zero in the month being problematic. Note that in SAS, there is a difference between: %let choosen_month=3; and %let choosen_month=03;
... View more
03-07-2013
12:19 PM
I'd like to offer another solution. If you have SAS IML and have downloaded and installed the freely available R statistical package, then as of SAS 9.2, you should now be able to send your SAS datasets directly to R, graph your data in R, and return to SAS seamlessly all from within the SAS editor. Depending on what you are trying to do, the graphics quality in R can sometimes be superior to that of SAS, in my opinion. Here's the code and resulting graph using this method with R 2.15.2: data work.temp; input Building $2. Speed Accuracy Responsiveness Total; datalines; B1 10 8 10 28 B2 8 7 9 24 ; run; proc iml; run ExportDataSetToR("work.temp", "temp" ); submit / R; plotmatrix<-t(temp[c(-1, -5)]) colnames(plotmatrix)<-c("B1", "B2") barplot(plotmatrix, main="Total Performance", xlab="Performance Measure", ylab="Performance", col=c("darkblue", "green", "yellow"), ylim=c(0, 30), legend=rownames(plotmatrix)) dev.copy(png,filename="c://myplot.png") dev.off(); endsubmit; run; quit;
... View more
03-07-2013
11:17 AM
Why not just use something like the following? %let choosen_year=2013; %let choosen_month=3; libname smfexcel excel path="C:\Users\foobar\Desktop\Monthly Report\monthly_report&choosen_year._M&choosen_month..xlsx";
... View more
03-07-2013
11:00 AM
2 Likes
I'm not sure which version of SAS or Excel you are using. However, I'm running SAS 9.3 with Excel 2010 (with the xlsx file format). Here is how this can be accomplished: /*libname to excel file. I just placed your example in the root of c*/ libname xlsxfile "c:\exceldatetimefile.xlsx"; /*I named the output dataset sheet1. You might want to call it something else. The dbSASType dataset option is the critical part here. You need to specify to have SAS read your datetime variables in Excel as datetime format in SAS*/ data sheet1; set xlsxfile."Sheet1$"n(dbSASType=(HADMDTTM=datetime IADMDTTM=dateTime)); run;
... View more
03-07-2013
10:22 AM
If you provided examples of some of the datetime formats you see in Excel, I'm sure you'll receive an answer, but it's difficult to assit without being able to reproduce your problem. It would also be important to know how your are importing your data. What version of SAS are you using?
... View more
10-11-2012
11:37 AM
Why on earth would you want to perform a Chi-Squared Test on a table with this many cells?
... View more
04-16-2006
04:31 AM
I know this is probably a stretch for SAS right now, but it would be great to have an ODS EXCEL option. I know you can achieve this with ods html file='filename.xls" or ods csv or with DDE, but all these methods seem clumsy.
... View more
04-16-2006
04:22 AM
You may also need to use the noxwait and noxsync options to avoid having to manually exit the command prompt upon completion of calling the unzip program.
... View more