cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Patty
‎10-10-2017
  • 12 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Calculating age from birthdate

by Calcite | Level 5 in SAS Procedures
‎04-08-2015 04:59 PM
‎04-08-2015 04:59 PM
Sorry, I should have been more clear, the birth date above was an example of the format. I have over 20,000 dates. I am getting the error messages with all the birth dates dates including the one mentioned above: NOTE: Invalid argument to function YEAR(19591207) at line 9224 column 16. NOTE: Invalid argument to function MONTH(19591207) at line 9225 column 14. NOTE: Invalid argument to function DAY(19591207) at line 9226 column 14. ... View more

Calculating age from birthdate

by Calcite | Level 5 in SAS Procedures
‎04-07-2015 06:56 PM
‎04-07-2015 06:56 PM
I am having trouble calculating age from from date; Attached is the code for someone who's birthday is 19591207 IF YEAR_TERM EQ '20144' THEN DO;             v;   CCYY = YEAR(BRTHDATE_ERSS);   MM = MONTH(BRTHDATE_ERSS);   DD = DAY(BRTHDATE_ERSS);   BIRTHDATE = (CCYY*10000)+(MM*100)+DD;   IF MM LT 10 THEN AGE = 2014-CCYY;   IF MM EQ 10 THEN DO;    IF DD LE 10 THEN AGE = 2014-CCYY;         IF DD GT 10 THEN AGE = 2013-CCYY;    END;   IF MM GT 10 THEN AGE = 2013-CCYY;     ;   END; Any help would be appreciated, Patty ... View more

Re: How to change options/setting in Base SAS to open generated docume...

by Calcite | Level 5 in SAS Procedures
‎01-06-2015 03:10 PM
‎01-06-2015 03:10 PM
Thank you, that was so simple. I also choose *** View results using: Internet Explorer *** which automatically opens the document in a new window outside of SAS. ... View more

How to change options/setting in Base SAS to open generated documents ...

by Calcite | Level 5 in SAS Procedures
‎01-06-2015 12:52 PM
‎01-06-2015 12:52 PM
Can someone please remind me how to change my settings so that when I run a SAS program that generates a pdf or excel output that that the documents opens automatically? I run into this every time I update SAS to the most current version and can't remember how to reset options/tools to do this. ... View more

Re: Add trailing zeros to character data

by Calcite | Level 5 in SAS Programming
‎01-29-2014 01:00 PM
‎01-29-2014 01:00 PM
It originally was numeric and I converted the data to character data. I was able to add a leading zero by doing this but I also need to add a trailing zero as well. example:  '3' to '030' ... View more

Add trailing zeros to character data

by Calcite | Level 5 in SAS Programming
‎01-29-2014 12:47 PM
‎01-29-2014 12:47 PM
I had such a wonderful response to add leading zeros to data that I am now asking for help in adding training zeros. Any suggestions would be appreciated. ... View more

Re: Help adding leading zeros to .txt output

by Calcite | Level 5 in ODS and Base Reporting
‎01-16-2014 12:47 PM
‎01-16-2014 12:47 PM
Thanks Tom,   This worked. I just had to make 1 adjustment: myvar=put(input(myvar,10.)z10); Thanks everyone, All the suggestions opened up possible answers to other issues. ... View more

Help adding leading zeros to .txt output

by Calcite | Level 5 in ODS and Base Reporting
‎01-10-2014 06:25 PM
‎01-10-2014 06:25 PM
I am writing a program to output a SAS data set to a .txt file. The issues this certain field in SAS is a character field with numbers which normally would not be a problem except that in the out output they want leading zeros added to the field. I have to problem changing the character field to a numeric field either. Which ever way I can add and display the leading zeros. I've tried the tagattr format that I've used when outputting to excel but this is not working. Any ideas would be helpful. ... View more

Proc Tabulate multi-dimensional table percentages

by Calcite | Level 5 in ODS and Base Reporting
‎09-12-2011 02:53 PM
‎09-12-2011 02:53 PM
Thanks so much, that worked! ... View more

Proc Tabulate multi-dimensional table percentages

by Calcite | Level 5 in ODS and Base Reporting
‎09-09-2011 05:29 PM
‎09-09-2011 05:29 PM
Maybe this will make it clearer: Example of desired output:                                                         Fall2007     Fall 2008          Fall 2009         Fall 2010                                                            N    %          N  %                    N   %               N  % PROF    ethnicity                             5     33%                 ethnicity                            5     33%                 ethnicity                            5     34%                           ALL                       15     100%                    male                            5        25%                    female                        10       75%                                    ALL                  15       100% ASSOC PROF ethnicity               2         20%                              ethnicity             5         50%                               ethnicity             3       30%                               ALL                  10   100%                             male                   2       20%                              female               8       80%                                ALL                 10    100% ASSIS PROF ethnicity                              ethnicity                               ethnicity                               ALL                          gmale                              female                                ALL ETC... ... View more

Proc Tabulate multi-dimensional table percentages

by Calcite | Level 5 in ODS and Base Reporting
‎09-07-2011 12:52 PM
‎09-07-2011 12:52 PM
Thanks, gave that a try but I got the same results as before. Will keep trying. ... View more

Proc Tabulate multi-dimensional table percentages

by Calcite | Level 5 in ODS and Base Reporting
‎09-01-2011 02:20 PM
‎09-01-2011 02:20 PM
I need help calculating percentages correctly. I'm not getting what I need from the proc statement below. Trying to get the variable2 and variable3 percentages separately into one table. PROC TABULATE DATA=TEST;      CLASS VARIABLE1 VARIABLE 2 VARIABLE3 VARIABLE4;      TABLE VARIABLE1* (VARIABLE2 ALL VARIABLE3 ALL),VARIABLE4 *(N COLPCTN); RUN; Example of desired output:                                                   VARIABLE4  VARIABLE4  VARIABLE4     VARIABLE4                                                             N  %          N  %                    N   %               N  % VARIABLE1   VARIABLE2                          VARIABLE2                           VARIABLE2                           ALL                          VARIABLE3                           VARIABLE3                           VARIABLE3                               ALL    VARIABLE1 VARIABLE2                               ALL                          VARIABLE3                               ALL ETC... I'm getting % of total column instead of variable2 & variable3 seperately.   Thanks in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-10-2017 04:54 PM
Quick links