topic Re: How to add 21 days in SAS Programming

How to add 21 days

Gil_ — Wed, 21 Jun 2017 18:11:57 GMT

Hi team,
I have a table that uses today dste and I need to add 21 days to it here is what data looks and what I need

Id freq dos lot total

That's what I have i would need a col for today's date and based on that date i would need 21 days added as labels
Today date id freq dos lot total 06/22/17 06/23/17 06/24/17 06/25/17.....

How to add 21 days to data set

Gil_ — Wed, 21 Jun 2017 18:11:05 GMT

Re: How to add 21 days

ballardw — Wed, 21 Jun 2017 19:06:33 GMT

In Today date id freq dos lot total 06/22/17 06/23/17 06/24/17 06/25/17....

These cannot be variable names: 06/22/17 06/23/17 06/24/17 06/25/17

SAS variable names are _ or letter followed by _, letter or digit. NO / and cannot start with 0.

What values are you going to assign to those new variables? If you don't have a value why have the 21 additional variables?

This sounds like you may be trying to replicate some process that was originally done in a spreadsheet. If so you might be much better off describing your starting data and where this ends. Generally having data such as you propose with a separte column for each value of something (dates in this case) is MUCH better processed with a single variable to inicate that value group and another to hole the value.

There are many tools that work much better with data structured that way and then as a last step create a report with that group as a column heading.

Re: How to add 21 days

Reeza — Wed, 21 Jun 2017 19:11:09 GMT

It's not clear what you're asking here.

Please do not post the same question multiple times. I've merged them into one question now.

Re: How to add 21 days

PeterClemmensen — Mon, 18 Sep 2017 13:27:30 GMT

I'm not entirely sure what you are asking, but if you want to add 21 days to todays date, then simply do

data _null_;
   todayplus21 = today() + 21;
   format todayplus21 date9.;
   put todayplus21;
run;

http://sasnrd.com/date-basics/

Re: How to add 21 days

Shmuel — Wed, 21 Jun 2017 20:54:39 GMT

Before adding 21 days, you should describe your input:

what is the variable name that you want to add to it the 21 days? is it character or numeric type?

if numeric - is it a sas date? if not, what format is it (ddmmyyyy or yymmdd or date9. etc.)

The answer to your question will change according to your answers to those questions.

Re: How to add 21 days

Gil_ — Wed, 21 Jun 2017 21:57:36 GMT

Hi guys thanks so much for response what I need to do add 21 days as of today I didn't abt labels not being number so day of week would be good for example Today date id freq dos lot total thur Fri sat sun mon tues wed ....whst i want to add once that part been Id is the total amt base on freq for example

Today date id. freq. total. thur Fri. sat. sun
06/21/17. A1 Fri sun. 150. 0. 150. 0. 150

Re: How to add 21 days

Patrick — Wed, 21 Jun 2017 22:18:27 GMT

@Gil_

To get good answers you need to provide sufficient information in your question.

A very good way to provide such information is for you to post a SAS data step creating sample data and then you show us how your desired result should look like.

@PeterClemmensen already posted sample code. Have you looked into it and understood what it does? May be that's already the solution for you.

Re: How to add 21 days

Gil_ — Wed, 21 Jun 2017 22:42:15 GMT

Sorry I didn't post my question 2x i rec error message 1st time so I hit post again that's why you see same question

Re: How to add 21 days

Gil_ — Wed, 21 Jun 2017 22:50:24 GMT

Thanks for code it only give one day I would need 21 days in day week (Mon Tue wed thur Fri sat sun) I will provide dataset

Re: How to add 21 days

Reeza — Wed, 21 Jun 2017 22:59:28 GMT

You need to create an array and then assign values.

array days(21) days1-days21;

do i=1 to 21;
days(i) = i + date;
end;

Re: How to add 21 days

Gil_ — Sun, 25 Jun 2017 00:52:33 GMT

Hi Reeza I try your example it didn't work should it be like a data set ?

Re: How to add 21 days

Gil_ — Sun, 25 Jun 2017 01:11:25 GMT

I realized I provided col not needed for my request.. I apologize Fri was a bad day ... Thank you for assistance here is how data looks and output needing
Dos. total. Mon. Tue. Wed thur. Fri Sat
Tue Fri. 125. 125. 125

WED. 25. 25

THANK YOU AGAIN FOR ASSISTANCE

Re: How to add 21 days

Patrick — Sun, 25 Jun 2017 01:11:43 GMT

@Gil_

Statements like "it didn't work" without detailed explanation what you've done and what didn't work are not helpful.

1. Provide a fully working data step creating sample data

2. Explain what you want to do

3. Provide the desired output to illustrate what you've explained in words how the outcome should look like (as a SAS data step as well or just a table which lists the results you would like to get)

Once we understand what you have and what you need we can help you; else things will just go in circles waisting everbodys time.

Re: How to add 21 days

Gil_ — Sun, 25 Jun 2017 04:49:19 GMT

I will admit i have never used arrays I Google for examples 1st before asking for assistance for some reason it flew over my head I use the array provide above
Data table;
Set table;
array days(21) days1-days21; do i=1 to 21; days(i) = i + date; end;

The error i get is alphabetic prefixes for enumerated variable (days1-days21) are different. Too few variable define for the dimensions specified for the array day.
Undeclared array reference :days.
Syntax error, expecting one of the following : [ (
Syntax error statement will be ingored

Re: How to add 21 days

Gil_ — Sun, 25 Jun 2017 04:56:03 GMT

The data needs to look like this output
Dos._____ total._Mon__Tue__ Wed__ thur.__Fri__ Sat
Tue. Fri.___125.________125.______________125_____

WED_______ 25________________25________________

Re: How to add 21 days

Patrick — Sun, 25 Jun 2017 10:09:42 GMT

@Gil_

Please provide fully working SAS data steps creating sample data!

Post your desired result using insert code so the layout doesn't get messed up.

Re: How to add 21 days

Gil_ — Mon, 26 Jun 2017 21:08:59 GMT

Here is the table
Proc sql;
Create table want as
(Select
A.id,
A.dos,
A.total,
A2.date1,
A2.date2,
A2.date3,
A2.date4,
A2.date5
From table a, tablea2
Where a.id =a2.id
);
Run;
Id__dos___total_date1 ___date2_date3_date4_date5

A1__Wed Sat_125._06/26_17_ 06/27/17 _06/28/17
For space I can add 3
What I want is this

A1__Wed Sat_125._06/26_17_ 06/27/17 _125

Dos has the date of week which I need to add the total where we match based on the day

Re: How to add 21 days

Gil_ — Mon, 26 Jun 2017 21:15:57 GMT

I was able to add the 21 days I just need to Id in the dos col based on date of week