long variable name when infile pipe delimited file into sas

0
votes

I have a pipe delimited file when variable name is 40 bytes long. Is there an option in sas to specify the length?

Currently, SAS wouldn't read this file with lrecl= [a large enough number] dsd dlm='09'x.

1
sasdelimited-text
Is your variable name long, or the values in the variable? – Reeza

1 Answers

1
votes

SAS variable names cannot be over 32 characters long. You can allow SAS to make a decision about the variable names (shortening automatically) but retain the long variable name as a label, which is often the simplest procedure. It shouldn't prevent it from loading, though.

However, more concerning is the fact that you say it is a pipe delimited file, but dlm='09'x, which is tab delimited. Is this just a typo/word choice issue or are you doing this incorrectly?