Top Solutions

Poweredge sc 1430, SAS 5 IR adapter 0010.49.00 firmware, Mirrored Sata wdc-wd2500YS drives, Dell SAS Raid Manager v 2.08, latest drivers on sas 5 ir, storport.sys 5.2.3790.3959,
SBS 2003 latest updates

Started getting  this error in event log...

I am using a web-based application that creates 2 data export files for pulling data into SAS:

DATA_EXPORT_2008-04-29.CSV
DATA_EXPORT_2008-04-29.SAS

Both of these files are saved together in a folder (the folder can be anywhere).

The...

Fresh CA ArcServe 12.5 installation has a problem.Arcserve device manager doesnt detect Hp StorageWorks Ult. 920 SAS device with p212 controller card.But in the windows device manager and ntbackup there is no problem.Device is working fine.

Do...

Hello,

Recently the  tape library MSL4048 was unable to make regular backups on the LTO4 tapes, returning different errors on the Symantec Backup Exec ("The drive hardware is offline"; "The driver detected a controller error on...

I am looking for a way to loop through 10 macro variables to create 10 separate datasets (first part ) and then within each dataset to loop for &MXCNT(created earlier) number of variables to calculate the differences between consecutive variables...

Hi,

I am getting an notification from one of our server box like this,I just have a feeling it may be losing the connection from the one of the RAId 0 disk drive.
we are using Dell SAS Raid 6/ir Adapter controller.

Controller ID: 0 ...

OK, I was able to transpose all distinct values of a column into separate columns, thanks to KendallTech and Wolfen351, now all I want to do is the complete opposite.

I have a character string with elements separated by a semicolumn (;).  I...

I would like to be able to add a column to a dataset with the sequential 1,2,3... record number. Once added I need to use it in the PROC REPORT section.

How do I do a LEFT JOIN where there is only ever one value joined from the secondary table, even if multiple values exist for the join criteria?  In other words, no additional rows are created for each secondary table instance?

The code I am...

I usually program in Oracle, but need to do a quick SAS sql query -- so checking what the syntax would be for this. (I Googled, not much help).    

What would be the syntax for doing the following that works in 'regular' SQL?
"Select * from...

How can I find a max date in a column?  I tried below, but the max funtion wants two arguments.  I can do it in PROC SQL - but how can it be done using a dataset?
Thank you.

DATA LTCClaim.913_MaxEffRcdDate(KEEP=i_sys_clm, d_eff_rcd);
      SET...

Would having double the SATA drives provide realtively the same IOPS as the SAS Drives?  We're looking to cluster a Hyper-v Environment with an Exchange 2010 vm and several database servers VM's.  Below are more specifics on the drives we're...

Hi experts!
I downloaded a file that the extension is .sas7bdat   . it is a dataset. I would like to get the data from that file but I cannot open it with either MSexcell or any other program. I've been on the website of SAS but It could help....

Hi all,

We currently run an EMC CX3-20 with the following spec:

120 x 300GB 15,000RPM FC disks

broken out to:

5 disks = vault pack
30 disks = RAID50
remainder = RAID10

Since the CX3-20 is limited to 120 disks (and we need more...

I have a table with 3 columns as follows:
USERID          Date                                   SurveryScore    
123                01/01/06                             120
123                01/03/06                             200
123     ...

I need to have a comparison between both ETL tools i.e. SAS EDI and Informatica.
May be the features wise comparison and which one should we opt for.

Hello,
I would like to take ACDA exam (Certification for ACL): ACL Certified Data Analyst (www.acl.com) and I'm searching for training material, documentation, books on ACL (for data Analytics).

Thank you in advance

I'm trying to run a SAS program that was provided with software we purchased for work.  I've used SAS ages ago, but really don't know it.  I do know programming in general, just not in SAS.  I am running SAS 9.1 for Windows.  Here is where the...

consider the following table

Cust Nanme  Product A  Product B  Product C   Product D      
Jason                1              0              1                 0
Michael              0              1              0                 1
Mary   ...

Hi,

I'm completely nove SAS user and have just installed SAS Enterprise Guide 3.0, having used (well run someone else's programmes for a while on) SAS 9.1.2 for a couple of years. I have recently updated my license but am not sure if this...

Below are just a few of the errors I'm getting at the bottom of the log when I run my program.  I obviously have a problem with data types but am not sure how to use the CAST function to set a date type.  Help!  The code below is a snippet out of...

I'm getting the following error:  A connection to the server "Local" could not be established.

This is running fine on machines all around me and I've uninstalled and reinstalled and still get the error.  It 'feels' like it something to do...

I am trying to determine the difference in months between 2 dates.  One date is a constant, the others are variable.

I have a table with the various dates, and I need to determine the difference between that date and 01/01/2007.

The data is...

I'm new in my job.  A "Storage Administrator" here connected an IBM System x3850 M2 (SAS) storage solution to an OS X Lion Server I'll be administering before my arrival.  The storage space is connected to the server's backplane by 4 separate...

Ok I have. Some IBM DS3400 coming out of production and was wondering about repurposing the parts.

The ds3400 is giving pretty poor read writes using 1tb disks.  I think it is the raid controller in the ds3400.

I have 36 disks and enough...

Alright,so i am trying to setup an IBM x3400 7976-KJG server where i have configured array and while booting the server i am able to see one logical drive attached.But when i am trying to install Windows Server 2003.Sometime after the "Welcome to...

HOW DO I REMOVE ERRORS FROM THIS CODE that i got near monthly_payment

I have 2 tables: table 1 one with a list of IDs and table 2 with a smaller list of IDs, which are all also in table 1. I want to merge/join the 2 tables in such a manner that I keep all the IDS in table 1, but not the IDS that are in both table 1...

For example, the VAL function in MSAccess will do that:
Returns the numbers contained in a string as a numeric value of appropriate type.
Syntax:    Val(string)
The required string argument is any valid string expression.
The following...

I have a few dozen microsoft word documents (2003) with five tables in them. I would like to read the data from the fourth table into a sas dataset. I don't mind having to go into excel first (I'm good at reading excel files into SAS). The table...

