cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sassharp
‎04-05-2016
  • 110 Posts
  • 14 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: index example

by Calcite | Level 5 in SAS Procedures
‎05-18-2012 04:55 PM
‎05-18-2012 04:55 PM
http://www2.sas.com/proceedings/sugi30/008-30.pdf ... View more

Re: why odbc dataset can't show detail

by Calcite | Level 5 in SAS Procedures
‎05-18-2012 02:35 PM
‎05-18-2012 02:35 PM
http://www2.sas.com/proceedings/sugi31/259-31.pdf ... View more

Re: Improve SQL Code

by Calcite | Level 5 in SAS Procedures
‎05-17-2012 05:07 PM
‎05-17-2012 05:07 PM
did you try hash joins? ... View more

Re: PROC PHOTO?

by Calcite | Level 5 in SAS Procedures
‎05-17-2012 03:36 PM
‎05-17-2012 03:36 PM
First thanks for your reply in your busy schedule Cynthia. I did send an email. The result is mail delivery failed notification in my inbox.  The author mentioned in that paper he is willing to share the code. would you please guide me the other ways to contact him? thanks. ... View more

PROC PHOTO?

by Calcite | Level 5 in SAS Procedures
‎05-17-2012 02:50 PM
‎05-17-2012 02:50 PM
  Anybody has the complete code in this below paper? "Proc Photo" : A Generic Method to Capture Time-Stamped States of Operational Tables http://www2.sas.com/proceedings/sugi31/157-31.pdf ... View more

Re: HASH join?

by Calcite | Level 5 in SAS Procedures
‎05-11-2012 02:58 PM
‎05-11-2012 02:58 PM
data match_on_movie_titles(drop=rc); if 0 then set sasuser.flightschedule sasuser.flightattendants; /* load variable properties into hash tables */ if _n_ = 1 then do; declare Hash MatchTitles (dataset: "sasuser.flightattendants"); /* declare the name MatchTitles for hash */ MatchTitles.DefineKey ("EmpID"); /* identify variable to use as key */ MatchTitles.DefineData ( "EmpID","JobCode","LastName","FirstName"); /* identify columns of data */ MatchTitles.DefineDone (); /* complete hash table definition */ end; set sasuser.flightschedule(where=(EmpID='1113')); if MatchTitles.find(key:EmpID)=0 then output; /* lookup TITLE in MOVIES table using MatchTitles hash */ run; ... View more

Re: HASH join?

by Calcite | Level 5 in SAS Procedures
‎05-11-2012 01:08 PM
‎05-11-2012 01:08 PM
@HaiKuo would you change this code for any one EMPID? you can find the data sets in your sasuser library. data match_on_movie_titles(drop=rc); if 0 then set sasuser.flightschedule sasuser.flightattendants; /* load variable properties into hash tables */ if _n_ = 1 then do; declare Hash MatchTitles (dataset:"sasuser.flightattendants"); /* declare the name MatchTitles for hash */ MatchTitles.DefineKey ("EmpID"); /* identify variable to use as key */ MatchTitles.DefineData ( "EmpID","JobCode","LastName","FirstName"); /* identify columns of data */ MatchTitles.DefineDone (); /* complete hash table definition */ end; set sasuser.flightschedule; if MatchTitles.find(key:EMPID) = 0 then output; /* lookup TITLE in MOVIES table using MatchTitles hash */ run; ... View more

HASH join?

by Calcite | Level 5 in SAS Procedures
‎05-11-2012 11:22 AM
‎05-11-2012 11:22 AM
In hash join for testing purposes I do need to use for only one record out of dataset. I mean how the look up process or join would be by using one ID. For eaxmplae in proc sql left join proc sql; create table test as select * from table1 left join table2 where table1.id=4 and table1.id=table2.id; run; ... View more

Re: Proc append?

by Calcite | Level 5 in SAS Procedures
‎04-25-2012 08:31 AM
‎04-25-2012 08:31 AM
https://communities.sas.com/thread/34735 ... View more

Re: performance question?

