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: 
MikeAAC
‎04-22-2020
  • 14 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Faster way to select top n rows from oracle connection

by Calcite | Level 5 in New SAS User
‎12-19-2018 02:12 PM
‎12-19-2018 02:12 PM
Thanks Reeza. I tried it but I got this error msg: ERROR: ORACLE prepare error: ORA-00923: FROM keyword not found where expected. SQL statement: SELECT TOP 100 * FROM table1 t1 inner join table2 on (t1.ID = t2.ID)... ... View more

Faster way to select top n rows from oracle connection

by Calcite | Level 5 in New SAS User
‎12-19-2018 01:34 PM
‎12-19-2018 01:34 PM
Hi all.   Assume the code below. I am using 'inobs=1000' or 'obs=1000' options on the proc sql statement to select the top 1000 records. Is there a faster way to get the same result? I thought I could use the WHERE or SELECT TOP  statement but I getting errors.  PROC SQL;    CONNECT TO ORACLE as EstCon     (PATH=mypath authdomain=Oracledev);             CREATE TABLE MyTable AS             SELECT *             FROM CONNECTION TO EstCon (                  SELECT                        t1.ID,  t2.name, t3.gender, t4.Age                       FROM Table1 t1                       INNER JOIN table2 t2 ON (t1.ID = t2._ID)                       INNER JOIN table3 t6 ON (t1.ID = t3.ID)                       INNER JOIN table4 ON (t1.PARTY_ID = t4.PARTY_ID));              DISCONNECT FROM EstCon; QUIT; ... View more

Re: Non Parametric Confidence Intervals more than 2 groups

by Calcite | Level 5 in New SAS User
‎10-14-2018 07:43 PM
‎10-14-2018 07:43 PM
Thanks PG ... View more

Re: ODS output Type3 proc Logistic

by Calcite | Level 5 in Statistical Procedures
‎10-14-2018 07:41 PM
‎10-14-2018 07:41 PM
Than you Reeza ... View more

Non Parametric Confidence Intervals more than 2 groups

by Calcite | Level 5 in New SAS User
‎10-12-2018 02:40 PM
‎10-12-2018 02:40 PM
Hi all ,   I have a population of 3 variables  rate1, rate2, group. The variable group has 3 levels (group1, group2, group3) and the distributions of the rates are not  normal. How in SAS, can I determine which group has higher means vs another group? I would like for example to build a non parametric confidence intervals between different groups for each rate: CI (group1 - group2), CI (group1 - group3) and CI(group2 - group3). Thanks for the help.   ... View more

Re: ODS output Type3 proc Logistic

by Calcite | Level 5 in Statistical Procedures
‎08-29-2018 02:57 PM
‎08-29-2018 02:57 PM
Thanks Reza.   For Base SAS Software ... Custom version information: 9.4_M4 Image version information: 9.04.01M4P110916 For SAS/STAT ... Custom version information: 14.2 ... View more

ODS output Type3 proc Logistic

by Calcite | Level 5 in Statistical Procedures
‎08-29-2018 01:57 PM
‎08-29-2018 01:57 PM
Hi All,   I'am running this logistic procedure. Only the ParametersEstimates table is created, not the modelAnova (even when I used type3 name instead) and NOPRINT options is not activated . /*table of type3 test of effetcs*/ let varX = VarA VarB varC ; ods output ParameterEstimates = param_tmp ModelANOVA = model_tmp ; proc logistic data=ds_temp1 ; by replicate ; freq numberhits; class VarClass. ; model varY  (event = '1') = &varX. ; run;   this is  the msg I get WARNING: Output 'ModelANOVA' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used.   thanks ... View more

Re: SAS ACCESS: Universal SAS Methods to Access Just About Any Data, A...

by Calcite | Level 5 in SAS Programming
‎04-11-2018 01:08 PM
‎04-11-2018 01:08 PM
Bad Alternative as I won't to keep most of the vars in the table in ODBC ... View more

Re: SAS ACCESS: Universal SAS Methods to Access Just About Any Data, A...