How do I programatically zip a file in SAS?

I am running an Excel spreadsheet that is executing SAS code.  The output is coming out in Excel and all of the dates need the SAS to Excel translation of

DATEA + 21916

I was wondering if any SAS gurus have developed a macro to this so I...

Hello, new user to SAS.  I believe I have the input files correctly defined, but everytime I run my program I receive the error message of: ERROR: DBMS type EXCEL not valid for import.  Let me know if you would like to see a copy of my code.  I...

Is there a way to put the date on the end of a file in an export. I would like to put today's date where is says Todays_Date.

libname myxls1 "C:\Documents and Settings\My Documents\Updated_Members.TodayTodays_Date.xls";
PROC EXPORT...

I'm sure this is very simple but I am just learning SAS.

How do I create a new variable within a data set that is simply an incremented index.
The code below (which does not work) shows what I am trying to do.

%LET seq=1;
data cohort4a;...

Hello,

Would you please assist me in determing why a connection code will work for some and not others (myself included, of course).

Below is a segment of SAS code to connect to an SQL Server database and the log results.

 proc sql;
...

Hi,
Trying to run below update taking forever as it is updating 15 million rows is there a way
we can commit update every 5000 or 1000 rows i guess comitting 15 million will be issue
too.

proc sql ;

title 'VALID_SC';

update...

A proc report is exported out to an Excel file via ods html.  There is a relatively long title to the report.  In the Excel file export, the title falls into the first cell and is word wrapped.  Is there a way to tell SAS to export that title...

what is the performance comparison? which is faster as far as IOPS go?

Hello,

How do I pad a SAS text variable with leading zeros to the length of 10?

ex. var1 contains '123456'

