Yes, not hard to do, but putting calendar information into variable names and making a wide data set is generally considered as making your coding harder (not easier). If you need to create a report with months as (some of) the columns, then using PROC REPORT on a long (not wide) data set is a better method than transposing the data set.
In particular, with month names, these will sort alphabetically, and you will then have APR as the first month of the year, AUG as the second month of the year, and so on. Most people do not want this. (And you have made your coding harder, now you have to get the columns in the proper order). On the other hand, if you have actual numeric SAS date values to represent your months (or month/year combinations), these will sort numerically and PROC REPORT on the long data set will produce a table with month names in the desired order.
Also see:
Long Beats Wide
Example with made up data in a long data set, and numeric SAS dates, everything sorts properly
data have;
input product_type $ month :date9. count;
cards;
M 01JAN2022 932
M 01FEB2022 947
M 01MAR2022 966
M 01APR2022 992
M 01MAY2022 932
M 01JUN2022 912
M 01JUL2022 967
M 01AUG2022 919
O 01FEB2022 823
O 01MAR2022 899
O 01APR2022 992
O 01MAY2022 932
O 01JUN2022 912
O 01JUL2022 967
O 01AUG2022 919
O 01SEP2022 848
;
proc report data=have;
columns ("Product" product_type) month,count;
define product_type/group ' ';
define month/across order=internal format=monname3. ' ';
define count/sum ' ';
run;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Click image to register for webinar
Classroom Training Available!
Select SAS Training centers are offering in-person courses. View upcoming courses for:
-
985 views
-
6 likes
-
-
