f



Re: old SAS guy with new SAS question

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of John F. Regus
> Sent: Sunday, November 16, 2008 7:19 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: old SAS guy with new SAS question
>
> You three were of the most help to an old man in simplifying
> how to get output from my PC file into a SAS dataset.
> However, when I did use the INPUT statement I coded INPUT  $.
>  thinking this would put everything into its natural place in
> the output SAS table.  Wrong.  It only got the first variable
> of 5 characters.
>
> I went through my "Little SAS Book" trying to find the answer
> to this but the "Little SAS Book" has an appropriate
> title...it is little and does not cover a lot of things.
> SAS help and documentation takes you over the hills and
> through the woods without getting to the point or even a
> concise answer.
>
> Here is my problem.
>
> I am reading a .csv PC flat file (I conquered the problem of
> reading the PC file into a SAS dataset by adding the INPUT
> statement...only not all the data goes through because I need
> to use columnar input instead of list input).
>
> The layout of the .csv PC flat file is somewhat like this,
> with the variable lengths inside each table entry looks
> something like this:
>
>                VAR1    VAR2     VAR3    VAR4    VAR5 etc.,etc.
>
> Row1      5$           1$         1$          8$          6$
>
> Row2      5$           2$         1$        18$          6$
>
> Row3      5$           4$         1$         10$         6$
>
> Row4      5$           4$         1$           6$         6$
>
> Row5      5$           3$         1$           9$         6$
>
> Row6      5$           1$         1$          12$        6$
>  ...and so on.
>
> Obviously, it is impossible to count each row of the .csv
> file and find the variables with varying lengths and then
> code an INPUT statement at exactly the number of rows the
> variables with the varying lengths were found in the PC file.
>  In my PC file, their are 72000+ lines of data (one month's
> worth of Demantech's NTSMF performance data).  So how do I
> code a DATA step that figures out there are variable length
> variables scattered throughout the PC flat file so that I can
> come back and code another DATA step  with names for the
> COLUMNS where all of the data resides?
>
> Any and all help would be appreciated, and I will try
> everything you say.
>
> JR
> Houston Texas
>
> BTW if you are wondering what I am doing, since I went on
> permanent disability retirement list, I did some part time
> teaching at the local university.  They need a course in
> performance management and capacity planning, and I am the
> only one, without a CS degree, because I graduated with my MA
> before CS was even a subject...so all of my education was
> from IBM, Amdahl, and ACTS Corp. that filled two single
> spaced typewritten pages.  I had actual hands on experience
> versus  theoretical which too many CS students are being
> filled with today, meaning when they go to work, their
> employers are going to have to send them off to IBM, AMDAHL,
> or ACTS to learn how to do real world systems engineering/programming.
>
John,

After your description, I still am not sure what you are trying to
accomplish.  I created a file (c:\temp\variable_length_data) with the
following data in it (to match your description of the data).

Row1      abcde           a         a          aaaaaaaa          aaaaaa
Row2      abcde           ab         b        aaaaaaaaaaaaaaaaaa
bbbbbb
Row3      abcde           abcd         c         cccccccccc         cccccc
Row4      abcde           abcd         d           dddddd         dddddd
Row5      abcde           abc         e           eeeeeeeee         eeeeee
Row6      abcde           a         f          ffffffffffff        eeeeee

If you set your variable lengths to be at least as large as the largest
string in your data, the file can read as follows

data want;
  length row var1-var5 $20;
  infile "c:\temp\variable_length_data.txt" ;
  input ROW VAR1  VAR2  VAR3 VAR4 VAR5;
run;

If this doesn't do what you want, you will need to give a representative
example of the input data and then an example of what you want the output
dataset to look like (based on that input data).

Hope this helpful,

Dan

Daniel Nordlund
Bothell, WA USA
0
djnordlund (157)
11/17/2008 4:33:21 AM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
870 Views

Similar Articles

[PageSpeed] 54

Reply:

Similar Artilces:

Re: old SAS guy with new SAS question #4
John, I think Ron Fehd was working on recreating MXG on the PC, though I'm not sure what he's using for input (I'm guessing they're all OS and monitoring tool specific). You might want to email him off-list to see what he's doing. But I think the couple of responses you've gotten so far should get you over the initial hump of reading in varying length variables. Let us know where we can help next--there are several of us on the listserv that either do MXG or lived and breathed MXG in the past. HTH, CH On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need...

Re: old SAS guy with new SAS question #3
On Sun, 16 Nov 2008 20:33:21 -0800, Daniel Nordlund <djnordlund@VERIZON.NET> wrote: >> -----Original Message----- >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On >> Behalf Of John F. Regus >> Sent: Sunday, November 16, 2008 7:19 PM >> To: SAS-L@LISTSERV.UGA.EDU >> Subject: old SAS guy with new SAS question >> >> You three were of the most help to an old man in simplifying >> how to get output from my PC file into a SAS dataset. >> However, when I did use the INPUT statement I coded INPUT $. >> thinking this would put everything into its natural place in >> the output SAS table. Wrong. It only got the first variable >> of 5 characters. >> >> I went through my "Little SAS Book" trying to find the answer >> to this but the "Little SAS Book" has an appropriate >> title...it is little and does not cover a lot of things. >> SAS help and documentation takes you over the hills and >> through the woods without getting to the point or even a >> concise answer. >> >> Here is my problem. >> >> I am reading a .csv PC flat file (I conquered the problem of >> reading the PC file into a SAS dataset by adding the INPUT >> statement...only not all the data goes through because I need >> to use columnar input instead of list input). >> >> The layout of the .csv PC flat file is so...

Re: old SAS guy with new SAS question #2
On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need to use columnar input instead of list input). > >The layout of the .csv PC flat file is somewhat like this, with the variable lengths inside each table entry looks something like this: > > VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. > >Row1 5$ 1$ 1$ 8$ 6$ > >Row2 5$ 2$ 1$ 18$ 6$ > >Row3 5$ 4$ 1$ 10$ 6$ > >Row4 5$ 4$ 1$ 6$ ...

