Hello SAS users
I have the attached kind of data:
I want to create a new variable, "date" which is a combination of the year and the number corresponding to the month (like this, 200810 to represent Oct 2010)
please assist me.
See my footnotes for how to post data. Excel files are mostly useless for this (unless your problem lies in importing them).
A date variable always has the three components = day, month, year. If you do not have one then you need to default one in. You can use ISO dates, which are character:
iso_date=catx('-',put(year,4.),put(month,z2.));
For a numeric, you can have a default, then format it to display differently:
want=mdy(monthvar,1,yearvar); format want monyy7.;
If your variable is date type ,just add a format. format your-variable yymmn6.;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.