datanull's articles:

Items(2158) /216 Next >> Last >|

PROC SETINIT #2 0 35 (8/2/2008 1:21:58 PM) comp.soft-sys.sas proc setinit noalias; run; ... datanull

Re: Regex #2 0 31 (8/2/2008 12:28:35 PM) comp.soft-sys.sas I don't want to spoil you REGEX fun, the regExperts can help you with that, but they are sleeping in. You can read the data using a very old SAS feature called "named" input. It is a little fiddly with the Co... datanull

Re: Formating a Macro value ?? #9 0 35 (8/2/2008 12:26:50 AM) comp.soft-sys.sas The other day I was looking at LOGPARM system option. I allows a nice log naming feature and a way to cause a new log to be created with an options statement if I'm not mistaken. I don't recall all the detail... datanull

Re: Deleting all external files with particular extension without #4 1 37 (8/1/2008 11:25:55 PM) comp.soft-sys.sas From this small test NOX means NOX as you suspected. You can still use the DREAD to accomplish a wildcard like pass over the directory members. 28 dm 'clear log'; 29 proc options option=xcmd define value;... datanull

Re: How to resolve Date Macro Variables 0 37 (8/1/2008 8:56:50 PM) comp.soft-sys.sas I think SYSEVALF is a good choice. 534 %let maxend=31MAR2008; 535 %let maxend1=30JUN2008; 536 %put NOTE: %sysevalf("&maxend"d wrote: > All > > I have this code and I would like to compare two dates and do... datanull

Re: one data step #3 0 41 (8/1/2008 7:21:26 PM) comp.soft-sys.sas Data _null_; set orders; call execute('%nrstr(%Summary('|| Order ||'));'); call execute('%nrstr(%Percentages('|| Order ||'));'); run; Is it is often "good" to delay execution of the macro until... datanull

Re: SAS DDE help #4 0 27 (8/1/2008 6:57:12 PM) comp.soft-sys.sas Mary is too generous. I will claim most annoying contributor. Especially now that Cassell is not around asking "why do you want to that?" all the time. I take it that you chose to look more closely a Mike Zde... datanull

Re: Deleting all external files with particular extension without 0 48 (8/1/2008 5:02:14 PM) comp.soft-sys.sas Does that mean no OS commands. Or just no X. I usually us the PIPE access method instead of X. No flashing windows. or SYSTASK no flashing windows either. If you must use the SAS file functions. Look at DRE... datanull

Re: SAS interview TEST questions #3 0 48 (8/1/2008 4:11:18 PM) comp.soft-sys.sas The subject is vast. I would work on knowing what I think know. In other words examine your skill set. Lets say that is data step. (set merge) proc sort proc summary ods (depending on how you use it) proc r... datanull

Re: parse varlist to generic macro variables #3 0 37 (8/1/2008 3:58:15 PM) comp.soft-sys.sas I don't know what you are trying to do. So please tell us more. Not about what you think you need but the big picture. It will help you by having to explain your process in more detail plus we will understan... datanull

datanull's replies:

Items(755) /76 Next >> Last >|

Comparing start and stop dates 3 281 (8/11/2010 6:55:10 PM) comp.soft-sys.sas Hello, I have a problem where i have a popuation taking drugs and there are multiple start and stop dates for each drug. I need to create a any drug use start and stop date, drg1_stdt1 = 1/1/2010, drg1... VG

%do ind=a %to z; in Macro 2 150 (8/12/2010 7:25:09 AM) comp.soft-sys.sas How can I use %do ind=a %to z; in Macro? I have tried %do ind="a" ,"b" ,"c" ,"d" ,"e" ,"f" ,"g" ,"h" ..."z"; but still failed ... litonchen (27)

Preserving leading blanks when importing Excel sheet 4 741 (8/12/2010 7:35:55 AM) comp.soft-sys.sas Hi All, Hoping someone can shed some light on an issue I am encountering at work. I am attempting to import an Excel sheet into SAS (enterprise guide 4.1 on Windows 2000 server, using a code node) using... jarrad.taylor (1)

Reading variable length file 10 245 (8/12/2010 1:21:20 PM) comp.soft-sys.sas I've searched for this answer but I'm not sure if I'm looking for the right thing. I'm reading data from a table with both a fixed segment and variable segment. I can read from the fixed segment just fine b... eric_solomon (4)

Update a dataset 6 112 (8/12/2010 5:40:19 PM) comp.soft-sys.sas Hi All, This is a real problem: There is a dataset A which is updated everyday through user interaction. Next day, I run a query to subset A and get data set B. Now I have to run query everyday to ge... kwu0914 (40)

How to create a date informant? 7 227 (8/16/2010 7:32:41 PM) comp.soft-sys.sas I have successfully created a DATETIME format named "FullTime" using the following code fragment: PROC FORMAT; PICTURE FullTime LOW-HIGH = '%Y-%0m-%0d %0H:%0M' (DATATYPE = DATETIME); RUN; It... eliasrk (84)

Output/generate Record - Incremental Data 5 134 (8/18/2010 8:10:07 AM) comp.soft-sys.sas Hi all. I have the following challenge. We deal with incremental data set i.e. Will only receive a record as and when the customer data changes, however I need to "force" ,"output" a month end record for e... JanineJDL

Calculating change in a measure between visits 1 214 (8/18/2010 4:16:22 PM) comp.soft-sys.sas Dear All: I want to calculate the change in ht between clinic visits. Data have: ID Visit Htcm Ageyrs 1 1 90 1.0 1 2 100 1.4 2 1 120 2.0 2 ... Yaw

Proc Compare 4 231 (9/1/2010 2:53:30 PM) comp.soft-sys.sas All: I have two data vendors working on same clinical study providing the data extracts for different set of patients . i would like to do a proc compare of both the data extracts and compare if there ... ali6058 (166)

Parsing a macro string like AA BB "aa dd" CC 3 141 (9/12/2010 1:13:06 PM) comp.soft-sys.sas Suppose I have a macro string like this which are items I want to identify one at a time but sometimes if there is a space in the item then it will be quoted: %let str=AA BB "aa dd" CC; I want to do som... RolandRB