About Tom

Tom · ‎11-08-2011

Looks like the du command is using tab ('09'X) as the delimiter between the number and the directory name. This is consistent with what I have seen from the unix command du. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 CHAR 89../SAS_Scripts 16 ZONE 3302254555676777 NUMR 899EF313F3329043 2 CHAR 1824../sizing 13 ZONE 3333022767666 NUMR 18249EF39A9E7 Change your INFILE statement to use tab as a delimiter. infile xlogcmd DLM='09'x truncover;

Tom · ‎11-06-2011

Here is the Microsoft page on associating actions (or verbs). http://msdn.microsoft.com/en-us/library/cc144175%28v=vs.85%29.aspx It really seems that Microsoft has made this much more difficult to manage.

Tom · ‎11-04-2011

It is a Windows thing. From Windows Explorer select Tools -> Folder Options. Then select File Types tab. Look for the the .sas files in the registered file types list and highlight it. Hit the ADVANCED button. You should now see all of the actions associated with the file. You can try just changing which one is marked as the default, but I have in the past found that some windows actions insist on calling the one that is named "open". You can just rename them or re-create them with different names. How this works on different versions of Windows I am not sure. We are still running XP.

Tom · ‎11-04-2011

You could see if PROC GPLOT has any ODS output datasets by using ODS TRACE statement. Otherwise you could fall back to the old method of redirecting the log to a file and reading it with a datastep. filename templog temp; proc printto log=templog; run; proc gplot ... run; quit; proc printto log=log; run; data _null_; infile templog ; input @; * put a copy of the log back into the real log ; put _infile_ ; .... look for the regression results ... run;

Tom · ‎11-04-2011

In that case build a space delimited list. You need at least SAS 9.2 to allow ranges of dataset names. proc sql noprint ; select memname into :append separated by ' ' from dictionary.members where libname='WORK' and memname like 'D%' order by memname ; quit;

Tom · ‎11-02-2011

How about putting them into groups? Requires sorting so if your data is really large might not be reasonable. data groups ; set have; by id1 v1-v3 ; group + first.v3; run;

Tom · ‎11-02-2011

I have never worked with TSO connection scripts, but most of the problems I have had with connecting to Unix, VMS, Windows machines have been either unexpected responses from the host or time-out issues. For time-out issues you can increase the time that it waits for the next prompt. For the others you can look at what your host is sending and see if you can figure out how to get to the right point to send the username, password, sas command etc. So you might need to add some more waits to get past extra levels of prompts from the host. You might need to change the string that the script is waiting for because your system uses a different prompt. Or the string you are waiting for is included in the banner message so SAS sends the response too early and the remote is not ready.

Tom · ‎11-02-2011

Proc POWER also has number lists. Perhaps this can be used to expand a list of values? Number-Lists A number-list can be one of two things: a series of one or more numbers expressed in the form of one or more DOLISTs, or a missing value indicator (.). The DOLIST format is the same as in the DATA step language. For example, for the one-sample test you can specify four scenarios (30, 50, 70, and 100) for a total sample size in any of the following ways. NTOTAL = 30 50 70 100 NTOTAL = 30 to 70 by 20 100 A missing value identifies a parameter as the result parameter; it is valid only with options representing parameters you can solve for in a given analysis. For example, you can request a solution for NTOTAL: NTOTAL = .

Tom · ‎11-02-2011

Did you look at the PARMS statement for GLIMMIX, VARIOGRAM etc? The syntax is a little different but if there is anyway to get it to generate the values and output them into a dataset then you could pull those values into a space delimited values to use for the ARRAY statement.

Tom · ‎11-02-2011

Edit your .scr file and turn on TRACE and ECHO. Normally the ones from SAS already have the trace on; echo on; commands in them, but they are commented out. If you do not see anything obviously wrong in the responses from your mainframe then open a ticket with SAS support and they should be able to help you more detail.

Tom · ‎11-02-2011

You can set an IP address. options helphost='1.2.3.4';

Tom · ‎11-02-2011

You will want to use the DATEPART, TIMEPART, and DHMS functions. datetm3 = dhms(datepart(datetm1),0,0,timepart(datetm2));

Tom · ‎11-01-2011

Are there other statements or procedures that allow a similar syntax for specifying values? That could be used to help determine the number of values specified. Value labels for an AXIS statement perhaps? Someone with REGEX skills might be able to convert the string to a series of 1's and + signs so that %EVAL() could count the number of terms. %let parm= (4*40 3*(3*7 8 9 10)); %let parm2=(4*1+3*(3*1+1+1+1)); %let nparm=%eval(&parm2); %put nparm=&nparm; nparm=22

Tom · ‎11-01-2011

Perhaps a recursive macro to parse the initialization string and count the number of entries? Might not be too hard for numeric values.

Tom · ‎11-01-2011

If it is just the first line with the column headers then import it without names and with the FIRSTOBS=2 option to skip that line. data want ; infile 'myfile.csv' dsd dlm=',' truncover firstobs=2; input col1-col20; run;

Online Status	Online
Date Last Visited	3m ago