snoopy369's articles:

Items(1611) /162 Next >> Last >|

Re: View files with SAS extension in SAS explorer 0 31 (3/9/2010 10:49:24 PM) comp.soft-sys.sas The SAS explorer shows you sas datasets (.sas7bdat), not programs (.sas). Open program... wil let you open SAS programs (From the file menu). -Joe On Tue, Mar 9, 2010 at 4:37 PM, franwdwyer@googlemail.com wr... snoopy369

Re: OT: Chance to Make SAS-L History: Did You Know That... #263 0 24 (3/9/2010 7:35:05 PM) comp.soft-sys.sas Looks to me that it's just an interface with a BI server, so not really 'running SAS' on the iPhone, though certainly cool. The app exists, though I don't have BI so couldn't say if it works. That said, you c... snoopy369

Re: Command that runs at DOS prompt does not run when using X 0 32 (3/9/2010 5:21:26 PM) comp.soft-sys.sas Are you sure you're running the X command and the DOS prompt in the same folder? Perhaps CLIP is not in a directory in the path? -Joe On Tue, Mar 9, 2010 at 11:02 AM, js8765 wrote: > Hi there, > > I was wo... snoopy369

Re: SAS, Mac & VMWare Fusion 0 26 (3/9/2010 5:20:03 PM) comp.soft-sys.sas I've tested it in Parallels, but not VMWare Fusion. In Parallels, 9.2 works fine on Windows 7 with no difficulty versus a normal Win7 installation. I would venture to guess this could be either a VMWare issue... snoopy369

Re: PROC FORMAT #13 0 29 (3/9/2010 4:36:42 PM) comp.soft-sys.sas Your use of letters instead of words is confusing but it sounds like perhaps you need Y to be also a class variable (in which case you can't do sums on it)? Which variable is 'goods'? -Joe On Tue, Mar 9, 201... snoopy369

Re: Nobyline- table is splitting 0 50 (3/5/2010 9:02:45 PM) comp.soft-sys.sas I think PAGESIZE is your culprit: proc sort data=sashelp.class out=class; by sex age; run; data class; set class; do _n_ = 1 to 500; output; end; run; options nobyline; ods rtf file='C:\temp.doc'; proc print ... snoopy369

Re: SPSS vs SAS 0 144 (3/5/2010 8:38:28 PM) comp.soft-sys.sas File size issues rather depends on what you're doing with it, I would imagine. SPSS unless i'm mistaken loads the file into memory, while SAS only does that with some procs - usually reads rows sequentially ... snoopy369

Re: Percent of total & Rank 2 174 (3/5/2010 7:34:35 PM) comp.soft-sys.sas PROC TABULATE might be the easier way to do this [or, in a data step]. That allows you to use PERCENTN and such. -Joe On Fri, Mar 5, 2010 at 12:36 PM, Sdlentertd wrote: > I have this dataset > Stat... snoopy369

Re: Return the name of the file currently open in the Enhanced 0 32 (3/5/2010 6:10:16 PM) comp.soft-sys.sas Does this do what you need? %sysget(SAS_EXECFILEPATH) -Joe On Fri, Mar 5, 2010 at 12:03 PM, js8765 wrote: > Hi there, > > Is there any function that returns the name of the file currently open > in the Enh... snoopy369

Re: Help needed for data manipulation #2 0 28 (3/5/2010 4:22:27 PM) comp.soft-sys.sas This might work, depending on how things typically match up. proc sql; create table want as select mem_id, ov_date format=date9., min(date_diff) from ( select A.*, B.ov_date, B.ov_date-A.adm_date as date_diff ... snoopy369

snoopy369's replies:

Items(124) /13 Next >> Last >|

long to wide 4 154 (3/3/2010 7:29:10 PM) comp.soft-sys.sas I have data in the following long format (4 obs per subject, with automan and accession as unique identifiers): data long; input Subj_ID $ AUTOMAN $ ACCESSION $ TESTRESULT; datalines; 24C-004 auto C0... wcw2 (31)

check for variable existence, if not there put variable in. 4 322 (3/3/2010 9:32:12 PM) comp.soft-sys.sas Hello, I am writing code where I need to see if a variable exists in the dataset. If it is not there, then I would like to include it with a value of . (missing). I have tried this code but when the varia... cpotter (7)

importing from Excel 3 264 (3/4/2010 2:41:50 AM) comp.soft-sys.sas I use the code below and get error in log. PROC IMPORT OUT=WORK.laptopdata DATAFILE = "C:\laptop_review.xls" DBMS=EXCEL REPLACE; RANGE="Review$"; GETNAMES=YES; MIX... mark.chase91 (19)

sum by every n rows. 7 243 (3/4/2010 8:53:44 AM) comp.soft-sys.sas Hi, Could anyone help me on summing following dataset ? I have n, x variables and would like to calculate for sum by every 2 rows . n x sum_by_every_2_rows 1 -1 2 -50 -51 3 -2 4 -1 -3 5 1 6 -1 0 7 ... db

Help needed for data manipulation 3 134 (3/5/2010 4:09:41 PM) comp.soft-sys.sas Hi SAS-Lers, =A0 Could you please help me with=A0the following data manipultion problem? I w= ould appreciate your help and thanks in advance! =A0 I have two data sets, one contains all the admit date, dis... nancy_li66 (32)

Return the name of the file currently open in the Enhanced Editor 1 114 (3/5/2010 6:03:06 PM) comp.soft-sys.sas Hi there, Is there any function that returns the name of the file currently open in the Enhanced Editor window? For anyone who's interested, what I'm trying to do is have a toolbar button that will modi... js8765 (10)

Nobyline- table is splitting 1 156 (3/5/2010 8:56:41 PM) comp.soft-sys.sas Hi, I am using the code below to produce a word doc: options nobyline; ods rtf file='C:\projects\Tox Reports.doc'; proc print data=max_grade_counts_tran width=min noobs; by set group; run; ods rtf cl... marksmolkin (44)

PROC FORMAT 1 11 (3/9/2010 3:26:42 PM) comp.soft-sys.sas Hello I use the code below : proc tabulate data=period; class A B; var Y; table period*(B all='Subtotal') all='Total for All goods sold'*f=dollar12., all='Profits from bot... mark.chase91 (19)

Command that runs at DOS prompt does not run when using X command 5 170 (3/9/2010 5:02:03 PM) comp.soft-sys.sas Hi there, I was wondering if anyone has ever experienced something similar to this. When I run the following command at the DOS prompt it works fine: clip < c:\temp\init.txt ....but if I run the follo... js8765 (10)

View files with SAS extension in SAS explorer 1 161 (3/9/2010 10:37:21 PM) comp.soft-sys.sas Hi everyone, I'm just new to SAS and this list and have this question. If I create a new library in SAS Explorer and then I save some SAS programs to it (.sas extension), how come I can't see these types... franwdwyer (1)