BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Thalitacosta
Obsidian | Level 7

From the code::

 

proc freq data=base;

by month;

tables type_client*leaf / out=data1;

run;

 

I created the table below, but I need it to have the following variables: month, leaf, count_type_client (if 0), count_type_client (if 1).

 

That is, I need to separate the variable "type_client" into two columns, if 0 and if 1.

 

OUTDATA created:

monthtype_clientleafcountpercent
1032118819.59
1052520823.31
10775666.99
1135290.49
11510660.98
1175220.48
2032325316.94
2053968328.91
207123549.00
2136320.46
21520441.49
2178710.63
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Your question is not very clear as to whether by "table" you mean the output data set created by proc freq or a report for people to read.

 

If it is a report then you need to show what the rest of the columns look like because just adding separate columns for type_client doesn't make much sense. What would be the count and percent on a row?

If want a header of the client type with the count and % below then that would be Proc Report or tabulate for the report people read but the data set will quite different.

 

See if this helps;

 

Proc tabulate data=base;
   class month leaf type_client;
  table month*leaf,
          type_client*(n reppctn)
  ;
run;

This will have the count and percent under each level of client.

There are a number of different percents that can be calculated, row, column, page (if you specify a page dimension before the row of month and leaf)

 

 

View solution in original post

9 REPLIES 9
Reeza
Super User
Do you need counts and percents?

PROC TABULATE (or REPORT) is a better option in this case.
Tutorial on PROC TABULATE - percentages are slightly harder but you also have more control over it.
https://stats.idre.ucla.edu/sas/faq/how-can-i-create-tables-using-proc-tabulate/
ballardw
Super User

Your question is not very clear as to whether by "table" you mean the output data set created by proc freq or a report for people to read.

 

If it is a report then you need to show what the rest of the columns look like because just adding separate columns for type_client doesn't make much sense. What would be the count and percent on a row?

If want a header of the client type with the count and % below then that would be Proc Report or tabulate for the report people read but the data set will quite different.

 

See if this helps;

 

Proc tabulate data=base;
   class month leaf type_client;
  table month*leaf,
          type_client*(n reppctn)
  ;
run;

This will have the count and percent under each level of client.

There are a number of different percents that can be calculated, row, column, page (if you specify a page dimension before the row of month and leaf)

 

 

Thalitacosta
Obsidian | Level 7
Perfect! The code helped me.

Sorry for the spelling mistakes, I don't know english, I'm Brazilian.
jimbarbour
PROC Star
Sorry for the spelling mistakes, I don't know english, I'm Brazilian.

In that case, "Bom dia".

 

Everything now is "Muito bom" yes?  🙂

 

Jim

ballardw
Super User

@Thalitacosta wrote:
Perfect! The code helped me.

Sorry for the spelling mistakes, I don't know english, I'm Brazilian.

Didn't notice any spelling problem, just a partial description of need.

Well done for non-English speaker. I know I don't want to discuss such technical things in any of the other languages I have some experience with.

Thalitacosta
Obsidian | Level 7

I used only N:

Proc tabulate data=base;
class month leaf type_client;
table month*leaf,
type_client*n
;
run;

But now I need to add the total (all) at the end of each line (sum of the observations of 0 and 1). So it looks like this:
type_client
0 1
month leaf N N ALL
1 3 21188 529 21717
1 5 25208 1066 26274
jimbarbour
PROC Star

You may want to open a new Question for this.  It will get more attention since this question is already marked as Solved.

 

Jim

Reeza
Super User
FYI - if you're not familiar with ODS, you can use it to have the PROC FREQ output displayed transferred directly to Excel/PDF/Word.

ods pdf file='/home/demo/file.pdf' ;
proc freq data=sashelp.class;
table age*sex;
run;
ods pdf close;
jimbarbour
PROC Star

Do you want your results to look like this?

jimbarbour_0-1627577249470.png

 

If so, the below code would work.  If you want a SAS dataset instead of HTML, then uncomment the CREATE TABLE portion of the code.

DATA	Data1;
	INFILE	DATALINES	DSD	DLM='09'X;
	INPUT
		month	type_client	leaf	count	percent;
DATALINES;
1	0	3	21188	19.59
1	0	5	25208	23.31
1	0	7	7566	6.99
1	1	3	529	0.49
1	1	5	1066	0.98
1	1	7	522	0.48
2	0	3	23253	16.94
2	0	5	39683	28.91
2	0	7	12354	9.00
2	1	3	632	0.46
2	1	5	2044	1.49
2	1	7	871	0.63
;
RUN;

PROC	SQL	;
/*	CREATE	TABLE	Data2	AS*/
	SELECT	
		month	
		,type_client
		,leaf	
		,CASE
			WHEN	(type_client = 0)  THEN	count	
			ELSE	.
			END	AS	Client_0_Count
		,CASE
			WHEN	(type_client = 1)  THEN	count	
			ELSE	.
			END	AS	Client_1_Count
		,percent
		FROM	Data1
		;
QUIT;

 

Jim

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 9 replies
  • 444 views
  • 9 likes
  • 4 in conversation