topic Re: creating a variable in SAS Programming

creating a variable

Amalik — Wed, 20 Jun 2018 07:15:00 GMT

Hi,

I have the following data-set with first three variables, and I want to create another variable month such that it represents the month and year of the date variable. Any suggestions on how to create it?

winid	permno	date	month
1	1	1/1/2000	Jan-00
1	1	1/2/2000	Jan-00
1	1	1/3/2000	Jan-00
1	1	…..	Jan-00
1	1	…..	Jan-00
1	1	…..	Jan-00
1	1	1/31/2000	Jan-00
2	1	2/1/2000	Feb-00
2	1	2/2/2000	Feb-00
2	1	….	Feb-00
2	1	…..	Feb-00
2	1	2/29/2000	Feb-00

Re: creating a variable

RW9 — Wed, 20 Jun 2018 07:36:40 GMT

Not sure how mabny ways there is to type this: Post test data in the form of a datastep!!!

So now lets start the guessing, is date an actual numeric date value? If so then:

data want;
  set have;
  month=put(date,monyy.);
run;

http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n1anshj9oarqccn15eulfy9mnszl.htm

Re: creating a variable

ballardw — Wed, 20 Jun 2018 14:42:51 GMT

For a very large number of analysis or display purposes what you propose doing may not be needed at all. If the "date" is an actual SAS date value and not character then a change of the display format for a procedure may be all that is needed. See this example:

data example;
   informat date mmddyy10. ;
   format date mmddyy10.;
   input date value;
datalines;
01/01/2018  123
01/23/2018  24
01/31/2018  456
02/02/2018  333
02/05/2018  6
;
run;

proc means data=example;
   class date;
   var value;
run;

proc means data=example;
   class date;
   var value;
   format date monyy5.;
run;

No additional variable was needed to get different groups for analysis, just a change of format.

Almost all of the analysis, grahping and reporting procedures like Report and Tabulate will honor the format for creating groups.

Also Proc Format will allow you create specific date, time or datetime appearances if you can't find a SAS supplied format that appears exactly as you want.