SAS

Dividing a table in to smaller tables
Hey All, I have a dataset named test the snapshot of which is included below. I have to divide this table in to smaller tables in such a way that the total length of the name field in a table does not exceed 50 characters Obs name id len a 1 damodaranpilla 23 ... 26 Mar 2010 11:57

Reading a directory and selecting only desired filenames
The following code reads a directory and places all the filenames into a SAS dataset. I would like only file names starting with "ABC" for example. Placing the selected names into a SLIST would be a bonus. There are no subdirectories in the directory, so no problem there. SAS 9.1.3 on XP PC. TIA for any suggestions... 26 Mar 2010 10:22

finding the mode
I'm having a problem finding the mode over a subset of data... I have a dataset describing retailers' prices of particular goods per day, sorted by store, UPC, day. I am trying to find a way to record, for each observation where the price is recorded, the modal price over the previous and following 20 days. so... 25 Mar 2010 13:47

path analysis with categorical variables
Hi All - I'm using PROC CALIS is do path analysis where some of my endogenous and exgenous variables are categorical. Given that one of the necessary conditions in a path analysis is that all endogenous variables should be assessed on an interval or ratio-level of measurement, I’m proposing to perform a path ana... 25 Mar 2010 12:37

DI studio add index to dataset
I have created a dataset in DI studio (in metadata) and loaded it with data. I now want to add a unique index. I add the unique index to the dataset and then I have tried to load duplicate rows and it allows the rows to be appended (I"m using a loader step to append to the dataset). When I view the statistics on... 26 Mar 2010 22:54

Log File with Color in Server
Dear SAS users, I'm running SAS on unix server with SAS 9.2 Is there an easy way to get log file with preserved color? does -$rtfcolor work with SAS 9.2? please help thanks, chris ... 25 Mar 2010 07:58

Why won't SAS fix PROC EXPORT
Did you know that in many types of Unix windows PROC EXPORT would hang and the program must be terminated manually. I know that you can you -noterminal option but surely SAS could easily rewrite PROC EXPORT so this is unnecessary. ... 26 Mar 2010 02:30

why....
For years I have been thinking and asking, why SAS, even the latest version, doesn't do something to mark/segment/divide different log pieces for different RUNs and with distinctive marks? It's pretty annoying each time to find where is where when debugging the programs, especially for me because there are always s... 7 Apr 2010 21:24

GLIMMIX warning
Hello. I am a graduate student using GLIMMIX to analyze count data. I am investigating the effects that the point count distance to industrial disturbance has on bird abundance. Several of my models are bringing up a note which I have not encountered before. Has anyone encountered this warning? Any advice? ... 24 Mar 2010 18:08

PROC SQL: Concatenating values of several columns into several macro variables
Hello! I am using a proc sql statement like the one given below, which works fine: proc sql; select sum(z1),sum(z2),sum(z3) into :s1 separated by ' ', :s2 separated by ' ', :s3 separated by ' ' from dataset where event = 1 group by time; quit; What I want is that instead of having t... 25 Mar 2010 16:12