Statistical Consultant & Survey Methodlogist for the US Centers for Disease Control and Prevention
Statistical Consultant, Survey Sampling, Survey Methodology
I get this error trying to run it:
26 %sgdesign; ERROR: Write access to member SASUSER.LIBREFS.DATA is denied. ERROR: Java class generated an exception.
... View more
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
this doesn't work when using it from UNIX sas. log says NOTE: Libref TEST12 was successfully assigned as follows: Engine: XLSX Physical Name: /xxxxx/yyyyy.xlsx 24 25 26 27 data sheet1; 28 29 set test12."Sheet1$"n(dbSASType=(HADMDTTM=datetime IADMDTTM=dateTime)); _________ 22 ERROR 22-7: Invalid option name DBSASTYPE. 30 31 run;
... View more
Good morning....wow...this community seems to work. Very nice! Thanks to you guys. .....the solution with the "." works. Thanks very much! Here is the code and log results >>libname smfexcel excel "C:\Users\fhoff\Desktop\Monthly Report\smf_&smf_year._M01.xlsx"; Physical Name: C:\Users\fhoff\Desktop\Monthly Report\smf_2013_M01.xlsx greetings from munich
... View more