by Calcite | Level 5 in SAS Procedures
‎04-25-2012 08:30 AM
‎04-25-2012 08:30 AM
https://communities.sas.com/thread/34628 This above link is the scenario. Out of 100k records 10 k ids are common in 700M and 100K. These 10K records from 100 (Table2) should be updated in table1(700M) and we need to append the remaining 90K records from table2 should be appended to table1. The result should contain 700M and 90K. Thanks ... View more

performance question?

by Calcite | Level 5 in SAS Procedures
‎04-24-2012 11:49 PM
‎04-24-2012 11:49 PM
need to improve performance. table1 = 700million obs proc sort data=table1; by id run; table2=100k obs proc sort data=table2; by id; run; data table1; update table1 table2; by id; run; q. how to improve performance? ... View more

Re: Proc append?

by Calcite | Level 5 in SAS Procedures
‎04-24-2012 11:06 PM
‎04-24-2012 11:06 PM
can any body tell performace improvement here? proc sort data=table1; by id; run; proc sort data=table2; by id; run; here table1 is too huge7M table2 is only 100k obs. data table1; update table1 table2; by id; run; Q. the performance is very very poor by using above code. Any ideas to improve performance.? Example data and code is as shown above. ... View more

Proc append?

by Calcite | Level 5 in SAS Procedures
‎04-18-2012 11:41 PM
‎04-18-2012 11:41 PM
I need to append new data to historical data on a daily bases. my question here is? historical data on rdbms side table1 Id dose1 date dose2date updated date 21 3/14/2010 4/4/2012 04/04/2012 23 3/4/2010 04/04/2012 62 3/4/2010 4/3/2012 04/04/2012 67 3/4/2010 4/3/2012 04/04/2012 98 3/4/2010 4/3/2012 04/04/2012 99 3/4/2010 04/04/2012 123 3/4/2010 4/3/2012 04/04/2012 but on 4/10/2012 the table changes as follows on rdbms side table 2 Id dose1 date dose2date updated date 21 3/14/2010 4/4/2012 04/04/2012 23 3/4/2010 4/8/2012 04/10/2012 62 3/4/2010 4/3/2012 04/04/2012 67 3/4/2010 4/3/2012 04/04/2012 98 3/4/2010 4/3/2012 04/04/2012 99 3/4/2010 4/8/2012 04/10/2012 123 3/4/2010 4/3/2012 04/04/2012 126 4/3/2011 4/9/2012 4/10/2012 I need to bring to sas daatamart. query ran on '4/4/2012' libname rdbms 'pw path to rdbms'; proc sql; create table t as select * from table 1 where updateddate='4/4/2012'; quit; result is data set 1 from above query. Id dose1 date dose2date updated date 21 3/14/2010 4/4/2012 04/04/2012 23 3/4/2010 04/04/2012 62 3/4/2010 4/3/2012 04/04/2012 67 3/4/2010 4/3/2012 04/04/2012 98 3/4/2010 4/3/2012 04/04/2012 99 3/4/2010 04/04/2012 123 3/4/2010 4/3/2012 04/04/2012 but query on 04/10/2012 proc sql; create table t as select * from table 2 where updateddate='4/10/2012'; quit; the dataset 2 from above query Id dose1 date dose2date updated date 23 3/4/2010 4/8/2012 04/10/2012 99 3/4/2010 4/8/2012 04/10/2012 126 4/3/2011 4/9/2012 4/10/2012 I need to append data set 1 and 2 on'4/10/2012' proc append base=dataset1 data=dataset2; quit; I need to append id 126 to dataset1 and need to update id 23 and id 99 in data set with latest dose2date. thanks ... View more

Re: How to Minimize execution time in Proc Sort

by Calcite | Level 5 in SAS Procedures
‎04-03-2012 10:10 AM
‎04-03-2012 10:10 AM
use the TAGSORT option in proc sort other than HASH, http://www.lexjansen.com/phuse/2010/cc/cc03.pdf ... View more

proc transpose date help

by Calcite | Level 5 in SAS Procedures
‎04-02-2012 10:38 AM
‎04-02-2012 10:38 AM
A SAS® Macro for Transposing Large Data sets http://www.nesug.org/Proceedings/nesug11/cc/cc20.pdf ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-05-2016 03:59 PM
Likes from
View All
Quick links