topic Re: problem with sas code in SAS Programming

problem with sas code

atulsingh — Sun, 02 Jul 2017 14:12:56 GMT

Hello everyone,

I am facing problem with entering dates manually. Isn't there any loop kind of procedure so that dates get entered automatically.

for eg: I am having a dataset of 21 observations, i want to enter different date infront of each of them. Will i have to enter them manually using cards statement or there is an automated procedure?

Re: problem with sas code

Tom — Sun, 02 Jul 2017 14:19:36 GMT

What dates do you want? What do you mean by "entered"? Where do you want it "entered"? How can a date be in front of an observation?

Please provide a litte more detail. For example you could provide a data step to create a copy of your 21 observations and explain what dates you need added.

Re: problem with sas code

atulsingh — Sun, 02 Jul 2017 14:25:13 GMT

I want dates from 1st july 2017 to 21st july 2017 infront of every observations. How to do it?

Re: problem with sas code

atulsingh — Sun, 02 Jul 2017 14:30:39 GMT

Please anyone reply fast. Refer the above attachment for dataset.

Re: problem with sas code

Reeza — Sun, 02 Jul 2017 14:48:49 GMT

You showed us what you have. What do you need as output - that's unclear.

@atulsingh wrote:

Hello everyone,

I am facing problem with entering dates manually. Isn't there any loop kind of procedure so that dates get entered automatically.

for eg: I am having a dataset of 21 observations, i want to enter different date infront of each of them. Will i have to enter them manually using cards statement or there is an automated procedure?

Re: problem with sas code

Jagadishkatam — Sun, 02 Jul 2017 15:01:39 GMT

Consider that you have the dataset with name have and you need to create a variable date in want. so you could follow as below

the date will create dates from 01jul2017 to 21jul2017 depending on the number of rows

data want;
do until(date ne .);
set have;
date=intnx('day','01jul2017'd,_n_);
end;
format date date9.;
run;

Re: problem with sas code

MikeZdeb — Sun, 02 Jul 2017 17:08:50 GMT

Hi, curious ... why use a loop in this example ...

data want;
do until(date ne .);
set have;
date=intnx('day','01jul2017'd,_n_);
end;
format date date9.;
run;

Why not just ...

data want;
set have;
date=intnx('day','01jul2017'd,_n_);
format date date9.;
run;