|
I'll try this as well.
Many thanks to all.
Paul
Dr. Paul R. Swank,
Children's Learning Institute
Professor, Department of Pediatrics, Medical School
Adjunct Professor, School of Public Health
University of Texas Health Science Center-Houston
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nordlund, Dan (DSHS/RDA)
Sent: Wednesday, April 04, 2012 2:57 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: grouse about 64 bit machine
Paul,
I use the pcfiles server (which comes with SAS Access for PC Files Formats". I created a 32-bit Excel file, c:\tmp\Excel_32bit.xls, and used the following libname.
libname test pcfiles path="c:\tmp\Excel_32bit.xls";
I can then access the sheets in the workbook like this
data want;
set test.'sheet1$'n;
run;
Hope this is helpful,
Dan
Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA 98504-5204
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Swank, Paul R
> Sent: Wednesday, April 04, 2012 12:35 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: grouse about 64 bit machine
>
> Well, suppose you want to read a 32 bit excel file into SAS. I get an
> error when I try this.
>
> Paul
>
> Dr. Paul R. Swank,
> Children's Learning Institute
> Professor, Department of Pediatrics, Medical School
> Adjunct Professor, School of Public Health
> University of Texas Health Science Center-Houston
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Dennis Fisher
> Sent: Wednesday, April 04, 2012 2:32 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: grouse about 64 bit machine
>
> Dan,
> Yes. I am trying to ask the same question you are asking. Thanks for
> doing a better job than I did.
> Dennis
>
> Dennis G. Fisher, Ph.D.
> Professor and Director
> Center for Behavioral Research and Services
> 1090 Atlantic Avenue
> Long Beach, CA 90813
> Tel: 562-495-2330 x121
> Fax: 562-983-1421
> www.csulb.edu/centers/cbrs
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Nordlund, Dan (DSHS/RDA)
> Sent: Wednesday, April 04, 2012 12:30 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: grouse about 64 bit machine
>
> > -----Original Message-----
> > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> > Swank, Paul R
> > Sent: Wednesday, April 04, 2012 12:18 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: grouse about 64 bit machine
> >
> > On my my 64 bit machine, I have SAS 9.2 64 bit and 32 bit programs
> > installed because I still have lots of data collected and run through
> > the 32 bit software. However, it seems that in 9.3, you can't have
> > both
> > 64 and 32 bit programs on the same machine. This means I have to have
> > two computers to run SAS, one for the 32 bit and one for the 64 bit.
> > Anyone else have this problem?
> >
> > Paul
> >
> > Dr. Paul R. Swank,
> > Children's Learning Institute
> > Professor, Department of Pediatrics, Medical School Adjunct
> Professor,
> > School of Public Health University of Texas Health Science
> > Center-Houston
>
> Paul,
>
> This is not an answer to your question, but a question for
> clarification. Why don't you just use 64-bit SAS to read your 32-bit
> files? There may be good reason, but just wondering. We are going
> through a transition to 64-bit in our office, and I can see little
> reason for continuing to use 32-bit SAS.
>
> Dan
>
> Daniel J. Nordlund
> Washington State Department of Social and Health Services Planning,
> Performance, and Accountability Research and Data Analysis Division
> Olympia, WA 98504-5204
|
