Data type conversion

dmitrym — Thu, 18 Dec 2008 19:03:00 GMT

Hello everyone,

I have been trying to figure this out for the second day now, and decided to find out if anyone here knows a way.

The task I need to accomplish is the following:

I have a variable k='01JAN2008'd;
In order to call several datasets which have the name in the following form: work....._01JAN2008, work....._07JAN2008, and so on, I was trying to convert k, k+7*d, to character in a single line of code. I was trying to do the following:

%macro a;
%do i=1 %to 3;
%let dt=%put(%sysevalf(&k+7*&i), date9.);
%end;
%mend;
%aa;

, but have not been successfull. I would really appreciate if somebody could point out what am I doing wrong.

Thanks,
Dmitry

Re: Data type conversion

sbb — Thu, 18 Dec 2008 19:39:40 GMT

You will need to use the %SYSFUNC and also use PUTN (instead of %PUT) to resolve a "formatted" SAS date string.

Scott Barry
SBBWorks, Inc.

Re: Data type conversion

dmitrym — Thu, 18 Dec 2008 19:45:17 GMT

Thank you very much! Worked like a charm

Dmitry

topic Data type conversion in SAS Programming

Data type conversion

Re: Data type conversion

Re: Data type conversion