Hi, I'm trying to create a table that shows values from one column dependent on values from other columns. Hypothetical dataset: data have;
input MARKET_ID $ date_formatted $ labelet per_dateg_market_label;
datalines;
AQE-MAIN 11APR22 1 5
AQE-MAIN 11APR22 2 2
AQE-MAIN 11APR22 3 434
AQE-MAIN 12APR22 1 2
AQE-MAIN 12APR22 2 2
AQE-MAIN 12APR22 3 425
CPH-MAIN 11APR22 1 9
CPH-MAIN 11APR22 2 6
CPH-MAIN 11APR22 3 774
CPH-MAIN 12APR22 1 12
CPH-MAIN 12APR22 2 10
CPH-MAIN 12APR22 3 784
; What I want to create, is a table, where on the vertical axis there would be the "MARKET_ID" followed by the 3 different "labelet" and on the horizontal axis would be the "date_formatted". The values would then be the the corresponding values from "per_dateg_market_label". My idea was to use proc tabulate and do something like this (although not working): proc tabulate data=work.have order=data format=comma18.2;
class MARKET_ID date_formatted;
var labelet per_dateg_market_label;
table MARKET_ID='Venue' * labelet, date_formatted=' ' * per_dateg_market_label;
run; any help is appreciated (new to sas)
... View more