About Go210

Ksharp · ‎02-05-2020

data have; input sas_date; cards; 21955 21956 21957 21958 21959 21960 21961 21962 21963 21964 21965 21966 21967 21968 21969 21970 21971 21972 21973 21974 21975 ; %let date=21963; data want; set have; retain flag 0 n -1; if sas_date=&date then flag=1; if flag then n+1; Inc_by_5=ifn(mod(n,5)=0,1,0) ; drop n flag; run;

Go210 · ‎01-21-2019

Thanks PGStats! I will read up on those functions.

Go210 · ‎08-05-2018

If my start date or end date is missing.... what error control do I have in the Do loop? is it continue? data inter; set have; do date=start_date to end_date; output; end; run; Edit: I will just put an if statement before the loop. 🙂

Reeza · ‎08-04-2018

You can also use the Holiday Functions to return the US holidays, it seems like Good Friday may not be included though. http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=n0jeu57edwueiwn1gpvw2omkj6sr.htm&locale=en

ChrisNZ · ‎07-18-2018

Regular expressions are off-putting at first, but they are a must if you manipulate strings.

ChrisNZ · ‎05-02-2018

How do you fill this? Jan-03 2 1 2003 . . Feb-03 2 2 2003 Bill 98 Engineer 76 Mar-03 2 3 2003 Apr-03 2 4 2003 . . May-03 2 5 2003 . . Jun-03 2 6 2003 Jul-03 2 7 2003 Bill 98 Engineer 80 Aug-03 2 8 2003 . .

Go210 · ‎05-02-2018

All Solved. Just modified to capture the obs above. data want; do until(not missing(value) or last.index); set have; by index; end; temp=value; do until(not missing(value) or last.index); set have; by index; _value=temp;output; end; drop temp value; run;

novinosrin · ‎04-30-2018

No loop needed for your examples, very simple and straight forward--> data want; mystring="#113#468#9999#2474#.#.#.#.#"; last_num=scan(compress(mystring,'.'),-1,'#'); output; mystring="5743#788#1#9#89999#64#68#.#.#"; last_num=scan(compress(mystring,'.'),-1,'#'); output; run;

Online Status	Offline
Date Last Visited	‎02-10-2020 09:54 PM

Simple Increment with Condition

Re: Month-Year Do Loop

Month-Year Do Loop

Re: Calculating a duration between dates and phasing over months

Re: Flagging Holidays that fall on a weekend

Flagging Holidays that fall on a weekend

Re: Calculating a duration between dates and phasing over months

Re: Calculating a duration between dates and phasing over months

Re: Calculating a duration between dates and phasing over months

Calculating a duration between dates and phasing over months

Re: Month-Year Do Loop

Re: Calculating a duration between dates and phasing over months

Re: Calculating a duration between dates and phasing over months

Re: Extracting Certain Information from a String

Re: Simple Increment with Condition

Re: Month-Year Do Loop

Re: Calculating a duration between dates and phasing over months

Re: Flagging Holidays that fall on a weekend

Re: Extracting Certain Information from a String

Re: Filling in the White Space within my dataset

Re: How to fill the gaps between observations

Re: String manipulation