What considerations should be made when switching from variable length records to fixed length records in formatting data?
Please be more specific. SAS datasets store data as fixed length fields, so I am not sure of the context.
Doc Muhlbaier
Duke
I'm using an Excel Spreadsheet to import data and was wondering what changes I need to make or be concerned about when going from a variable length record to a fixed one. Especially when it comes to the options settings I am using (i.e. GETNAMES, SCANTEXT, etc.). I'm looking more for generic answers than specific ones here.
Thanks,
Yoda
SAS's PROC IMPORT will use the maximum number of columns that it observes in the rows that are scanned to determine a size unless you do a manual override. It's in the documentation for SCANTEXT and TypeGuessingRows.
I'm not sure how the EGuide import wizard does it, though I've generally found it to be accurate.
Doc Muhlbaier
Thanks for the info. I'm building all of mine from scratch as it is a customized system and EGuide doesn't give me the granularity I need.
Appreciate it Doc,
Yoda
in case of infile use lrecl=x not sure about EG
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.