From: Christof Kluß on
Hi,

we exported an MS Excel spreadsheet as *.prn file. We want to import
this file in SAS with the command "input". But the last column of the
*.prn file is missing. (MS Excel Windows XP Prof and SAS 9 Solaris,
WinSCP to transfere the *.prn file)

Has somebody an idea how to fix this problem?

Thank in advance,
Christof


From: a on
On Feb 24, 1:14 pm, Christof Kluß <ckl...(a)email.uni-kiel.de> wrote:
> Hi,
>
> we exported an MS Excel spreadsheet as *.prn file. We want to import
> this file in SAS with the command "input". But the last column of the
> *.prn file is missing. (MS Excel Windows XP Prof and SAS 9 Solaris,
> WinSCP to transfere the *.prn file)
>
> Has somebody an idea how to fix this problem?
>
> Thank in advance,
> Christof

Infile statement option TERMSTR=CRLF may fix the problem.