BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ps8813
Fluorite | Level 6

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?

1 ACCEPTED SOLUTION

Accepted Solutions
data_null__
Jade | Level 19

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.
 

View solution in original post

4 REPLIES 4
Reeza
Super User

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;

 

 

AskoLötjönen
Quartz | Level 8

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;

 

 

data_null__
Jade | Level 19

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.
 
Ps8813
Fluorite | Level 6

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

Thanks.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1163 views
  • 1 like
  • 4 in conversation