Hi All,
I am using the infile statement to import text files and I am trying to import everything EXCEPT the last row (as it is the Grand Totals). The last row is dynamic, it could be row 14 or row 20. Is there a way to import N-1 rows?
Thank you
data Work.Test ;
infile &DataFile dlm=',' firstobs=3 dsd;
length Time_Period $30;
input
Time_Period
ID
Customers
;
run;
I would try:
infile &DataFile dlm=',' firstobs=3 dsd obs=nobs;
if _n_ = nobs then stop;
I would try:
infile &DataFile dlm=',' firstobs=3 dsd obs=nobs;
if _n_ = nobs then stop;
data x;
infile '/folders/myfolders/want.txt' end=last length=len;
input x $varying200. len;
if not last then output;
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.