Need it to be '0000123456'

Thanks,
SASnewbie

Seagate HD-ST-ST32000444SS 2TB 3.5" SAS Drives we would like to add to our MD3000i.  The drives are not being recogized as Dell approved  is there any way to resolve this issue.

I have a Dell PE 860 with a SAS 5/iR controller.  The server is running W2K3.
The server has two 500GB Sata drives, Raid 1 (mirrored)

I want to upgrade the drives to 2TB.  My first question is will the SAS controller have a problem with this?...

I have a table containing 2 fields(columns) only.  Column1 is UserID and Column2 is Value.  Here is an example of the table.

UserID        Value
user1          A1-34
user1          B2-99
user1          C5-33
user1          D1-88
user2    ...

I need to do the following in "SAS"  (Also the number of Meds will vary. So there might be 3, 10, 20, etc)
Take the example dataset from
ID Med
1    A  
1    B
1    C
2    D
3    A
3    C


To
ID   Med_1   Med_2   Med_3  
1      A ...

I want to export my datasets to CSV files. When my data sets are empty it is not working  , i want to write the column names alone in the CSV files in case if there are no observations in my datasets.

I tried using %ds2csv ,  the column names...

I have a  an Excel file "Listed" which I read into a SAS program using an import.  When the program runs additional members are added to the file.  

I would like to use generation data sets.  I have used them on the mainframe, but I am not...

I nuisance I find is when reading a file from sql server in a Proc SQL, the date is most times stored in datetime format.

If the field is DATEA, I have to do something like this:
DATEAX = DATEPART(DATEA);

The problem is DATEX is now the...

I installed SAS 9.2 from an administrator account on my machine and would like any other user to be able to open the program. When I try to open the program from the other account, it gives me this warning:

    ERROR: User does not have...

I am reading a table using PROC SQL from a SQL Server database.  The DOB field is coming in datetime format.  

I would like to convert 02FEB1951:00:00:00.000    to     02FEB1951

Hello,
I am new with SAS installation.
I have new server,DELL Poweredge T610:
2x146GB SAS 6Gbit/s 10k 2,5Zoll Festplatte Hot Plug
PERC H200 Integrierter RAID Controller

I tried to install windows 2008 64 on this machine,but shown only one...

How to convert sas a final output sas dataset to a fixed width .txt file. Please help

I have the Learning Edition of SAS Enterprise Guide 4.1 as well as the Little SAS Book.  I want to learn the language and am an absolute beginner.  What's the best book to use with Enterprise Guide 4.1?

I have a date field DATEA which I would like to change the year to the year of today's date on all the dates.  Is there a way to do this.

Example :

I would like 01/20/2009  to be 01/20/2011
                   04/02/1988  to be 04/02/2011

I have 2 HP 585 servers connected to an HP p2000 MSA via sas. I have the MSA sliced into volumes and they are detected on boot up with the 2 ESXi hosts. When I try to present the LUNs to the ESXi hosts via vshpere they are not visible. Does...

i have
Amount acc_number transaction_id
87      101          10001
93      101          100002
98      101          100003

I want results as

Amount acc_number transaction_id

98      101          100003


i am running below sql not...

A report is run and to prevent overlapping and allow for Monday holidays, is there a way to select all records where Date_A is between the Monday and Sunday prior to the date run.

IExample if I run a report on Tuesday, January 24, 2012  I...

Hi,
   I was wondering if there is a reason and fix for SORT Initialization in SAS ||(v 9.2) ? I am using PROC SQL and there are multiple left joins and then a last group By statement.

Hi,

I get an error message in the log that I Excel is not valid for DBMS in the following code in running SAS 9.1:

PROC IMPORT OUT= WORK.SAS_Import_Test
            DATAFILE= "C:\Documents and Settings\gshrivi\My...

I have a Tsql code with inner join on 2 conditions. I need help in rewriting the code especially the 2nd JOIN condition. All the rest is straightforward except the 2nd JOIN condition. I am not sure if SAS supports CAST/CONVERT functions similar...

