dear all,
i have a file with NO delimiters.
I can read it in by using
input @001 xxx
@010 yyyy
..........
but when there is a column added i need to re-calculate the positions :smileyconfused:
anyone an idea how to avoid this?
i start testing by using LENGTH or ATTRIB, informat, ... before the input statement (possible with delimited data) . . . without any luck.
data have;
attrib v1 lengt=$4 .... v2 ....;
input v1 v2;
run;
GreetZ,
Herman
It is hard to assume anything based on the volume of data you have provided.
Are the fields supposed to be fixed width? If not, how do you know where each field ends?
The following should be pretty self explanatory.
data want;
infile datalines;
INPUT @1 var1 $2.
var2 6.
var3 $8.
;
datalines;
BE123456AAA
NL987654BBBBBBB
;
run;
Can you provide some sample data?
It is hard to assume anything based on the volume of data you have provided.
Are the fields supposed to be fixed width? If not, how do you know where each field ends?
The following should be pretty self explanatory.
data want;
infile datalines;
INPUT @1 var1 $2.
var2 6.
var3 $8.
;
datalines;
BE123456AAA
NL987654BBBBBBB
;
run;
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.
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.