SAS

sas Access question???
Hi I would rather say (not 100% sure) you are using SAS/ACCESS to access NOT native SAS databases and you are using SAS/SHARE when you create a library with Data Library manager SAS MANAGEMENT CONSOLE (SMC) plug-in. Daniel Fernandez. Barcelona. -----Mensaje original----- De: SAS(r) Discussion [mailto:SAS-L@L... 28 Oct 2009 13:59

UNSUBSCRIBE
=20 ... 27 Oct 2009 14:46

sas functions similar to STATA "anycount"
You could concatenate the variables together and use COUNT, if they're as simple as that: count(cats(of v:),'y') So: data example; infile datalines truncover; input id (v1 v2 v3 v4 v5) ($); cnt = count(cats(of v:),'Y'); put cnt=; datalines; 1 Y Y N Y Y 2 Y N N N N 3 Y N Y N N ;;;; run; ... 27 Oct 2009 13:38

Data Step error handling
Hi i have a flat file with multiple lines per logical record. i am tring to use a data step infile to create the dataset from the file. i have defined an array of size N to hold <= N lines. if there is a logical record with N+1 lines, the data step stops processing the rest of the other records follow after ... 28 Oct 2009 01:56

Convert Excel file created with tagsets.excelxp to xls/xlsx
Hi all, I have xml files created with ODS tagsets.excelxp and would like to convert them from plain xml to xls and/or xlsx. I can open them in Excel and Save as..., but need to do it automatically from a SAS program. The sheets in the files are not just one rectangular data set each, but two or more data sets with... 30 Oct 2009 23:16

ERROR: DBMS type EXCEL not valid for export????
Do you have SAS/ACCESS for PC Files licensed? [PROC SETINIT; RUN; ] -Joe On Mon, Oct 26, 2009 at 1:37 PM, Carol Thurman <erbcjt(a)langate.gsu.edu>wrote: Hi All, Why do I keep getting the error message below when I try to export data to excel? Carol PROC EXPORT DATA= WORK.HSPAL ... 28 Oct 2009 21:49

ERROR: DBMS type EXCEL not valid for export????
Hi All, Why do I keep getting the error message below when I try to export data to excel? Carol PROC EXPORT DATA= WORK.HSPAL OUTFILE= "J:\PAL 2009\High School Reliability.xls" DBMS=EXCEL REPLACE; ERROR: DBMS type EXCEL not valid for export. ... 26 Oct 2009 15:33

It's Not Easy Being a SAS Programmer!
Thanks, Mikeeee! Sounds interesting... not sure yet whether I'll be able to make SGF'10 but will certainly be at the lunch if I can :) However, I do hope that the lunch location does not commit the faux pas of placing the dessert fork in the primary place setting. Dessert cutlery should always come out with the... 26 Oct 2009 12:09

How does SAS determine the default length of a character
I think you need the data set option DBMAX_TEXT. It may work on the LIBNAME statement too. See docs for all the details. On 10/23/09, Brian Wallace <brian_c_wallace(a)yahoo.com> wrote: There was a truncation error and I have to explain what happened. We're reading in Excel 2003 spreadsheets into SAS 9.1.3 SP 4 u... 23 Oct 2009 23:14

Adding Previous Observations
Greetings All, I am dealing with what appeared to be a very simple procedure of adding observations in a previous row; turns out it is beyond my capabilities in SAS. I have tried various attempts with retain statements, lags, ^first.x, etc. I cant seem to get this seemingly simple process. I have a very siml... 23 Oct 2009 13:21