SAS

VNEXT and HOH: Was(question for proc freq)
Yesterday "Proc Me" and I were discussing using associative arrays for counting, similar to PROC FREQ. I thought this HOH to produce One Way Freqs was mildly interesting. It demonstrates using VNEXT to aquire variable names at data step runtime then uses that information to declare the hashes to accumulate the... 4 Feb 2010 11:06

Parsing out Dates
Forgive my ignorance but I can't remember how to select out and categorize dates. I have a variable which is in a date format 09/21/2005 for years 1994 - 2006 and want to categorize the frequencies into year groups. I know I can use the IF-THEN-ELSE statement but can't seem to get the format for the dates correct... 4 Feb 2010 11:06

proc phreg
Hi, My question is : in term of interpretation what i the difference between these two case in proc phreg : proc phreg data=table; model (start, stop)*censor(0)=group; run; and proc phreg data=table; model duration*censor(0)=group; run; start: start day of follow up period stop: day on onset of ... 4 Feb 2010 08:52

Assigning value to a variable in proc sql
Hello all; I am using proc sql to join two datasets in SAS 9.1.3. The two datasets have a common variable 'category'. The variable has the value 'A' in one dataset and 'B' in the other. I would like to retain the variable in the new dataset but assign a new value, say 'C'. Any suggestions as to how this cou... 4 Feb 2010 07:45

SQL update/insert
dear all, to use in SAS SQL an update/insert you have to specify UNDO_POLICY=OPTIONAL But because of this i get a WARNING in the log and on mainframe this gives a RETURN CODE 4! HoW can i push this RC to 0 (zero) ?? Regards, Herman ... 5 Feb 2010 12:49

Are these SAS date functions
They're not SAS date functions, and that's why they don't work. date=oijehbwek() won't work either. SYSDATE and SYSTIME and macro variables, not functions - the closest function equivalents are DATE() and TIME(). months_between can be done with the INTNX function. NEXT_DAY is just date()+1. monname and downa... 4 Feb 2010 09:58

Solutions Manuals
I have solutions manuals to all problems and exercises in these textbooks. To get one in an electronic format contact me at: kalvinmanual(at)gmail(dot)com and let me know its title, author and edition. Please this service is NOT free. solutions manual to A Course in Game Theory by Osborne, Rubinstein solutions... 3 Feb 2010 21:54

ERROR: Unable to import, file c:\&expfile.XLS does not exist
Hi, I am trying to collect a file name from a field but the variable does not seem to get translated. My source dataset only has one record in so should pick it up ok. proc sql; select name into :expfile from exportfilec; quit; proc import datafile = 'c:\&expfile.' out=work.fields_tmp1; run; 99 proc... 3 Feb 2010 17:24

This is how I do adverse events summaries,
Dear SAS-L, When creating Clinical reports that are summarized by unique subjects by levels, adverse events summaries for example, I have yet to find a flexible solution. My best attempt so far is given below, but I would like to not have to call a macro as many times as the number of levels I want it summari... 3 Feb 2010 15:08

SAS XML MAPPER: reading large xml files and no SAS output
Hi, Before, I had been using for sometime with SAS XML MAPPER to create SAS map files and read XML files with no problem. I had tested such conversion from XML to SAS tables with small data (in fact small chunks of XML reads, but many of them ) and the conversion had been successful for many times. Now I have... 3 Feb 2010 15:08