topic Reading raw data column input issue in SAS Programming

Reading raw data column input issue

Ps8813 — Fri, 12 Feb 2016 04:28:36 GMT

I have submitted below program , but its showing invalid data for variable 'sal'

data Emp;
informat sal comma8.;
input name $ 1-4 sal 5-9 ;
datalines;
John12,360
;
run;

what is the issue?

Re: Reading raw data column input issue

Reeza — Fri, 12 Feb 2016 05:37:05 GMT

The input statement is incorrect, you'rer trying to use fixed format method to read the file. Your data appears to be comma delimited instead. Specify the delimiter using DLM.

Infile cards dlm=",";

Input name $ sal;

Re: Reading raw data column input issue

AskoLötjönen — Fri, 12 Feb 2016 06:59:06 GMT

If you just put the start column ans informat into input line it works.

data Emp;
informat sal comma6.;
input name $ 1-4 @5 sal comma8. ;
datalines;
John12,360
;
run;

Re: Reading raw data column input issue

data_null__ — Fri, 12 Feb 2016 08:56:51 GMT

Understanding Column Input

With column input, data values occupy the same fields within each data record. When you use column input in the INPUT statement, list the variable names and specify column positions that identify the location of the corresponding data fields. You can use column input when your raw data is in fixed columns and does not require the use of informats to be read.

http://support.sas.com/documentation/cdl/en/basess/68381/HTML/default/viewer.htm#n0guqhc8tg7uw1n1uibrd74cg3e3.htm

Re: Reading raw data column input issue

Ps8813 — Fri, 12 Feb 2016 21:43:59 GMT

Thanks all for replying. Now i understand that in column input, informats are ignored.

Thanks.