About podarum

podarum · ‎11-02-2011

I'd like to get an average from some data but not count the 0's HAVE data miss; input a b c; cards; 12 0 36 0 0 20 30 29 0 1 30 4 55 0 0 0 12 0 run; WANT 12 . 36 . . 20 30 29 . 1 30 4 55 . . . 12 . Thanks

podarum · ‎10-28-2011

Very well done, Ksharp

podarum · ‎10-27-2011

Thank you. I'm not even gonna try to figure out how you guys come up with these correct responses so quickly.. It's impressive.

podarum · ‎10-27-2011

You are correct.. my mistake. I just noticed I wanted: if it has ST1=02 and ST2=PC Acct ST1 ST2 USE 205 01 PC Y 205 02 AD Y 206 02 BC Y 207 01 AD Y 208 01 PC Y 208 03 AD Y 208 04 AD Y 209 02 PC N 209 03 BC N

podarum · ‎10-27-2011

Thanks this is extremely helpful.. The only thing different I'd add is that these 2 statements should be used collectively and joined wiht an 'AND' .. right now the results I'm gettin gis individually either a 02 or a PC if st1 eq "02" then _02=1; if st2 eq "PC" then _PC=1;

podarum · ‎10-27-2011

Yes, I have a large list of accounts (many duplicates) that I'd like to mark as N if they have ST1 = 02 and ST2 = PC.. but mark by their corresponding acct... I want to eventually create a rate from the overall population where USE = Y and the PC's and 02 are not to be used in the calculation.

podarum · ‎10-27-2011

I have a set of accts that I'd like to be marked if a criteria is met by other variables.I tried retain but can't quite get it, I wonder if index needs to beused.. This is what I mean Have: Acct ST1 ST2 205 01 PC 205 02 AD 206 02 BC 207 01 AD 208 01 PC 208 03 AD 208 04 AD 209 02 PC 209 03 BC Want: I need all the Acct series to be marked that has a 02 in the ST and PC in ST2. Acct ST1 ST2 USE 205 01 PC N 205 02 AD N 206 02 BC Y 207 01 AD Y 208 01 PC Y 208 03 AD Y 208 04 AD Y 209 02 PC N 209 03 BC N Thanks.

podarum · ‎10-25-2011

Love it how I get anwers and learn a whole lot here. thanks

podarum · ‎10-25-2011

I'm not a big fan of SAS dates, so anyone know of a simple and quick way to fix up mixed dates in a dataset. Have: abc Jan-01 abc Feb-01 abc 01-Mar abc 01-Apr def Jan-01 def Feb-01 def 01-Mar and so on......many many obs Want: abc 2001.01 abc 2001.02 abc 2001.03 abc 2001.04 def 2001.01 you get the idea... Thanks

podarum · ‎10-22-2011

I need help from some proc expand experts I have data that has date and units by quarter.. I want it to expand it by month but when the total for the year (by 12 months) is added up it remains the same as the 4 quarters. have 2000.Q1 33 2000.Q2 22 2000.Q3 50 2000.Q4 10 want 2000.01 11 2000.02 10 2000.03 12 2000.04 2 2000.05 5 2000.06 15 and so on... so in the 'want' the sum for the 2000.01 & 2000.02 & 2000.03 remain 33 as per before. Thanks

podarum · ‎10-21-2011

Brilliant.. Thanks guys.. I really appreciate it..

podarum · ‎10-21-2011

Thanks FriedEgg, to be honest it's a little confusing and it didn't quite work.. maybe it's something 'm doing. But basically looking to get rid of all columns that do't have any positive numbers in them.. thanks

podarum · ‎10-21-2011

I'm having trouble doing this, please help. I have about 20 columns (in no particular sequence, eg. COL1=MGF3654, COL2=NTD8475, etc.) and there are about 30 number of rows..with numeric data in the cells. I want to check which columns total to 1 so I can delete thos clumns, they are of no need). Thanks Have: COL1 COL2 ... COL20 2001.01 5 0 23 2001.02 89 0 4 . 2006.12 12 0 8 if COL total to 1 then I want to delete it. Want: COL1 COL3..... COL20 2001.01 5 45 23 2001.02 89 2 4 . 2006.12 12 6 8

podarum · ‎10-18-2011

Sorry guys, I have something I wasn't aware of (I forgot to express it), and don't know how to fix it: Wells D2E,D3R,D5H,H6J Dons H5N,J9T,F4S Gens L2G 7H9 Leads K9P 5F9 to this: Wells D2E Wells D3R Wells D5H Wells H6J Dons H5N Dons J9T Dons F4S Gens L2G Leads K9P right now I get Wells D2E Wells D3R Wells D5H Wells H6J Dons H5N Dons J9T Dons F4S Gens L2G Gens 7H9 (no need) Leads K9P Leads 5F9 (no need)

podarum · ‎10-18-2011

Great help guys, thanks...

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

replace 0's with missing

Re: mark series if another variable meets criteria

Re: mark series if another variable meets criteria

Re: mark series if another variable meets criteria

Re: mark series if another variable meets criteria

Re: mark series if another variable meets criteria

mark series if another variable meets criteria

fix up mixed dates

fix up mixed dates

help with proc expand

sum up across columns and have a criteria

sum up across columns and have a criteria

sum up across columns and have a criteria

converting comma separated cells into rows

converting comma separated cells into rows