SAS 8 & 9: Numbers getting turned into Notation
in [SAS]
|
From: steve on 16 Feb 2010 09:32 On Feb 14, 6:44 pm, Tom Abernathy <tom.aberna...(a)gmail.com> wrote: > Steve - > Sounds like a FORMAT issue. Just attach a format to the variable > that is long enough to show the whole integer. Tom; I'm barely familiar with SAS, I'm just a first point of contact for problems. How and where would I do this? Thanks much in advance Steve
From: steve on 16 Feb 2010 09:36 On Feb 14, 7:34 pm, Savian <savian....(a)gmail.com> wrote: > What better tools are you referring to than DBMSCopy? I am not aware > of hardly any that support the sas7bdat format. SPSS, WPS, DBMSCopy, > StatTransfer. I think that is about it. If you know of any others, > please let me know because I am very interested in this area. Alan; I'm barely familiar with SAS. SAS is something the statisticians in our company use near exclusively. I'm just a first point of contact in assisting them with problems. My company is still moving its collected data from Microsoft SQLServer into *.sas7bdat files by first dropping the tables into an intermediary format and then programmatically generating a DBMSCopy script to translate the tables into *.sas7bdat files. We are now experimenting with a full version of SAS 9, with special extensions, that lets SAS contact Microsoft SQLServer directly and import the data directly into *sas7bdat files. This capacity has been around for a few years, but I understand that it is expensive. HTH Steve
From: Savian on 16 Feb 2010 10:00 On Feb 16, 7:36 am, steve <tinker...(a)gmail.com> wrote: > On Feb 14, 7:34 pm, Savian <savian....(a)gmail.com> wrote: > > > What better tools are you referring to than DBMSCopy? I am not aware > > of hardly any that support the sas7bdat format. SPSS, WPS, DBMSCopy, > > StatTransfer. I think that is about it. If you know of any others, > > please let me know because I am very interested in this area. > > Alan; > > I'm barely familiar with SAS. SAS is something the statisticians in > our company use near exclusively. I'm just a first point of contact > in assisting them with problems. > > My company is still moving its collected data from Microsoft SQLServer > into *.sas7bdat files by first dropping the tables into an > intermediary format and then programmatically generating a DBMSCopy > script to translate the tables into *.sas7bdat files. > > We are now experimenting with a full version of SAS 9, with special > extensions, that lets SAS contact Microsoft SQLServer directly and > import the data directly into *sas7bdat files. > > This capacity has been around for a few years, but I understand that > it is expensive. > > HTH > > Steve Steve, You can use SAS Access for OleDB for this work. See if you have that in house. Alan http://www.savian.net
First
|
Prev
|
Pages: 1 2 Prev: SAS 8 & 9: Numbers getting turned into Notation Next: SAS/IntrNet not cleaning up sas.exe |