About sassharp

sassharp · ‎06-15-2012

@shivas Thanks for your reply. would you follow me here. That way I can send you direct message to you only. Just send me a request to follow me. I am already following you. thanks.

shivas · ‎05-21-2012

Hi Mike, I Guess you cannot get created date information using base SAS for odbc library,but you can get this information for sas datasets. If you want to know create date information you can login to sqlserver and properties you will get that. Hope this helps... Thanks, Shiva

sassharp · ‎06-03-2012

@ Arthur Tabachneck I am thankful for all your efforts. Thanks.

sassharp · ‎05-11-2012

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;

Patrick · ‎04-26-2012

Considering that the bottleneck is normally I/O I assume that reading an index file is faster than reading the whole 700M records and even more so writing 100k records and updating the index is faster than writing 700M records. I believe this 20% figure only applies for select (read) and not for update/insert.

Jagadishkatam · ‎04-26-2012

Hi Shiva, Just a minor modification to your code. Hope this is correct. Please check. data dataset1; input dose1 date:mmddyy10. dose2date:mmddyy10. updateddate :mmddyy10.; format date dose2date updateddate date9.; cards; 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/12 ; run; data dataset2; input dose1 date:mmddyy10. dose2date:mmddyy10. updateddate :mmddyy10.; format date dose2date updateddate date9.; cards; 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 ; run; proc sort data=dataset1; by dose1; run; proc sort data=dataset2; by dose1; run; data new; update dataset1 dataset2; by dose1; run; proc print data=new; run;

sassharp · ‎04-03-2012

use the TAGSORT option in proc sort other than HASH, http://www.lexjansen.com/phuse/2010/cc/cc03.pdf

tmm · ‎04-02-2012

I will have to see how to work this out. I need to count in my final output those that have this lenght of stay 0 to get my national level. The end result is a chisquare where the national level right now equals 85391 because I did a the whole code already and that should be the end national level. the national is the denominator and counts the number of distinct memid's. The numerator are the taxid's associated with those memid's and are those that are readmitted after an initial admission. so if the memid was admitted jan12009 and discharged jan32009 and then the 2nd admit is jan152009, this counts as readmission and it does not matter if they had 100 more after that. It is simply a yes they were. but then it counts it at a tax id level. so for these 85391 memid's they link up to 4975 distinct taxid's. when i did my program prior i got 232 readmission counts and was told no way. that is wrong. it has to be more like 1300. so i went back to my code and there is something wrong with how after i transpose the admitdt and dischdt and then work my case statements when it is looking at say if admitdt1 =admitdt2 or admitdt2 is null and all the case stuff i have done. so i thought i had to go back to maybe prior to my transpose and see if the length of stay might be affecting my outcome and start from there. i cannot exclude the 0's in the length of stay cuz they go into that overall national count of 85391.

Haikuo · ‎03-13-2012

Learned and Agreed!

Howles · ‎03-09-2012

Consider the EXCEPT operator in PROC SQL.

Vish33 · ‎03-06-2012

yeah..u will be having access to delete or drop a table from SAS side, but when u r trying to connect to external data base (sqlserver). you might not be having access to truncate a table or delete a table. only DBA's or database developers will be having access to truncate or delete the table. Regards, vishnu

Ksharp · ‎03-05-2012

Just as LinusH said in your example the delete operation is unnecessary if the final table name is the same with old table. data class; set sashelp.class; run; proc sql; delete * from class; insert into class select * from sashelp.class; quit; Ksharp

shez · ‎03-01-2012

Thank you very much. The DBMS=XLS worked. What a relief. S

Fontaines03 · ‎02-24-2012

thank you very much

Ksharp · ‎03-14-2012

By default, Hash Table is NODUPKEY, it keeps the first one of duplicated key.

Online Status	Offline
Date Last Visited	‎04-05-2016 03:59 PM

Re: copy column values to next row?

Re: copy column values to next row?

copy column values to next row?

Re: Inserting Date Column - SAS enterprise Guide

Re: Check files in landing Automation

Check files in landing Automation

Re: &&

email with attachment !!

Re: Simple date reformatting help

Re: duplicates check in a given library.

Re: macro to get first monday??????

Re: macro to get first monday??????

Re: macro to get first monday??????

Re: PROC PHOTO?

Re: PROC PHOTO?

Re: macro to get first monday??????

Re: replicate entire table in RDBMS to SAS datamart.

Re: why odbc dataset can't show detail

Re: PROC PHOTO?

Re: HASH join?

Re: performance question?

Re: Proc append?

Re: How to Minimize execution time in Proc Sort

proc transpose date help

how to incorporate 'NODUPKEY' in hash?

Re: Proc Compare Datasets Which Increase In Size

Error in log

data set export from sas to import into RDBMS.

Cannot import from excel2010

Proc format for negative numbers

Creating Hash tables