by Calcite | Level 5 in SAS Programming
‎04-11-2018 12:57 PM
‎04-11-2018 12:57 PM
An alternative (I haven't test yet) would be to pass the ODBC pass-thru not in query but in subquery.  ... View more

Re: SAS ACCESS: Universal SAS Methods to Access Just About Any Data, A...

by Calcite | Level 5 in SAS Programming
‎04-11-2018 12:44 PM
‎04-11-2018 12:44 PM
I want basically to select almost 10 Mio ids. puttng them in a macro list does not seem to be the way but thanks for trying to help. Maybe Chris Hemedinger can find another way 🙂 ... View more

Re: SAS ACCESS: Universal SAS Methods to Access Just About Any Data, A...

by Calcite | Level 5 in SAS Programming
‎04-11-2018 10:53 AM
‎04-11-2018 10:53 AM
Thanks Shemuel but all the relevant ID are in a sas table. Obviously, it is not efficient to pull all the ODBC into a SAS table. I just need a pass thru query that pull from ODBC, the same ID I have in my SAS table.  ... View more

SAS ACCESS: Universal SAS Methods to Access Just About Any Data, Anywh...

by Calcite | Level 5 in SAS Programming
‎04-11-2018 10:39 AM
‎04-11-2018 10:39 AM
How can I can query a view in my odbc by selecting only Accounts ID that are store in a SAS table in Work lib. Running code below, I got an error message but not if in a where clause i specified a value like where Id ='e01'.    proc sql; CONNECT TO odbc as mydb (datasrc="..." authdomain=_auth); CREATE TABLE Id_from_odbc_vw AS select * from connection to mydb       (           select Id, Name, DOB           from input_vw          where  Id in (select  AccountId from sas_tbl_wk_lib)       ); DISCONNECT FROM mydb; QUIT; ... View more

Re: Read Zip file from a website

by Calcite | Level 5 in SAS Programming
‎04-06-2017 02:05 PM
‎04-06-2017 02:05 PM
It works. Ty Art. ... View more

Read Zip file from a website

by Calcite | Level 5 in SAS Programming
‎04-06-2017 01:14 PM
‎04-06-2017 01:14 PM
How can I automatically read this file http://www.nanpa.com/nanp1/allutlzd.zip in SAS?   the code below is not working !   filename allstate url "http://www.nanpa.com/nanp1/allutlzd.zip" ; data urlall; LENGTH State $ 2 'NPA-NXX'n $ 7 OCN $ 4 Company $ 50 RateCenter $ 10 EffectiveDate 8 Use $ 2 AssignDate 8 'Initial/Growth'n $ 1 'Pooled Code File Updated 04/06/2'n $ 1 ; LABEL 'Pooled Code File Updated 04/06/2'n = "Pooled Code File Updated 04/06/2017" ; FORMAT State $CHAR2. 'NPA-NXX'n $CHAR7. OCN $CHAR4. Company $CHAR50. RateCenter $CHAR10. EffectiveDate MMDDYY10. Use $CHAR2. AssignDate MMDDYY10. 'Initial/Growth'n $CHAR1. 'Pooled Code File Updated 04/06/2'n $CHAR1. ; INFORMAT State $CHAR2. 'NPA-NXX'n $CHAR7. OCN $CHAR4. Company $CHAR50. RateCenter $CHAR10. EffectiveDate MMDDYY10. Use $CHAR2. AssignDate MMDDYY10. 'Initial/Growth'n $CHAR1. 'Pooled Code File Updated 04/06/2'n $CHAR1. ; INFILE allstate MISSOVER DLM=' ' DSD FIRSTOBS=2 ; INPUT State : $CHAR2. 'NPA-NXX'n : $CHAR7. OCN : $CHAR4. Company : $CHAR50. RateCenter : $CHAR10. EffectiveDate : ?? MMDDYY10. Use : $CHAR2. AssignDate : ?? MMDDYY10. 'Initial/Growth'n : $CHAR1. 'Pooled Code File Updated 04/06/2'n : $CHAR1. ;     run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-22-2020 09:58 PM
Quick links