topic Re: Problem inputting raw data on SAS Server in SAS Programming

Problem inputting raw data on SAS Server

sasuser8675309 — Sat, 07 Jun 2014 15:13:19 GMT

Hello--

I have a simple input statement that I am using to test a program. It works fine in SAS 9.3 and EG 5.1 on my personal machine. However, when I try this on my work computer, which uses EG 6.1 through the SASApp Server, it has issues. The syntax is fine, so I cannot understand what the issue is.

data example;

input productgroup $ state $ id amount price;

cards;

lumber NC 17442 21324 66.83

lumber NC 17951 353726 19.40

;

run;

Any help would be greatly appreciated, since this seems to be a simple issue and it's driving me crazy.

Nick

ps. I can "force" it to work with length statements, but I shouldn't have to. Also, not practical since I will sometimes be testing this with larger datasets.\

Re: Problem inputting raw data on SAS Server

sasuser8675309 — Sat, 07 Jun 2014 15:27:48 GMT

I can also force it to work by altering the statement to

data example;

infile cards delimiter=',';

input productgroup $ state $ id amount price;

cards;

lumber,NC,17442,21324,66.83

lumber,NC,17951,353726,19.40

;

run;

This seems unnecessary, since the original syntax was correct....am I missing something here? I'm losing my mind....

Re: Problem inputting raw data on SAS Server

Tom — Sat, 07 Jun 2014 15:50:02 GMT

What is the error message?

Re: Problem inputting raw data on SAS Server

sasuser8675309 — Sat, 07 Jun 2014 16:07:29 GMT

Weird....

I tried the old "turn it off and turn it back on" trick and now it's working. Maybe the server had stored a stale image of the data set somehow? Either way, thanks for response.

Re: Problem inputting raw data on SAS Server

Ksharp — Sun, 08 Jun 2014 03:01:59 GMT

Maybe your work computer mistake blank delimiter as TAB delimiter , just guess.

data example;

infile cards expandtabs ;

input productgroup $ state $ id amount price;

cards;

lumber NC 17442 21324 66.83

lumber NC 17951 353726 19.40

;

run;

Xia Keshan