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

I am trying to do something that I think should be easy but I can't get it to work.  I am trying to create a table that shows the total of inf, by year (estyr) and county (cname).  Here is my code.  It is totaling the year and totaling the inf.  Please help, attached is my code which combines 4 different files (one per calendar year).

 

Thank you in advance for any help you can provide.

Anne

1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

I'm not sure I use correctly your variables, but try next code:

proc tabulate data=all missing ;
   class cname estyr;     /* row and column categories */
   var inf;                        
   table cname,
          esttyr * (inf='<label>*f=<format>*sum=' ' ;
run;

View solution in original post

8 REPLIES 8
PaigeMiller
Diamond | Level 26

Do not put code (or anything else) into Microsoft Office documents, as many of us will not download it because it is a security threat.

 

Instead, copy the code as text, and then click on the running man icon here and paste it into the window that appears.

 

One way to write your code:

 

proc summary data=have nway;
    class estyr cname;
    var inf;
    output out=_stats_ sum=;
run;
--
Paige Miller
anner
Fluorite | Level 6

Thank you for this.  Is there a way to have the results show something like this?

I want to find out this, total of INF:

 

Year

 

2007

2008

2009

2010

County1

###

###

###

###

County2

 

 

 

 

County3

 

 

 

 

 

 

 

 

 

PaigeMiller
Diamond | Level 26

@anner wrote:

Thank you for this.  Is there a way to have the results show something like this?

I want to find out this, total of INF:

 

Year

 

2007

2008

2009

2010

County1

###

###

###

###

County2

 

 

 

 

County3

 

 

 

 

 

 

 

 

 


proc report data=have;
    columns cname estyr,inf;
    define cname/group 'County';
    define estyr/across 'Year';
    define inf/analysis sum;
run;
--
Paige Miller
anner
Fluorite | Level 6
Here is my current code that does not work like I want it to.

Data c10; Infile 'Q:\POP\Estimates\Postcensal\page2010.raw' LRECL=540 missover; InPUT @21 estyr 4. @29 cname $char12. @46 tname $char21. @67 totpop 6. @73 Inf 6. @79 (p1-p37) (37*6.) @301 totfem 6.; RUN; Data c09; Infile 'Q:\POP\Estimates\Postcensal\page2009.raw' LRECL=540 missover; InPUT @21 estyr 4. @29 cname $char12. @46 tname $char21. @67 totpop 6. @73 Inf 6. @79 (p1-p37) (37*6.) @301 totfem 6.; RUN; Data c08; Infile 'Q:\POP\Estimates\Postcensal\page2008.raw' LRECL=540 missover; InPUT @21 estyr 4. @29 cname $char12. @46 tname $char21. @67 totpop 6. @73 Inf 6. @79 (p1-p37) (37*6.) @301 totfem 6.; RUN; Data c07; Infile 'Q:\POP\Estimates\Postcensal\page2007.raw' LRECL=540 missover; InPUT @21 estyr 4. @29 cname $char12. @46 tname $char21. @67 totpop 6. @73 Inf 6. @79 (p1-p37) (37*6.) @301 totfem 6.; RUN; Data all; set c10 c09 c08 c07; keep estyr cname inf; run; PROC SUMMARY DATA=all; CLASS cname; VAR inf estyr; OUTPUT OUT=uno SUM=; RUN; PROC SORT data=uno; by cname; run; proc print data=uno; id cname; VAR inf; run;
ballardw
Super User

This may get you started:

proc tabulate data= all;
   class estyr   cname;
   var inf;
   table cname='',
         estyr='Year'* inf=''* sum=''
   ;
run;

The =' ' are to suppress default variable or statistic labeles as you did not show that you wanted them.

 

anner
Fluorite | Level 6
Thank you ballardw, this worked well too.
Shmuel
Garnet | Level 18

I'm not sure I use correctly your variables, but try next code:

proc tabulate data=all missing ;
   class cname estyr;     /* row and column categories */
   var inf;                        
   table cname,
          esttyr * (inf='<label>*f=<format>*sum=' ' ;
run;
anner
Fluorite | Level 6

Thank you Shmuel, this worked perfectly and allowed me to format the output.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

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 webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 8 replies
  • 3305 views
  • 2 likes
  • 4 in conversation