Re: old SAS guy with new SAS question #5
On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need to use columnar input instead of list input). > >The layout of the .csv PC flat file is somewhat like this, with the variable lengths inside each table entry looks something like this: > > VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. > >Row1 5$ 1$ 1$ 8$ 6$ > >Row2 5$ 2$ 1$ 18$ 6$ > >Row3 5$ 4$ 1$ 10$ 6$ > >Row4 5$ 4$ 1$ 6$ ...

old SAS guy with new SAS question
You three were of the most help to an old man in simplifying how to get = output from my PC file into a SAS dataset. However, when I did use the = INPUT statement I coded INPUT $. thinking this would put everything = into its natural place in the output SAS table. Wrong. It only got the = first variable of 5 characters. I went through my "Little SAS Book" trying to find the answer to this = but the "Little SAS Book" has an appropriate title...it is little and = does not cover a lot of things. SAS help and documentation takes you = over the hills and through the woods without getting to the point or = even a concise answer. Here is my problem. I am reading a .csv PC flat file (I conquered the problem of reading the = PC file into a SAS dataset by adding the INPUT statement...only not all = the data goes through because I need to use columnar input instead of = list input). The layout of the .csv PC flat file is somewhat like this, with the = variable lengths inside each table entry looks something like this: VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. Row1 5$ 1$ 1$ 8$ 6$ =20 Row2 5$ 2$ 1$ 18$ 6$ Row3 5$ 4$ 1$ 10$ 6$ Row4 5$ 4$ 1$ 6$ 6$ Row5 5$ 3$ 1$ 9$ 6$ Row6 5$ 1$ 1$ 12$ 6$ ...a...

Re: Old SAS Guy needs help with some of these new fangled SAS
Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sleepless afternoons. > >I know that I can import just about any file imaginable into SAS using the import function using SAS Windows 9.1.3. >However, when trying to get comma seperated values moved all at once into the new SAS file, >I can (or only know how to get) the data for one variable moved at a time. I would like to do a mass >move of all the data from the input file into the new SAS file. Is there a way to do this? Because once > I have imported the file into a new SAS file, established variable names, established formats, informats, >variable lengths, etc. I would like to be able to save the settings for the next like file that I want to import into what I have >already slaved over doing, defining, etc., without repeating the process. > >Is there a way to do this? > >Waiting with bad breath on the sidelines. > >The Old SYS/390 guy >"SAS was originally invented for computer performance and capacity planning for the SYS/3x0 IBM machines... >they sure have taken it into new features that are amazing&...

