Accepted Solutions
Hi: If you do a PROC CONTENTS on your data set, how wide (how many characters) is the bgPHAAssignment variable. My guess is that it is defined a character with a length of 2 or a formatted value of 2. Changing the CELLWIDTH will not change the internal storage size of the variable. Here's one way of doing what you want to do using a COMPUTED column:
Cynthia
Hi:
DISPNAME has to be wide enough to display ALL the characters in BABYDATE (8 characters) and the 5 characters in the word Total. I would expect that you are NOT seeing the entire word BABYDATE when you do this report. (Sorry, your PDF wouldn't open for me so that is just a guess.)
Without data to experiment with or seeing all of your report in a screen shot, I'm not sure what you mean by your statement that " Instead it created a new column with total at the bottom. " That is exactly what dispname is supposed to do. Here's a modified version of my program and the output:
In my example see how NAME is the first item on the COLUMN statement. If I want the value of NAME on every row to be assigned to the DISPNAME column, then NAME has to be to the left of DISPNAME on the COLUMN statement. You will see this in both Example 2 and Example 3. Also note in #2 how you don't see NAME on the report because the DEFINE for NAME uses the NOPRINT option. But, in both #2 and #3 example, in the COMPUTE block for DISPNAME, I assign the value of NAME on THAT row to be the value of DISPNAME on that row. In your recent example, you assign the fixed string "BABYDATE" to the DISPNAME column -- that's going to give you a fixed string with a length of 6 on every row, which probably is NOT what you want.
In Example #3, notice how I have removed the NOPRINT option from the DEFINE for NAME and I have put DispName as the column header label for the DISPNAME column. So in #3, you should see the same value for student name in the first 2 columns. What NOPRINT does in #2 is allow me to use the value of NAME, but hide it on the report.
Cynthia
@bn820 wrote:
I tried that, but the date are all JAN1960 and the "Total" is no longer showing.
I used another dataset that doesn't use date. The same thing happened my letters became numbers.
please see attached
Post code as TEXT using the SAS "running man" icon. Post LOG lines as text using the Insert code "< / >" icon. Post pictures directly using the "camera" icon.
If the source variable NUMERIC or CHARACTER? If numeric does it contain date values? Or something else.
Play around and figure it out for yourself. Here is an example that starts with a DATE, a STRING, and a general NUMBER and for each of them computes both a numeric and a character version.
data test;
date=today();
format date date9.;
string = '23AUG2023';
number = 10;
run;
proc report data=test;
column date date2 date3 string string2 string3 number number2 number3 ;
define date / display ;
define number / display ;
define date2 / computed ;
define date3 / computed format=monyy7. ;
define string2 / computed format=mmddyy10.;
define string3 / computed;
define number2 / computed;
define number3 / computed;
compute date2 / character length=10 ;
date2 = put(date,yymmdd10.);
endcomp;
compute date3 ;
date3=date;
endcomp;
compute string2 ;
string2 = input(string,date9.);
endcomp;
compute string3 / character length=7 ;
string3 = substr(string,3);
endcomp;
compute number2 ;
number2 = number**2 ;
endcomp;
compute number3 / character length=5 ;
number3=put(number,z5.);
endcomp;
run;
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
-
3849 views
-
4 likes
-
-
