SAS Professionals

Creating relationships... and keeping SAS users In the Know

Hello

Here's how you can get involved.

Welcome to the new look SASprofessionals.net

After consulting with existing SAS Professional users, we felt the time was right to make some changes to the layout of the network. The changes we have made are designed to make the site easier to use, and we have also taken this opportunity to retire some of the old functionality that was rarely used. We hope you enjoy the changes we have made and continue to join in the discussion on SAS Professionals.

If you have any questions or comments, please do not hesitate to contact Terry Salmon.

Forum

set + modify + key= not working 3 Replies

Hi,I am trying to update a master table (ventas) using data from a lookup table (productos) by a field (cod_producto), but it doesn't work.The error:'No defined variables for ventas'Can anybody help me?. Thanks in advaceThe code here:%let fecha_ini…Continue

Started by Juan Vidal Gil. Last reply by Vasilij Nevlev yesterday.

Question about using indexes in SAS data steps 11 Replies

I am trying to work with SAS index in order to get better performance getting data from SAS datasets.proc sql;create index campo3 on prueba (campo3);quit;I didn't get better performance in a query which where clause has only one field and this is…Continue

Started by Juan Vidal Gil. Last reply by Juan Vidal Gil on Monday.

Are SAS views good for ETL processes

Hi,I have to made some ETL process in SAS, typical process in which some intermediate tables were created:input file -> (read) -> temp1 -> (transform) -> temp2 -> ........ -> tempN -> (load) -> databaseAre sas views suitable…Continue

Started by Juan Vidal Gil on Monday.

Scheduler project in SAS EG 7.1 is not working

Hi ,we had migration SAS EG 5.1 to 7.1 (32 bit) as part of SAS 9.4 upgrade.Project/program/process flow i schedule i create by updating the parameters in Schedule project (Triggers/Action) creates schedules with EGScript.vbs but those jobs were not…Continue

Tags: EG7.1

Started by Arunkumar Jun 23.

advice with an ordinal variable that ranges in a positive/negative spectrum 11 Replies

Hello,I have a question about ordinal variables which I hope to be a simple one.I made an online survey in which I ask whether cloud computing is seen as an opportunity or a threat to BI initiatives, and I gave the following options for the user to…Continue

Tags: enterprise, miner, spectrum, range, variables

Started by Pedro Innecco. Last reply by Norman Williams Jun 17.

Consolidate data based on date fields following on

Hello,I need to consolidate the LineIDs in the data below where the dates follow on from each other:LineID From_date To_date Days Amount 6695 04-Dec-07 31-Dec-07 28 99.12460274 6695 01-Dec-13 31-Dec-13 31 109.7450959 6695 01-Jan-14 31-Jan-14 31…Continue

Started by darren hoggard Jun 16.

Blog Posts

Online fraud: Increased threats in a real-time world

The move online is positive…

Continue

Posted by Katie Cairns on June 30, 2015 at 17:30

Fun Friday: What is your favourite inspirational big data quote?

Are you the kind of person who has posters of inspirational quotes all over your office desk or on your desktop/phone wallpapers? If yes, you may be interested in these quotes collected from keynote speakers at recent SAS conferences to inspire…

Continue

Posted by Katie Cairns on June 26, 2015 at 12:02

Royal Bank of Scotland goes back to 1970s values with big data

The Royal Bank of Scotland (RBS) is investing over £100m in data analytics technology, in a bid to recover its reputation after the banking crash back in 2008. RBS believes that its plans to invest in business process…

Continue

Posted by Katie Cairns on June 25, 2015 at 9:05

Live SAS Broadcast - Tackling Insurance Fraud Intelligently, July 17

From underwriting through to claims, fraudsters are always looking for opportunities to attack the system. Fortunately, the power of data analytics can help insurers outsmart the fraudsters intelligently, through the…

Continue

Posted by Katie Cairns on June 23, 2015 at 14:00

 
 
 

© 2015   Created by Richard Peace.

Badges  |  Report an Issue  |  Terms of Service