topic Re: problem with sas code in SAS Programming

problem with sas code

atulsingh — Sun, 02 Jul 2017 18:26:50 GMT

Here Date is a set of different dates defined in d_mtcars dataset and I am trying to find the number of days between Date and last_date. But, the values in the days column are missing as output. Please help.

data date_mtcars;
set character_mtcars(drop=prefix);
set d_mtcars;

last_date='29july2017';
days= intck ('day',Date,last_date);
run;

proc print data=date_mtcars;
run;

Re: problem with sas code

Reeza — Sun, 02 Jul 2017 18:27:21 GMT

Why do you have 2 SET statements? What are you expecting to happen with those two statements?

Re: problem with sas code

atulsingh — Sun, 02 Jul 2017 18:28:28 GMT

I have combined two datasets using two set statements.

Re: problem with sas code

atulsingh — Sun, 02 Jul 2017 18:46:26 GMT

please help.

Re: problem with sas code

Reeza — Sun, 02 Jul 2017 18:56:20 GMT

Review how to combine data. I suspect that's your first and probably biggest issue.

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p15jvywi5avt3cn1bee8r6c33ux1.htm

Re: problem with sas code

art297 — Sun, 02 Jul 2017 19:33:29 GMT

Assuming that date is actually a SAS date, your problem is likely that you defined:

last_date='29july2017';

when you should have used:

last_date='29july2017'd;

Art, CEO, AnalystFinder.com

Re: problem with sas code

Shmuel — Sun, 02 Jul 2017 19:38:35 GMT

Beyond to @Reeza's comment, relating to combination of datasets,

you have an error defining a date literal. Change line into:

last_date='29july2017'd;

and you can calculate days between dates just by:

days = date - last_date;

no need to use special function.

Re: problem with sas code

atulsingh — Mon, 03 Jul 2017 05:42:06 GMT

data date_mtcars;
set character_mtcars(drop=prefix);
set d_mtcars;
last_date='29july2017'd;
days= intck('day',Date,last_date);
run;
proc print data=date_mtcars;
run;

After defining date as you said, it's showing error again,

ERROR: Invalid date/time/datetime constant '29july2017'd.

ERROR 77-185: Invalid number conversion on '29july2017'd.

Re: problem with sas code

Reeza — Mon, 03 Jul 2017 06:05:51 GMT

Other than the date does the data set appear in the correct format?

You need only a 3 character month, you have the full word.

JUL vs JULY