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: 
mona4u
‎10-06-2022
  • 205 Posts
  • 112 Likes Given
  • 2 Solutions
  • 3 Likes Received

Re: else if statement

by Lapis Lazuli | Level 10 in SAS Programming
‎03-09-2018 04:00 PM
‎03-09-2018 04:00 PM
I need the compute the sitenum if status="Open"  at the same time I need to assign 0 for sitenumb if status ne "Open"   ... View more

else if statement

by Lapis Lazuli | Level 10 in SAS Programming
‎03-09-2018 03:39 PM
‎03-09-2018 03:39 PM
proc sort data=&Queries.2; BY STATUS Site_Number; RUN; data &Queries.3; set &Queries.2; by status site_number; if status="Open" and first.Site_Number then do; sitenum=0; end; sitenum+1; if status="Open" and last.Site_Number; run; I want to assign 0 for sitenum if status ne="Open" I wasn't successful when I did it by else if statement    Please advise me for the best way to do it   ... View more

Re: sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 07:13 PM
‎03-07-2018 07:13 PM
tell me how to do the graph before proc report and how to output the graph along with the table in the proc report.    ... View more

Re: sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 06:58 PM
‎03-07-2018 06:58 PM
I'm bias about proc report for some reasons  and I need to know how possible is create a histogram or chart there  ... View more

Re: sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 06:04 PM
‎03-07-2018 06:04 PM
I need to create a simple histogram like this after getting the total of each variable to insert it after the table that I created it by proc report  . So, I what I need to know is how to create a histogram from the total of those variable and how to insert it in proc report?     ... View more

Re: sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 05:55 PM
‎03-07-2018 05:55 PM
Bc Proc Univariate creates too many things that I don't need to include in my report ... View more

Re: sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 03:01 PM
‎03-07-2018 03:01 PM
I gonna create a report in another step  but I need to sum those variables to create a histogram     ... View more

Re: proc report

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-07-2018 11:35 AM
‎03-07-2018 11:35 AM
I changed both the length and the format to be able to display the result. Thanks so much ... View more

sum function or sum statement

by Lapis Lazuli | Level 10 in SAS Studio
‎03-07-2018 11:08 AM
‎03-07-2018 11:08 AM
I'm trying to get the sum of the Site_Approved2 and Date_Supplied3  by using the sum function or sum statement on SAS studio but nothing worked with me  please advise me on that.    here is my data   Obs Sites_Contracted site_number1 Site_Approved1 Date_Supplied312345678910111213141516171819202122232425262728293031323334353637 34 1000 . . 34 1001 . . 34 1050 1 . 34 1100 . 1 34 1200 1 1 34 1250 1 1 34 1252 . . 34 1300 . . 34 1350 . 1 34 1351 . . 34 1400 . . 34 1401 . . 34 1450 . . 34 1451 1 . 34 1452 . . 34 1453 . . 34 1500 . . 34 1600 1 . 34 1601 1 1 34 1602 . . 34 1700 . 1 34 1750 . . 34 5000 . . 34 5002 . . 34 5003 . . 34 5003 . . 34 5003 . . 34 5003 . . 34 5003 . . 34 5003 . . 34 5003 . . 34 5004 . . 34 5005 . . 34 5006 . . 34 5007 . . 34 5008 . 1 34 5009 . . ... View more

Re: proc report

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-07-2018 09:11 AM
‎03-07-2018 09:11 AM
Hi Cynthina,  every thing is there in my code. I tried t increase the length by length statement and by format statement before proc report and it didn't work  ... View more

Re: output summary report in SAS Studio

by Lapis Lazuli | Level 10 in SAS Studio
‎03-06-2018 01:24 PM
‎03-06-2018 01:24 PM
now it's working but  my  tables are spread out in different worksheets ... View more

Re: output summary report in SAS Studio

by Lapis Lazuli | Level 10 in SAS Studio
‎03-06-2018 12:59 PM
‎03-06-2018 12:59 PM
I tried a code several weeks ago and I don't remember it right now ... View more

output summary report in SAS Studio

by Lapis Lazuli | Level 10 in SAS Studio
‎03-06-2018 12:49 PM
‎03-06-2018 12:49 PM
I want to output my summary report to excel sheet. I tried the same codes I usually use for sas window but it diidn't work  Please let me know how I can do that  ... View more

Re: sql warning

by Lapis Lazuli | Level 10 in SAS Programming
‎03-06-2018 10:42 AM
‎03-06-2018 10:42 AM
that's what I did but it gave me warning  ... View more

proc report

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-06-2018 10:22 AM
‎03-06-2018 10:22 AM
I'm trying proc report code and it's truncated Total Open Issues on the table  I hope I can find a way to display the whole string I tried to increase the length of site_number but it didn't work  Please advise me    this is the code that's I'm running  proc report data=&Queries.2; length SITE_NUMBER $25; column SITE_NUMBER sitenum calcpct ; define SITE_NUMBER/ display"Top 3 Sites with highest # issues"; define sitenum/ "# Open Issues"; define calcpct/ computed 'Percent' format=percent8.2; compute after; SITE_NUMBER='Total Open Issues'; endcomp; COMPUTE before; holdtot=sitenum.sum; endcomp; compute calcpct; calcpct= sitenum.sum/ holdtot ; endcomp; rbreak after / summarize ; run;   and this is my output  Top 3 Sites with highest # issues # Open Issues Percent 1350 7 35.00% 1601 7 35.00% 1450 6 30.00% Total Open Issu 20 100.0% ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-06-2022 12:13 PM
Likes given to
Likes from
View All
Quick links