hi,
I am running SAS query. I want to do Concatenate on one column. I only need first later of the name.
may i know how to do this in steps please.
thanks

Is there a way for SAS 9.1.3 to read through a folder of Excel files (regardless of Excel version whether Excel 5, Excel 2000, Excel 97, Excel 2003 etc.) to extract information only from a specific tab and save it in a SAS dataset?

I have a full copy of SAS 9.2 version TS Level 1MO installed on my workstation running Windows 7. I cannot find the Enterprise Guide anywhere.
I tried reinstalling and it does not show Enterprise Guide anywhere on the "Select products to...

In SAS, how do I sort a dataset by a key field but delete all rows from the resultant sorted dataset other than the row where the key field has the highest (date) value?  In other words just keep the observation for the instance where the key...

I have a question regarding SPSS. In excel you can Merge cells together. E.g. cells A1 and B1 can be merged to create AB1. The reason I did this in Excel is to have: AB1 as Name and then A2 as 1st Name and B2 as Surname. Can this be done in SPSS...

Hi:

 I wanted to know how can I get a date timestamp to be formatted as YYYY-MM_DD-HH.MM.SS.XXXXXX?

Hi,

I have the following code:

 /*************************************/
   /* import the Access file            */
   /*************************************/
proc import table="customers"
     out=sasuser.cust dbms=access;
  ...

I want to convert Hex value to Character. Please Suggest

In Excel, there is a NETWORKDAYS function (that calculates the Net number of Working Days between two dates, excluding weekends and optionally, a user-data-range of holiday dates).  Is there a similar function in SAS?

Thanks.

Hi, I'm a new SAS user.

I need to create a report where I see, for all tables of an oracle database, their count(*).

I've begun to do it manually, here a sample of the program I created:

libname TESTDB oracle user='user' pass='password'...

I have two dateswhich I need to find the number of days between the two in SAS.

I have tried using Datediff in a PROC SQL Statement, but it cannot find the Datediff function.

My objective is to convert dates written as such, ex: 1/12/08, into a SAS date (number of days since Jan 1, 1960).  I am using ANYDTDTE10. to do this, but only some of my dates are being converted into SAS dates.  Others are being read as missing...

Hi,

Can anyone point me in the right direction of a tutorial or process that would allow me to create a decision tree in Enterprise Guide (not Miner)?

Thanks

Mike

The following statement is giving me an error...

PROC SQL;
Update WORK.SR
SET Skill = SKILL.'Transaction Skill'n
Where (SKILL.'employee id'n = SR.login_id) and (SKILL.Date = SR.Date)
;
QUIT;

The error is:

ERROR: Unresolved reference...

I'm wondering if anyone is currently using SAS 9.2 TS2M2 on a Windows 7 machine.  I know currently SAS doesn't officially support Windows 7, but were planning on starting our rollout of Win7 before their "official" support date.  It installs...

Hello,

How would I convert a text field of length 6, in the format of MMDDYY to the date format of MMDDYY10.?

Example:

100110 to 10/01/2010

Thanks,

I need to test 25 test tables against their 25 production tables to make sure data is the same.  I would like to take a count of the rows and columns.  I have the proc sql in the code area below, and that gives me the count of rows for that table...

How does one compute Geometric Mean of a column in a SAS dataset? Also Harmonic mean?
It seems possible to compute GM of a row in SAS, but that would require using PROC TRANSPOSE. I couldn't find how to compute this directly for one or more...

I have a subcontractor that holds a database for us in SAS, we have just received a dump of the information in this database in the form of a lot of sas7bdat files.  I can open and view the files in the SAS viewer, but to do any meaningful...

I have experience hooking into many different databases in dotnet (SQL Server, MySQL, VistaDB, Access, etc) but now I've been given several SAS .xpt files. I've installed what I believe to be the correct data providers and I am able to open up...