Re: Old SAS Guy needs help with some of these new fangled SAS #2
It's been a while since I used the Import Wizard but as I recall, there is a window which asks for a file name where SAS can store the input statments for your future use. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Jim Groeneveld <jim.1stat@YAHOO. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Old SAS Guy needs help with some of these new fangled SAS 12/02/2008 04:49 9.1.3 gizmos for Windows AM Please respond to Jim Groeneveld <jim.1stat@YAHOO. COM> Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sl...

Old SAS Guy needs help with some of these new fangled SAS 9.1.3
Greetings all who have helped me in the past. Here is something that has been bothering me unending and is causing me = sleepless afternoons. =20 I know that I can import just about any file imaginable into SAS using = the import function using SAS Windows 9.1.3. =20 However, when trying to get comma seperated values moved all at once = into the new SAS file, I can (or only know how to get) the data for one variable moved at a = time. I would like to do a mass=20 move of all the data from the input file into the new SAS file. Is = there a way to do this? Because once I have imported the file into a new SAS file, established variable = names, established formats, informats, variable lengths, etc. I would like to be able to save the settings for = the next like file that I want to import into what I have already slaved over doing, defining, etc., without repeating the = process. Is there a way to do this? Waiting with bad breath on the sidelines. The Old SYS/390 guy "SAS was originally invented for computer performance and capacity = planning for the SYS/3x0 IBM machines... they sure have taken it into new features that are amazing" I'm not sure I understand your question but it sounds like you're importing data using an wizard and you want to do it using command syntax. See http://www.ats.ucla.edu/stat/sas/faq/default.htm, I think that can help you. (Maybe http://www.listerine.com/ could help as well?) Good luck, John Hendrickx Statistician Cl...

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: New old SAS guy needs help
You created data sets, but with nothing in them. You need INPUT statements. On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. > >I used to use SAS 20 years ago. I have apparently forgetten everything. > >This is the log. >4066 data smf1; >4067 INFILE datalines DLM=',' DSD truncover; > >4068 datalines; > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.03 seconds > >cpu time 0.00 seconds > >6097 run; > >This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails > >SAS LOG > >NOTE: SAS 9.1.3 Service Pack 4 > >NOTE: SAS initialization used: > >real time 1.15 seconds > >cpu time 0.70 seconds > >1 Filename Smfdata 'c:\ntsmf24'; > >2 data 'smf1'; > >3 INFILE datalines DLM=',' DSD truncover; > >4 datalines; > >NOTE: The data set smf1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.01 seconds > >cpu time 0.01 seconds > >2033 run; > >2034 data &#...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the lan...

Re: New old SAS guy needs help #2
John, I'm sure you have provided sufficient information so that you will get a solution from one or more of the sharper tacks on SAS-L. But what want to know is what happened in 1988 that made SAS drop out of sight? Joe On Thu, Nov 13, 2008 at 10:00 PM, John F. Regus <jfregus@ix.netcom.com>wrote: > Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > I used to use SAS 20 years ago. I have apparently forgetten everything. > > This is the log. > 4066 data smf1; > 4067 INFILE datalines DLM=',' DSD truncover; > > 4068 datalines; > > NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > NOTE: DATA statement used (Total process time): > > real time 0.03 seconds > > cpu time 0.00 seconds > > 6097 run; > > This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > SAS LOG > > NOTE: SAS 9.1.3 Service Pack 4 > > NOTE: SAS initialization used: > > real time 1.15 seconds > > cpu time 0.70 seconds > > 1 Filename Smfdata 'c:\ntsmf24'; > > 2 data 'smf1'; > > 3 INFILE datalines DLM=',' DSD truncover; > > 4 datalines; > > NOTE: The data set smf1 has 1 obser...

