SAS

Macro Program to mimic "lines"
In retrospect, it wouldn't need to be as complicated as I had originally thought. If I could just get a macro to create a data table like this: table4: LINE1 LINE2 LINE3 LINE4 dependent Mean Eqp1 Eqp2 Eqp3 Eqp4 Eqp5 Eqp6 A p1 5.7 1 1 0 0 0 0 A p... 26 Feb 2010 13:02

access Sharepoint from SAS/Base 9.1
Hi there, I'm using a Sharepoint site for storing documents etc and I am wondering if I can access Sharepoint from SAS/Base 9.1 to store datasets etc. I can access the shared documents on the site using a web folder, so I can move files to and from the Sharepoint site using drag and drop. I found a nice examp... 25 Feb 2010 14:49

SASMSG FUNCTION
Can anyone tell me wht %sysfunc(samsg()) does? Also wht is the exact syntax for it? ... 24 Feb 2010 08:36

PROC EXPORT in SAS/Server
Hi, I'm at a new job that has SAS/Server. I believe it's 9.1.3. I'm trying to PROC EXPORT a file to Excel. I'm using code identical to what works in SAS for PC. PROC EXPORT DATA=sasdataset OUTFILE=".\OutputExcelFile.xls" DBMS=EXCEL REPLACE ; SHEET="NewSheet"; RUN; For some reason, this... 23 Feb 2010 23:50

Drop down to SCL and R in your datastep
Hi SAS-Lers, Clark An posed this problem data mat; do i=1 to 10; do j=1 to 15; do k=1 to 100; do l=1 to 20; do m=1 to 17; do n=1 to 23; X&i&j&k&l&m&n=&i+&j+&k+&l+&m+&n; output; end; end; ... 3 Mar 2010 08:26

Problem with the "contents" option in tagsets.excelxp
Hi all, Here is my environment: OS: Windows 7 64-bit Application: SAS 9.2 ExcelXP tagsets version 1.94 I am trying to use the ODS tagsets.excelxp to output data from a TABULATE procedure using the options (sheet_interval = 'bygroup' contents = 'yes'). The generated "contents" worksheet does not have valid hy... 23 Feb 2010 17:02

Proc Template
Do you have another SAS session open? If so, close it, you'll be fine. On Tue, 23 Feb 2010 11:50:08 -0800, SAS_learner <proccontents(a)GMAIL.COM> wrote: Hello all, I am running a program which has Proc Template inside the Program Code. I ran this for one study and it was fine. But for the study I am work... 24 Feb 2010 13:07

Ordinal logistic regression
Hello All. I would like to predict the probabilities of the order in which each of n employees come in to work, 1st, 2nd, 3rd. Based off of variables like waking time (in min before work begins), distance to place of employment (miles), commute method (categorical 1 =bus, 2=train, etc), avg commute time ( in mi... 23 Feb 2010 13:33

Cannot Allocate a SAS Library in Interactive SAS(TSO)
Hello, I am trying to allocate a SAS dataset in interactive SAS on a Z/OS mainframe. I can view the dataset if I run a batch job however I get the following error when running interactive SAS. ERROR: SVC99 error rc=4, reason=0218 : IKJ56221I DATA SET XXXXXXXXXXXX NOT ALLOCATED, VOLUME NOT AVAILABLE+IKJ562... 24 Feb 2010 09:43

SAS connect issues after SAS version upgrade to 9.2 on the server
hi We use a windows server and tried to upgrade our server license to 9.2 (we had SAS 9.1.3 earlier). But after the upgrade when we tried to SAS connect we got the following error "A communication subsystem partner link setup request failure has occurred. Read error". We also tried to upgrade the SAS spawner ... 23 Feb 2010 10:09