Create a dataset with date information

[Crubal]

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 · Accepted solution]

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]

The only thing I'd add would be

format date date9.;

for better readability. 😉