topic Re: Variable vs Fixed in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110931#M9481 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; It's in the documentation for SCANTEXT and TypeGuessingRows.</P><P></P><P>I'm not sure how the EGuide import wizard does it, though I've generally found it to be accurate.</P><P></P><P>Doc Muhlbaier</P></BODY></HTML> Thu, 10 May 2012 20:38:29 GMT Doc_Duke 2012-05-10T20:38:29Z Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110928#M9478 <HTML><HEAD></HEAD><BODY><P>What considerations should be made when switching from variable length records to fixed length records in formatting data?</P></BODY></HTML> Thu, 10 May 2012 20:15:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110928#M9478 Clybersoft 2012-05-10T20:15:22Z Re: Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110929#M9479 <HTML><HEAD></HEAD><BODY><P>Please be more specific.&nbsp; SAS datasets store data as fixed length fields, so I am not sure of the context.</P><P></P><P>Doc Muhlbaier</P><P>Duke</P></BODY></HTML> Thu, 10 May 2012 20:19:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110929#M9479 Doc_Duke 2012-05-10T20:19:57Z Re: Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110930#M9480 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Thanks,</P><P>Yoda</P></BODY></HTML> Thu, 10 May 2012 20:27:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110930#M9480 Clybersoft 2012-05-10T20:27:30Z Re: Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110931#M9481 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; It's in the documentation for SCANTEXT and TypeGuessingRows.</P><P></P><P>I'm not sure how the EGuide import wizard does it, though I've generally found it to be accurate.</P><P></P><P>Doc Muhlbaier</P></BODY></HTML> Thu, 10 May 2012 20:38:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110931#M9481 Doc_Duke 2012-05-10T20:38:29Z Re: Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110932#M9482 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Appreciate it Doc,</P><P>Yoda</P></BODY></HTML> Thu, 10 May 2012 20:43:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110932#M9482 Clybersoft 2012-05-10T20:43:54Z Re: Variable vs Fixed https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110933#M9483 <HTML><HEAD></HEAD><BODY><P>in case of infile use lrecl=x not sure about EG</P></BODY></HTML> Tue, 22 May 2012 05:00:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Variable-vs-Fixed/m-p/110933#M9483 Petersas 2012-05-22T05:00:20Z