We have a a database on SQL Server 2008 and we just hired a SAS programmer to do some statistics on the data.
We would like to linked both Software so SAS can read the data on the SQL Server 2008.
by the way, the server is running Windows...

My code:
proc tabulate data=cc_se_count;
      class ES_ID ASE_STAT;
      var COUNT;
      table ES_ID, ASE_STAT;
run;

Question: ASE_STAT is either 'OPEN' or 'CLOSED'.  the table is okay now, BUT I would like to additional limit the table with code...

Hi,

I need to convert a Julian date in Excel that orginated in SAS, but am getting the wrong result by about 50 years. Example:

SAS Julian date: 12432
Represents: 14-Jan-1994

In excel by default this instead gives date 13-Jan-1934 ...

Hello,

I'm trying to figure out how to add a DB2 environment/database to my SAS Enterprise Guide library. I have done this successfully with Teradata but for some reason cannot figure out how to do it with DB2.

For the Teradata environment...

How do I extract all observations from a SAS dataset which ARE duplicate observations -- based on sequential records containing identical values across a few key fields.  Is there an option after the NODUPKEY?

A client sends us files in SAS file format
and we are trying to find a way to import it into SQL Server in an automated fashion.   We do not have SAS in house, and we don't want to buy it either.  We just want to import the data into sql server.

I have an HP DL380 G5 with a P400 Smart Array controller. There are currently two 146Gb SAS drives in the system as RAID 1+0. They are in slots 1 and 2.

I'm trying to add three more as RAID5. The ROM based setup only recognizes the first two...

Does anyone know how if it's possible to do a Chi Square analysis in SPSS, Excel, or ACCESS. And do I need to have previous data to compare it to or can I just plug in the data I have to run the query?

Hi experts!
I downloaded a file that the extension is .sas7bdat   . it is a dataset. I would like to get the data from that file but I cannot open it with either MSexcell or any other program. I've been on the website of SAS but It could help....

I created the following table and now want to add a new column into that same table that calculates the difference between the current row and the previous row for the column "COL35".

LIBNAME KALTDATA        'K:\Analytics\Market\FactData';...

Hi could anybody here please refer me to a SAS compiler that I can use on Windows with a X86 processor??

Best Regards
Fred

I have a SAS table and need to run a logistic regression. Two variables divide my population into 20 different categories. It happens that two of these categories are way larger than the others, with more than 80% of the observations. I am...

How do I check a field in SAS equal to anything with the word "Parent" or "p_"  in the field?

I have a SAS query fiile with about 50 sequential queries. Some of them use a datetime variable.
When I need to increment that variable, I have to do a find and replace within SAS in order to change it.

I looked at Macro Variables and I feel...

Hi:

   I wanted to pass a parameter to a unix script that will in turn pass this parameter to a sas script. How can I accomplish this (IN SAS)?
unix script: myunixscript date <----parameter today's date passed to unix script
This unix script...

Hi anyone,

Just wondering if anyone has SAS code to add a column of cumulative counts

Example of what I am after.
Cust Count  Cum Count
Peter 1  1
Peter 4 5
Peter 5 10
Peter 6 16
Peter 7 23
Janet 1 1
Janet 3 4
Janet 4 7
Mary 2 2...

Hi all,
I am using SAS Connect to connect to multiple sessions at the same time and run pieces of code to reduce the execution time.

Sample code:
************************************************************************Start
signon a1 sascmd...

I have data set link below:
 

Now I will categorize the age to several groups and assign value to group_age variable:

age = 0 and 1 => group_age = 1;
age = 2 and 3 => group_age = 2;
age = 4 and 5 => group_age = 3;... and so on
If I...

Hi,

I am relatively new to SAS. I am using Enterprise Guide 4.1 and trying to connect to a Teradata DB using ODBC. My Teradata client uses ODBC to connect to the server and I have successfully used the same ODBC to connect using R.

If I...