topic Re: How do I create a data set with multiple variables in SAS Programming

How do I create a data set with multiple variables

HauteDoc — Wed, 09 Oct 2024 20:07:47 GMT

Hello.

I am new to SAS. I am learning to write efficient code.

How do I take my dataset and have it output based on at least three different variables (sex, county and age categories) over a period of time. Not sure if I need to add a merge step

ods excel file="NoName2024.xlsx";

proc freq data=births;

title 'Dataset, 2018-2023';

table YOB*age_cat /norow nocol nopercent;

table sex*age_cat/norow nocol nopercent;

table county*age_cat/norow nocol nopercent;

run;

Re: How do I create a data set with multiple variables

ballardw — Wed, 09 Oct 2024 20:38:29 GMT

Are you asking how to create data sets?

Or to have the output displayed differently?

If you want to create a single data set with the output of multiple Tables statements in PROC FREQ you have two choices:

Old school: Use an out= option on each table statement to create an output data set for each (only one data set per table statement). Then combine them. Whether a Merge or Append would be the better option would depend on what you expected.

If ALL of the tables are crosstabs you can use ODS OUTPUT.

An example you should be able to run and examine the output data set mycrosstabdataset.

proc freq data=sashelp.cars;
  ods output crosstabfreqs=mycrosstabdataset;
  tables make*origin;
  tables make*cylinders;
  tables make*type;
run;

The data set has a lot of information because of different variables and table requests used.

Note the above could be created with a table statement like

table make *(origin cylinders type);

If it is to display differently then perhaps a different procedure.

proc tabulate data=sashelp.cars;
   class make origin cylinders type;
   table make,
         (origin cylinders type)*n='Count';
run;

Re: How do I create a data set with multiple variables

Tom — Wed, 09 Oct 2024 22:37:08 GMT

In what way to you want the output to be different than the default PROC FREQ output?

Note: You title talks about creating a DATASET, but your posted code is instead using an existing dataset to make a REPORT. Which of the two different topics to you need help with?