About Steelers_In_DC

Steelers_In_DC · ‎12-10-2014

Awesome, Thank you for checking. I like the ifn/ifc function that is new to me. I always appreciate your thoughtful answers. Thanks!

Steelers_In_DC · ‎12-10-2014

Arthur and user24feb, Thank you for your help on this. I was thinking about this last night and using thoughts from both of your solutions came up with another idea. I'm hoping you can poke a hole in this or confirm that this will work too. What are your thoughts on this? data test; Input new_date:MMDDYY8. acct_full_acct_id $; Format new_date MMDDYY8.; Datalines; 10/01/07 A 09/01/07 A 08/01/07 A 06/01/07 A 05/01/07 A 04/01/07 A 10/01/07 B 09/01/07 B 08/01/07 B 06/01/07 B 05/01/07 B 04/01/07 B ; proc sort data=test; by acct_full_acct_id descending new_date ; run; data testII; format ldate mmddyy8.; set test; by acct_full_acct_id; ldate = lag(new_date); if first.acct_full_acct_id then do; ldate = .; end; if intck('month',new_date,ldate) lt 2; run;

Steelers_In_DC · ‎12-09-2014

Arthur, That is nothing I would have ever come up with, but yes, that is exactly what I want. Put together very nicely. Thank You,

Steelers_In_DC · ‎12-09-2014

the time_key doesn't have any missing values, there are many missing values in this table but none for the id or the date. Because of the word method I am looking up what 'method=' options there are, That's just a guess though.

Steelers_In_DC · ‎12-09-2014

I was wrong, the option nonotes does not work with the entire file. Same issue, I added: proc printto log= "location/filename.log"; run; This works but I'd much rather have another solution.

Steelers_In_DC · ‎12-09-2014

In this version the values for id and by are reversed, it works the same but I'm still getting all of the warnings, log to big for sas. If I process too much it errors out with a pop up, no error to the log.

Steelers_In_DC · ‎12-09-2014

I added options nonotes; before and options notes; after the expand and it runs very smoothly but I'm still open to any other suggestions for the task, or corrections for the expand procedure.

Steelers_In_DC · ‎12-09-2014

I just learned about proc expand, I have the code set up to run and get my desired results but the file seems too big and it's not working. I think my syntax is off. I have attached what I have and what I'm looking for, followed by my proc expand syntax, followed by the warnings I'm seeing in the log. I'm first using the proc expand to add missing rows in a time series file, then I'm deleting the missing row and preceding row. If there is a better solution I'm open to that also, but would still like to learn what I'm doing wrong with proc expand. Thank You Very Much, Mark

Steelers_In_DC · ‎12-08-2014

Awesome, thank you for the help!

Steelers_In_DC · ‎12-08-2014

Not sure if this will make sense but here's what I want: data final_exp; set exp; n+1; if time_key = . then do; delete %eval(n+1); end; run;

Steelers_In_DC · ‎12-08-2014

I noticed an error in what I pasted, I would not delete august, only july (null) and june(july - 1)

Steelers_In_DC · ‎12-08-2014

I pasted an example below. I've used proc expand to update the dataset, filling in missing values with dates and nulls. Now I would like to delete the record where time_key = . but also delete the record prior. The missing record makes it impossible to reconcile the previous record. I hope this helps. have date time_key 10/01/07 20071031 09/01/07 20070930 08/01/07 20070831 07/01/07 . 06/01/07 20070630 05/01/07 20070531 04/01/07 20070430 want date time_key 10/01/07 20071031 09/01/07 20070930 06/01/07 20070630 05/01/07 20070531 04/01/07 20070430

Steelers_In_DC · ‎12-08-2014

I am reconciling a large amounts of accounts. I come across many that, over time have missing records. I want to ignore the month before a missing date because I'm unable to reconcile it, not ignore but move it into a separate dataset, any help will be appreciated. I've been trying a few different things starting to move in circles. My mind keeps going to if intnx('month',date,1,'e') exists then output bad; else output good; I understand that doesn't work but that's what I want to get done.

Steelers_In_DC · ‎12-07-2014

That's it and I feel silly now over thinking it. It's just a join, the number of IDs will vary. I think I know what I'll have to do now. Thank you for your help.

Steelers_In_DC · ‎12-07-2014

I have a large dataset A and a small dataset B. I want to get a list of ID's from B to pull all the history from A. I think I've found another step in the process but am still not sure how to use the list: data test; do i=1 by 1 while (scan("&list.",i) ne ''); list=scan("&list.",i); output; end; drop i; run;

Online Status	Offline
Date Last Visited	‎07-12-2025 12:12 PM

sql server using 'with'

Re: hive show table and column

hive show table and column

proc sql using or

find edge node

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Fill in rows with previous value if next value is the same.

Re: reg ex extract

Re: proc sql using or

Re: Adding quotes to a Macro Variable

Re: How to run a program in EG5.1 without connecting to a server

Re: macro variable in set statements based on today()

Finding all single linked chains: the allChains macro

find edge node

infile 'red x' with no error in log

Re: Extracting Month, Year and quarter

Re: Which Date function can be used to extract month(Character) from t...

Re: How to assign a column value based on another column ??

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

Re: proc expand, too many warnings causes SAS to error

proc expand, too many warnings causes SAS to error

Re: Identify missing dates

Re: Identify missing dates

Re: Identify missing dates

Re: Identify missing dates

Identify missing dates

Re: Use a list in a macro variable

Re: Use a list in a macro variable