topic Re: working character and DATE in SAS Programming

working character and DATE

HM3 — Thu, 17 Dec 2009 10:07:20 GMT

data test;
a=2;
b=2;
proc print data=test;
run;
this will give me a=2 b=2.
Now I want to do same for
a=m;
b=a;

and want to get the output a=m b=m.

Can the same done with dates?

how to declare the same?
data test;
a=12/10/2009 --> how to extract the weekday from a?
Pl help.
partha

Re: working character and DATE

sbb — Thu, 17 Dec 2009 12:31:01 GMT

The SAS language has date and datetime functions. Check the DOC - suggested reading link provided below.

Scott Barry
SBBWorks, Inc.

SAS Language Reference: Concepts, About SAS Date, Time, and Datetime Values
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002200738.htm

Re: working character and DATE

DPraba79 — Thu, 17 Dec 2009 16:28:25 GMT

> data test;
> a=2;
> b=2;
> proc print data=test;
> run;
> this will give me a=2 b=2.
> Now I want to do same for
> a=m;
> b=a;
>
> and want to get the output a=m b=m.

You have to use quatition mark inorder to assign value to variable.

a='m';
b=a;

> how to declare the same?
> data test;
> a=12/10/2009 --> how to extract the weekday from a?
> Pl help.
> partha

You can use INPUT function like below.

A=INPUT('12/10/2009',MMDDYY10.);

Re: working character and DATE

SASPhile — Thu, 17 Dec 2009 19:21:01 GMT

Partha,
Are you looking for this:

proc format;
value whatday 1='Sunday'
2='Monday'
3='Tuesday'
4='Wednesday'
5='Thursday'
6='Friday'
7='Saturday';

run;

data test;
a='12/18/2009';
b=input(a,mmddyy10.);
format b mmddyy10.;
c=weekday(b);
format c whatday.;
run;

Re: working character and DATE

sbb — Thu, 17 Dec 2009 21:17:40 GMT

If interested, consider a more standard approach using the SAS-supplied DOWNAME format to get the weekday name from a SAS DATE type variable.

Scott Barry
SBBWorks, Inc.

Re: working character and DATE

HM3 — Fri, 18 Dec 2009 03:32:28 GMT

Thanks.

Re: working character and DATE

Peter_C — Fri, 18 Dec 2009 09:11:03 GMT

HM3
are you talking "constants"?
a=2
assigns a constant to variable A.
"25dec2009"d
is a date constant