topic Re: how to solve below example in base sas and sql in SAS Programming

how to solve below example in base sas and sql

ganeshmule — Sat, 04 Nov 2017 06:54:18 GMT

data have;
input ReAdm1-ReAdm2;
datalines;
1 2012

2 2013

3 2015

;

run;

want output in one column like JAN-2012,FEB-2013,MAR-2015

what i can do for it

thanks in advance

Re: how to solve below example in base sas and sql

PeterClemmensen — Sat, 04 Nov 2017 08:09:49 GMT

like this?

data have;
input ReAdm1 ReAdm2;
datalines;
1 2012
2 2013
3 2015
;
run;

data want;
   set have;
   date = mdy(ReAdm1,1,ReAdm2);
   format date monyy7.;
run;

Re: how to solve below example in base sas and sql

Reeza — Sat, 04 Nov 2017 15:57:24 GMT

MDY function in either data step or SQL.

In the future please post what you've tried ahead of time so we can effectively help you.

Re: how to solve below example in base sas and sql

ganeshmule — Sun, 05 Nov 2017 05:46:00 GMT

Thank you for reply but i know that answer is coming like that

put date monyy7.;

MAY2012

but you have not seen my questions properly i want MAY-2012 instead of MAY2012 but thank you for time

i did it.. for less time i asked that question over here

data have;
input ReAdm1 ReAdm2;
datalines;
1 2012
2 2013
3 2015
;
run;
proc sql;
select *, mdy(readm1, 01, readm2) as date format=date11.,
substr (put(calculated date,date11.),4,length(put(calculated date,date11.))) as date
from have;
quit;

Re: how to solve below example in base sas and sql

Reeza — Sun, 05 Nov 2017 19:44:08 GMT

@ganeshmule wrote:

but you have not seen my questions properly i want MAY-2012 instead of MAY2012 but thank you for time

i did it.. for less time i asked that question over here

I would like to assume you've tried everything before posting here in the first place.

FYI - you don't need the third parameter in the SUBSTR function.

data have;
    input ReAdm1 ReAdm2;
    datalines;
1 2012
2 2013
3 2015
;
run;

data want;
    set have;
    mydate=mdy(readm1, 1, readm2);
    mydate2=catx('-', put(mydate, monname3.), put(mydate, year4.));
    mydate3 = substr(put(mydate, date11.), 4);
run;

proc print data=want;
run;

Re: how to solve below example in base sas and sql

ganeshmule — Mon, 06 Nov 2017 04:31:14 GMT

Thank you ......😆