SAS

suppress date from ODS
Hi, I've this rather complex code (for me!) that uses GREPLAY and ODS to output a .PDF dashboard with a series of tables and charts. We have recently moved from SAS 9.1.3 to SAS 9.2 and when I run the code on SAS 9.2 it adds a date in the format "08:40 Wednesday, November 4, 2009 4" on the top right hand side of... 4 Nov 2009 15:18

Week Function
I like to see my week starts as Week - 1 from middle of year. Say --- Week=week(date); gives me below for time period 01jun2008 - 31may2009 ... Date Week 27jun2008 22 14Aug2008 32 09Jan2009 09 But i would like to arrange in order for time period 01jun2008 - 31may2009. Date ... 4 Nov 2009 14:12

Training and placement
Dear group members, I have some experience with SAS. We use SQL & SPSS at work, but i have done the same on SAS. What I am looking forward to work on SAS only. I work in delhi and have 4 years of experience in Research & Analytics domain. Are there good institutes/training center that if I join can secure good p... 4 Nov 2009 13:05

SAS/Connect not able to logoff mainframe under RACF
Dear SAS-L-ers, Bob Miller posted the following interesting problem: We use SAS/Connect to remotely logon to our mainframe & run SAS programs on that platform. We then download the data to the network for further processing in SAS running in Windows/XP. After we download our data, we do not ... 4 Nov 2009 13:05

update table
this is a first small test that works, however a new record is not added to the table data test; input a b ; cards; 1 2 3 4 5 6 10 58 15 20 ; run; data test1; input a b ; cards; 1 22 12 4 115 6 15 30 ; RUN; proc sql; update test k set b = (select l.b from test1 l where... 4 Nov 2009 08:35

update table
hi all, i have two tables i want to update master table ,i am wriing the code in proc it gives me following error. data test; input a b z; cards; 1 2 100 3 4 35 5 6 . 15 58 68 15 20 65 ; data test1; input a b c; cards; 1 22 1 12 4 2 115 6 3 15 20 4 ; proc sql UNDO_POLICY=NONE; update test t1 ... 4 Nov 2009 05:18

Reshaping Data
I have four variables: Location (x,y,z), q1, q2, and q3 (where each line is a different individual). q1,q2, and q3 are categorical variables (the respondent can answer: Disagree, Agree, or Strongly Agree). I would like to create a data set with the following variables: Location, Question (numeric variable ranging ... 3 Nov 2009 15:58

Proc pdlreg & class effects
Lorraine, Take a look at Example 20.1 Industrial Conference Board Data, in the online documentation for PROC PDLREG. I believe that they are treating "quarter" as a class variable here. The trick is to code it with dummy variables. What I don't see is how to get a joint significant test for all quarters, but you ... 3 Nov 2009 14:52

TABULATE Cell Formatting Problem
I am generating an item report in TABULATE, with items on a test down left-hand side and answer choices across the top (A, B, C, D), with the number and percent of student choosing each response in the cells of my table. I want to know if it is possible to format the cell (intersection of item and potential answe... 3 Nov 2009 10:23

tagsets.excelxp Password protect excel worksheets
Does anyone know if tagsets.excelxp has an option to password protect excel files rather than manually setting it up after running the export? thanks in advance. ... 2 Nov 2009 23:28