Re: New old SAS guy needs help #3
Indeed, an input statement is needed to define the variables: data smf1; INFILE datalines DLM=',' DSD truncover; input var1 var2 var3 var4 var5 ... etc. datalines; (your datalines) run; -Joe On Thu, Nov 13, 2008 at 9:18 PM, Howard Schreier <hs AT dc-sug DOT org> < schreier.junk.mail@gmail.com> wrote: > You created data sets, but with nothing in them. You need INPUT statements. > > On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> > wrote: > > >Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > > >I used to use SAS 20 years ago. I have apparently forgetten everything. > > > >This is the log. > >4066 data smf1; > >4067 INFILE datalines DLM=',' DSD truncover; > > > >4068 datalines; > > > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > > >NOTE: DATA statement used (Total process time): > > > >real time 0.03 seconds > > > >cpu time 0.00 seconds > > > >6097 run; > > > >This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > > >SAS LOG > > > >NOTE: SAS 9.1.3 Service Pack 4 >...

Re: New old SAS guy needs help #5
I typically use INFILE when I am reading from an external file. So, I would not have a datalines statement. What you need is an input line with the variables names. The datalines is a keyword to let SAS know that the data are to be read in the subsequent lines, but if you're reading from an input file, you won't be entering data from the editor window. Warren Schlechte -----Original Message----- From: John F. Regus [mailto:jfregus@IX.NETCOM.COM] Sent: Thursday, November 13, 2008 9:00 PM Subject: New old SAS guy needs help Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. I used to use SAS 20 years ago. I have apparently forgetten everything. This is the log. 4066 data smf1; 4067 INFILE datalines DLM=',' DSD truncover; 4068 datalines; NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 6097 run; This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails SAS LOG NOTE: SAS 9.1.3 Service Pack 4 NOTE: SAS initialization used: real time 1.15 seconds cpu time 0.70 seconds 1 Filename Smfdata 'c:\ntsmf24'; 2 data 'smf1'; 3 INFILE datalines DLM=',' DSD truncover; 4 datalines; NOTE: T...

Re: New old SAS guy needs help #4
You don't have to specify the length in the input statement; using DLM takes care of that. Just make sure they are defined as long enough ahead of time for the longest possible string. var1 $ var2 var3 var4 $ will read in four variables, first and last as strings, and with whatever length is appropriate up to the max length those variables are predefined as ($200. for characters, 8 bytes for numerics, by default I think). No idea why you would get a file not found error ... did you put the filename in quotes? infile "c:\testfile.dat" dlm=',' lrecl=800 pad; should be the statement... test it with a file on a local drive that has a simple name to make sure you have the syntax down, I'd say (and perhaps rename the file and pull it locally if it's on a network drive, to see if that's the problem). -Joe On Fri, Nov 14, 2008 at 1:42 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > Joe thanks. I have two questions though. I did not include my SAS log > when I was trying to get the data from a PC file and kept getting the error > that the PC file could not be found, and yes, I MK-1 eyeballed that file > name backwards and forwards to make sure that it was right, yet I got the > message the PC file could not be found. > The second question is...this SAS program will be used over and over > (hopefully)...and some of the variables are variable length so putting an > INPUT statement in with var1 5 $ var2 4 etc. m...

