Problem:
Mismatch in field picked from file while reading in data.
Code:
FILENAME trans6'/folders/myfolders/transaction_date.txt';
data trans6;
infile trans6;
input @1 trans_date mmddyy10.
@12 id $6.
;
run;
proc print data=work.trans6;
run;
Output:
Log:
Add the truncover option to your infile statement. e.g.:
FILENAME trans6 '/folders/myfolders/transaction_date.txt'; data trans6; infile trans6 truncover; input @1 trans_date mmddyy10. @12 id $6.; run;
Art, CEO, AnalystFinder.com
Add the truncover option to your infile statement. e.g.:
FILENAME trans6 '/folders/myfolders/transaction_date.txt'; data trans6; infile trans6 truncover; input @1 trans_date mmddyy10. @12 id $6.; run;
Art, CEO, AnalystFinder.com
Hi:
When you read a file like this, SAS is telling you in the log, what is wrong with these lines:
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.