Date: Tue, 20 Jun 2000 10:39:22 +0200
Reply-To: Andre Wielki <wielki@INED.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Andre Wielki <wielki@INED.FR>
Subject: Re: SAS version 8
Content-Type: text/plain; charset="iso-8859-1"
dear Petersen,
i send yesterday this remark about OEM
you could try because, if the oem option disappear from the infile
you have through my solution the possibility of converting ansi/ascii and
so on
the program was named trabase.sas and was situated in /sas612/base/sample
i hope this program is valid for v8 because i did find it again in
v8
After carefull examination, i found in core\sashelp\ a catalog
htmlnls with apparenltly included translation between languages
and perhaps ascii iso /oem translation
Also if you are examinating the host catalog at the same directory
you will find some trantab sas already created to you
oemdanish ansidanish and danish
i think some of them are the equivalent to danita and daneti
and you avoid the trabase.sas program!
try it with my little program, you could better say to the list
if it is a good by pass solution
text of yesterday
======================================
René ,
here in France, we have accentuation like éèàùö û and so on
in my previous job, we have had some problems with winansi<==> oem
it was in the case of exchanging sas tables <==> quattro pro 5 or excel4
my solution was using the trabase.sas program
libname lib 'sasroot\core\sample'
af c=libn.nlssetup.frame
then you have to create some equivalent to the french construction
ascii iso/ascii-oem ita/ati i think it is your solution
in french it gives with the prefix fre freita freati trantab tables
in danish it gives danita danati because of the prefix dan
others languages are ita, hun, pol, spa, swe, swi, and ger
after doing it,we have used this little program to use before the wizard
export use
libname a ...;filename b 'c:\test.txt'; *transitionnal file;
proc cport data=a.mytable file=b;trantab name=freita;run;
options trantab=( , , , );
proc cimport data=a.tableoem infile=b;
run;
then the wizard give the correct oem file
the reverse must be possible with freati (danati)
you must accept one step more : going outside sas with good export table and
going in back before going finally to your oem application or system?
our sas 6.12 was fixed on winansi.
I think this kind of solution must continue to exist in sasv8
look for this program trabase.sas and adapt it (if i remember, it is the
biggest sas program i known , you must cut a lot)
André Wielki
=========================
At 07:38 20/06/00 +0000, you wrote:
>Can somebody help my with some changes in version 8 from version 6. (I never
>saw version 7).
>
>In version 6, I wrote..
>
>Infile 'c:\txtdata.dat' oem;
>
>.. to get the ascii-file 'txtdata.dat' translated to ansii when read by a
>later input statement - but in version 8 it does not work. What to do now?
>
>Another thing: Are the numbers now completely gone? In version 6, you could
>get a coloums of line-numbers in the left of your program-window by writing
>"numbers" in the command-window. It was convenient, when you want to delete
>or copy lines of your program.
>
>----------------------------------------------------------------------------
>----
>Mogens Ring Petersen
>University of Copenhagen
>Nattergalevej 75 1 mf
>2400 København NV
>----------------------------------------------------------------------------
>----
>
___________
WIELKI Andre
INED - Service Informatique
133 Bd Davout,
75 020 Paris FRANCE
Tel: 01 56 06 21 54