Re: SAS Intrnet question, passing macro variables to SAS.
Jia, You have to mask tokens that appear in pairs. In your example precede the single quote (') with a % sign. Try: &libdata=test&citystate=%str(%'Birmingham, AL%',%'Dothan, AL%',%'Huntsville,AL%') Nikhil Sardesai -----Original Message----- From: Michael L. Davis [mailto:michael@BASSETTCONSULTING.COM] Sent: Friday, January 28, 2005 5:13 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: [SAS-L] SAS Intrnet question, passing macro variables to SAS. Hello Jia and other SAS-L Friends, I'm not sure I know the answer but I have some ideas. However, first, I have a question. Are you building the URL outside of an HTML form? If you are, the following link on the SAS web site might interest you: http://support.sas.com/faq/039/FAQ03925.html You might also want to look at the following link: http://support.sas.com/rnd/web/intrnet/dispatch82/input.html Look at the section titled "Specifying Name/Value Pairs in a URL". Most likely, the ampersands might be playing a role. SAS/IntrNet strips off "unsafe characters" unless you tell it not to do so. Please see: http://support.sas.com/rnd/web/intrnet/dispatch82/srvusaf.html Part of that link states: The APPSRV_UNSAFE function returns the complete, original value of an input name/value pair. Normally unsafe characters (see the UNSAFE option) are stripped from input values before creating the input macro variables. This is done so that macro variables may be freely used in a a...

Re: New old SAS guy needs help #8
My bad. I forgot to use the Input line. Yes, you do need to tell SAS how many variables there are and their names and their informats/formats. I hate that windows hides extensions. You're not the first to run into the problem because the full filename was not displayed. Warren Schlechte -----Original Message----- From: John F. Regus [mailto:jfregus@ix.netcom.com] Sent: Friday, November 14, 2008 3:13 PM To: Warren Schlechte Subject: Re: Re: New old SAS guy needs help That is almost correct. The LIBNAME statement and the rest of the SAS program was: Libname Smfdata 'C:\NTSMF24'; Data Smfdata.smf1; Infile 'C:\NTSMF24\JFREGUS.200811132007' DLM=',' DSD truncover; run; And after running was when I got the SAS Log message dataset not found. I can run it again and get the full SAS Log. ++++ I contacted Demandtech and found that the PC file extension is smf and it does not show up in either Windows Explorer (details) or ISPF/PC I ran the job and this time I got NOTE: Libref SMFDATA was successfully assigned as follows: Engine: V9 Physical Name: C:\NTSMF24 10 Data Smfdata.smf1; 11 Infile 'C:\NTSMF24\JFREGUS.200811131700.smf' DLM=',' DSD truncover; 12 run; NOTE: The infile 'C:\NTSMF24\JFREGUS.200811131700.smf' is: File Name=C:\NTSMF24\JFREGUS.200811131700.smf, RECFM=V,LRECL=256 NOTE: 0 records were read from the infile 'C:\NTSMF24\JFREGUS.200811131700.smf'. NOTE: The data set SMFDATA.SMF1 has 1 observatio...

Re: New old SAS guy needs help #6
single or double quotes are the same around the physical filename. Could it be that you have some invisible chars around your file? Is it possible to use a editor or something to look into the file? Did you try to copy / paste the name? You could also try to use a filename-function to define a logical filename on that physical file. That brings a returncode which should be 0 if it is ok. In that case the reference seems to work. if there is something different, the problem could be analyzed further. Gerhard On Fri, 14 Nov 2008 10:17:37 -0600, Joe Matise <snoopy369@GMAIL.COM> wrote: >I doubt it, I use double quotes except when I need to prevent macro variable >resolution but they are identical otherwise. > >-Joe > >On Fri, Nov 14, 2008 at 10:14 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > >> Thanks Joe...I noticed you put your PC file name in double quotes, I only >> had mine in single quotes...was that the reason the file was not found? >> ----- Original Message ----- From: "Joe Matise" <snoopy369@GMAIL.COM> >> To: <SAS-L@LISTSERV.UGA.EDU> >> Sent: Friday, November 14, 2008 9:07 AM >> >> Subject: Re: New old SAS guy needs help >> >> >> You don't have to specify the length in the input statement; using DLM >>> takes >>> care of that. Just make sure they are defined as long enough ahead of >>> time >>> for the long...

Re: New old SAS guy needs help #7
I doubt it, I use double quotes except when I need to prevent macro variable resolution but they are identical otherwise. -Joe On Fri, Nov 14, 2008 at 10:14 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > Thanks Joe...I noticed you put your PC file name in double quotes, I only > had mine in single quotes...was that the reason the file was not found? > ----- Original Message ----- From: "Joe Matise" <snoopy369@GMAIL.COM> > To: <SAS-L@LISTSERV.UGA.EDU> > Sent: Friday, November 14, 2008 9:07 AM > > Subject: Re: New old SAS guy needs help > > > You don't have to specify the length in the input statement; using DLM >> takes >> care of that. Just make sure they are defined as long enough ahead of >> time >> for the longest possible string. var1 $ var2 var3 var4 $ will read in >> four >> variables, first and last as strings, and with whatever length is >> appropriate up to the max length those variables are predefined as ($200. >> for characters, 8 bytes for numerics, by default I think). >> >> No idea why you would get a file not found error ... did you put the >> filename in quotes? >> >> infile "c:\testfile.dat" dlm=',' lrecl=800 pad; >> >> should be the statement... test it with a file on a local drive that has a >> simple name to make sure you have the syntax down, I'd say (and perhaps >&g...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspecti...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #7
Well Toby, let me ask something then. Since I am not an ODS fan and haven't used proc report/tabulate for some time, would that be an automatic disqualifier since you don't allow reference books or materials? SAS does not provide tools that help me code ODS (except for EG) and therefore a reference material is all I would need. Now, it's not like I haven't used proc report (used it extensively at one time), it's just that I prefer other means to produce the final output. It seems that a test like this would toss me out of the pool from the get-go. Heck, maybe that's wh...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #8
On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin Viel, PhD Post-doctoral fellow Department of Geneti...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #10
I actually think you are straight-jacketing the interview for a senior person. I would definitely look for someone who thought outside of the box. That may be ways of doing things other than macros or ODS or else putting a new spin on them. I ditched most of the macro language a decade ago, for example. As a hiring manager, I always went for creativity and not specific skills on hand and was very pleased with my hires. But hey, I don't hire anymore so it isn't something I have to face. BTW, no client has ever asked me for certification nor have I been quizzed on specific SAS knowledg...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #11
Kevin, Thank you for the nice words...I am sure I wouldn't have a chance on any stat exam, BTW. What I am good at is being in an absolute crisis and trying to get it solved with no time on the clock. That is why I think in a quirky manner. When the obvious isn't working, take a different path because there is simply no time left. It's what I did at MCI, SAS, and now as an independent. ....and that skill will not be measured on a certification exam or plopping me in front of a PC to hammer out an example SAS program. For any candidate, I can pick up their technical level with a few questions and watching their reactions. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kevin Roland Viel Sent: Tuesday, September 04, 2007 4:02 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin ...

Web resources about - Re: old SAS guy with new SAS question - comp.soft-sys.sas

West Lothian question - Wikipedia, the free encyclopedia
He illustrated his point by pointing out the absurdity of a Member of Parliament for West Lothian being able to vote on matters affecting the ...

NDP MP Niki Ashton Gives Master Class In Dodging Questions About Mulcair 0
"We have a lot of work ahead of us, and the leadership review is part of that." The hardest-hitting questions for NDP MPs lately have nothing ...

Lawyers Question JWT Investigation, Seek to Submit Video Evidence
Lawyers for Erin Johnson, who filed a suit in New York last week against JWT and its Chairman-CEO Gustavo Martinez over alleged racist and sexist ...

Question of the Day: Greatest hood ornament of all time?
Filed under: Etc. , Automotive History From leaping carnivores to flying princesses, the automotive world has produced some great hood ornaments. ...

Alphabet: Morgan Stanley Has Five Questions for Their Cloud Conference
Morgan Stanley‘s Brian Nowak today reiterates an Overweight rating on shares of Alphabet (GOOGL), arguing the company’s cloud computing service ...

On "Face the Nation" today, John Dickerson asked Donald Trump a question about law that I — being in ...
From the transcript: DICKERSON: At the debate, you talked about H-1B visas. You said: "It's something I, frankly, use, and I shouldn't be allowed ...

What's the top Google search question about Donald Trump?
Google is tracking the top trending questions about the presidential candidates on the search engine in Florida and Ohio Tuesday

10 questions to ask analytics vendors (before you buy)
Analytics purchase decisions are littered with opportunities for missteps. These 10 questions will help ensure you get off on the right foot. ...

Activists question United CEO's role, pay
Two hedge funds that launched a boardroom fight with United oppose plans to give its CEO the role of chairman and have concerns about his pay. ...

Hearing on Visa Overstays Yields More Questions Than Answers
With 523,000 visa overstays a year, why can't the federal government do a better job of tracking people who don't leave the country when their ...

Resources last updated: 3/16/2016 4:15:37 PM