topic Re: MONNAME3. in SAS Programming

MONNAME3.

Aman4SAS — Fri, 01 Feb 2013 05:28:28 GMT

data test;

input month;

format month monname3.;

datalines;

;

run;

Proc print data=test;

run;

when i run this code, i get result like this...

Obs month

1 Jan

2 Jan

3 Jan

4 Jan

5 Jan

its sud be like

jan

feb

mar

& so on...

plz help....

thanks

Re: MONNAME3.

manojinpec — Fri, 01 Feb 2013 05:39:41 GMT

Hi,

Format is applied on the date value.SAS Consider this numbers as date and output the month for the data. It consider it as dates of Jan1960.

Thanks,

Manoj Bansal

Re: MONNAME3.

Aman4SAS — Fri, 01 Feb 2013 06:16:08 GMT

Hi Manoj,

its working on date part not with year.. if like 1 means 1st date of year n i will work till 365.like if i give 31st then it returns feb, but jan is a 31 days month. 60 give mar.

it cant b use with date.

so how can i use monname3.

Re: MONNAME3.

manojinpec — Fri, 01 Feb 2013 06:37:52 GMT

Please note that 01jan1960 is 0. So 31 would be 01 feb 1960. that is why it is giving feb. 60 would give mar only. as 60 would be march date.

Re: MONNAME3.

Aman4SAS — Fri, 01 Feb 2013 07:39:25 GMT

jan belongs to 31 days...apart it my question is how can i use monname3. format?

there is a dataset name sashelp.prdsales. in that column name month having format monname3. plz check

Re: MONNAME3.

andreas_lds — Fri, 01 Feb 2013 08:28:55 GMT

From the documentation:

The common ground that SAS uses to represent dates is called a SAS date value. No matter which form you use to write a date, SAS can convert and store that date as the number of days between January 1, 1960, and the date that you enter.

(Step-by-Step Programming with Base SAS(R) Software)

The column "month" in sashelp.prdsales contains full date numbers, so if you change the format of "month" to date9. full dates are displayed.

proc print data=sashelp.prdsale;

format month date9.;

run;

Using sas formats is the common way associating numbers with names/text.

Re: MONNAME3.

kuridisanjeev — Fri, 01 Feb 2013 09:29:57 GMT

Hi...

MONNAME. formats a DATE, not a month number.

Monname format writes date values as name of the month,but your data don't have any date column.

If your data comes in the same format as you have mentioned then you can define user defined format and then apply on the month variable.

If you don't want to create User defined Format.Here is the Alternative.But i strongly recommend to use user defind format.

data test(Drop=Month);

format month1 monname3.;

input month;

month1=mdy(month,1,2013);

datalines;

;

run;

Proc print;

run;

Thanks &Regards.

Sanjeev.K

Re: MONNAME3.

yaswanthj — Fri, 01 Feb 2013 10:08:47 GMT

You can use below code..this is very easy to use ..

proc format;

value mon 1 = JAN

2 = FEB

3 = MAR

4 = APR

5 = MAY

;

run;

data test;

input month;

format month mon.;

datalines;

;

run;

Proc print;

run;

Thanks,

Yaswanth

Re: MONNAME3.

CarlosSantos — Tue, 06 Aug 2013 09:57:39 GMT

The result is correct because the format monname3. only works with sas date value and not with the month value.

try this to see the difference:

data _null_;

call symputx('_month',put(date(),monname3.));

put "&_month." ;

call symputx('_month2',month(date()));

put "&_month2." ;

call symputx('_month3',put(month(date()),monname3.));

put "&_month3." ;

run;

Regards,

Carlos S