About podarum

podarum · ‎03-19-2013

Agree.. Reeza, I have 1000 home estimated prices in region=A .. and each of these homes I also have the 95%-U, 95%-L Confidence Interval for each home's estimate. I am trying to get a general 95%-U and 95%-L for those 1000 homes in region=A. So that I can calculate the Type I error of being between my comfort level of Estimate +/- 10% and the Confidence Interval for region=A. So my final result would be a number (perhaps a risk rating of some sort) of being between my Comfort Level (+/-10% from the Estimate) and the +/-95% Confidence Level.. Thanks

podarum · ‎03-19-2013

Hi, does anybody know a way to calculate the average of many confidence intervals in SAS... for example I have 1000 accounts each with an Estimate and a 95%-Upper and 95%-Lower Confidence Interval value... I want to calculate the average Estimate , the average 95%-Upper and average 95%-Lower (as well as the standard deviation) for that 1000 sample. I don't suspect this is something easy, but hoping... Thanks

podarum · ‎02-25-2013

Thanks guys.. These are all helpful and working examples...

podarum · ‎02-25-2013

Hi, Is there a way I can check if the values of a field (eg. Field_A) is unique for duplicated accounts. So for example I have a datset with many accounts, at least 2 records belong to the same account, and Field_A should also be unique, but in the cases where Field_A has 1 value for one record and another value for the other record.. and to top it all off, there may be more than 2 records for each account.. HAVE: Acct Field_A 001 A 001 A 002 A 002 B 003 A 003 A 003 B 003 A I would like to find out which accounts have both a Field_A = A and a B. WANT: Acct Field_A 002 A 002 B 003 A 003 B Thanks

podarum · ‎02-09-2013

Hi, I'm trying to connect an ODBC table to a local table.. so if I have 2000 record in the local table, I would expect to match to the ODBC table and get 2000 records from it. here is the code I have (below) but for some reason I get way more than 2000 records..since the ODBC table has 50,000... what am I doing wrong? thanks rsubmit; PROC SQL; connect to teradata(user=&user. password=&password. Mode=Teradata tdpid=sdf); create table A.Data (compress=yes reuse=yes) as (select a.v_respn_no, a.*, b.* from A.Local_Table a inner join (Select * from connection to teradata (select * from ODBC.Table2 where l_r_id = 'y')) b on a.evnt_id = b.evnt_id and a.evnt_sys_id = b.evnt_sys__id group by 1 ); quit; endrsubmit;

podarum · ‎01-08-2013

Awesome...great stuff... thanks

podarum · ‎01-08-2013

How could I not include rows if it is only a stand alone and has no pairing.. for example HAVE LOC ID PL Other 342 3 A 1d 342 3 A 2f 399 2 F 9d 456 5 B e4 456 6 B d2 645 7 C r5 645 7 D e7 738 5 E 8s WANT: LOC old_ID new_ID old_PL new_PL Other 342 3 3 A A 1d 456 5 6 B B e4 645 7 7 C D r5 Thanks again..

podarum · ‎01-08-2013

Thanks for all the great answers.. I appreciate all the input and help.

podarum · ‎01-07-2013

Hi, I'm trying to create 2 new vars from 2 rows (eg. and old and a new) ... thanks HAVE: LOC ID PL Other 342 3 A 1d 342 3 A 2f 456 5 B e4 456 6 B d2 645 7 C r5 645 7 D e7 WANT: LOC old_ID new_ID old_PL new_PL Other 342 3 3 A A 1d 456 5 6 B B e4 645 7 7 C D r5 Keeping the Other variable is not that important, it can be dropped if it complicates the code... Thanks

podarum · ‎11-01-2012

How would I specify (using my code as an example) that I don't want to include CAPTR_DT from the SDW001.STN_DLY table ?.. because I have tried wiht drop and keep in different areas of the code and nothing worked for me..

podarum · ‎11-01-2012

Hi.. I know there are many SQL experts here (obviously I'm not one). .. I'm trying to link 2 tables, one is a data warehouse on the server and the other is on my local machine.. How can I select only certain columns from the the server table. Here is the code I have: rsubmit; PROC SQL; connect to server(user=&user. password=&password. Mode=TTTTT tdpid=ssss); create table ABC.AAA_BBB (compress=yes reuse=yes) as select distinct a.*, b.* from ABC.AAA_DDD a join (Select * from connection to teradata (select * from SDW001.STN_DLY)) b on b.ast_id = a.ast_id order by a.ast_id ; quit; endrsubmit; SDW001 has 20 columns , 4 that are shared between ABC.AAA_DDD, but I only want all but 3 columns.. I want to drop the ones that are shared between ABC.AAA_DDD and SDW001

podarum · ‎10-24-2012

Hi Reeza, when I export it to Excel the date_a doesn't come across as only Month , but as the whole date similar to date. In SAS it shows correct, how I would like it to.

podarum · ‎10-24-2012

Thank you

podarum · ‎10-24-2012

Hi, I havea data format as such MMDDYYP10. (samples below), I'm trying to get the months out of the dat but in a MONNAME. format. Have Date 05.02.2012 06.14.2012 07.04.2012 I used Date_A = Month (Date); Format Date_A MONANME. but this didn't quite work Want Date_B May June July

podarum · ‎09-17-2012

Hi, I've been given a business task to code, and although in Englisgh it's simple and doable, the code in SAS is a little harder... So I resorted to this site for the help. I'm tryin gto code this in SAS (preferably not SQL, but that's fine too): (Ab_Flag => 3 and ID is populated and not(UN_NO > ' ' and UDD_NO is not populated)) If these conditions satisfy, then create a new flag (New_Flag = 'Yes') Thanks for all your help..

Online Status	Offline
Date Last Visited	‎09-09-2025 07:36 AM

Keep only part of a symput address path stationary

Update and read excel data with drop-down column in Excel

Re: Group data into specific days of the week

Group data into specific days of the week

Finding if scheduled SAS job ran successfully in Virtual Machine

See the number of rows created and if successful pull

Re: importing an xlsm file (Windows 10)

importing an xlsm file (Windows 10)

proc transpose with duplicate values

Re: Select data with only 4 decimals

Re: Make row values into column

Re: Importing cuts-off field length

Re: getting week number from middle of year to next middle of year

Re: calcuate new field from duplicated obs

Re: retain within different values

Make first letter capital only

Exclude columns using proc SQL

Group data into specific days of the week

use date in a select range

sum up across columns and have a criteria

Re: calculating average of many confidence intervals

calculating average of many confidence intervals

Re: check for unique values of same account

check for unique values of same account

connecting an ODBC table to a local table

Re: create 2 new vars a new and old from 2 rows

Re: create 2 new vars a new and old from 2 rows

Re: create 2 new vars a new and old from 2 rows

create 2 new vars a new and old from 2 rows

Re: Exclude columns using proc SQL

Exclude columns using proc SQL

Re: Get month from a date format

Re: Get month from a date format

Get month from a date format

code not missing and not populated into one line