topic Re: Create a dataset with date information in SAS Programming

Create a dataset with date information

Crubal — Thu, 26 Jan 2017 22:36:35 GMT

Hi,

How could I create a dataset with three columns like below:

LOC_ID | Date | Demand

..... | .... | ....

Where demand is always 0 and Date is from 01JAN2017 to 30JUN2017 and LOC_ID is always C1.

Thank you!

PGStats — Thu, 26 Jan 2017 22:51:25 GMT

data want;
length LOC_ID $8 Date Demand 8;
LOC_ID = "C1";
demand = 0;
do Date = '01JAN2017'd to '30JUN2017'd;
	output;
	end;
run;

Kurt_Bremser — Fri, 27 Jan 2017 08:08:03 GMT

The only thing I'd add would be

format date date9.;

for better readability. 😉