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: 
Haris
‎12-02-2025
  • 240 Posts
  • 39 Likes Given
  • 13 Solutions
  • 54 Likes Received

Re: long to wide

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎12-07-2015 12:55 PM
‎12-07-2015 12:55 PM
proc transpose data=GamDist out=Want; by cust_xref_id Yr_Month; var fico rsn_cd1 rsn_cd2; run; proc transpose data=Want out=Final(drop=_name_); by cust_xref_id; var Col1; ID _Name_ Yr_Month; run;   ... View more

Re: Sort order by descending total and variable in alpha order

by Lapis Lazuli | Level 10 in SAS Programming
‎12-07-2015 12:28 PM
‎12-07-2015 12:28 PM
You list the ordering sequence the way you want it in the ORDER BY statement.  DESC option applies to each variable one at a time.  I think I am missing something, though.   proc sql; create table post_deploy_3 as select * from post_deploy_2 group by SALE_REP_NM order by SALE_REP_NM desc, acct_exec_nm desc, THRD_PARTY_ORIG_CD desc, Total_Count desc ; quit; ... View more

Autocomplete for Custom Abbreviations does not work in EG 7.1

by Lapis Lazuli | Level 10 in SAS Programming
‎12-07-2015 12:03 PM
1 Like
‎12-07-2015 12:03 PM
1 Like
Using Enterprise Guide 7.11 I get the native SAS functions, procs, and macros to autocomplete.  Unfortunately, none of my custom Abbreviations pop up.  Did not have this issue in EG 6.1.   Does anyone else experience this issue?     Running SAS 9.4 M3 on Windows 7 Pro 64-bit.   Thanks, Haris ... View more

Re: Subtotal count and percentage using proc sql

by Lapis Lazuli | Level 10 in SAS Procedures
‎08-28-2015 01:00 PM
‎08-28-2015 01:00 PM
Here's an updated and tested SQL code to get what you want: proc sql;   select 'Enrolled' as Stat,   put(sum(Enrolled='Y' AND Group='group1'),8.) as Group1 'Group 1',   put(sum(Enrolled='Y' AND Group='group2'),8.) as Group1 'Group 2'   from Test union   select 'Finished' as Stat,   cats( sum(Finished='Y' AND Group='group1'),' (',sum(Finished='Y' AND Group='group1')/sum(Group='group1')*100,'%)' ),   cats( sum(Finished='Y' AND Group='group2'),' (',sum(Finished='Y' AND Group='group2')/sum(Group='group2')*100,'%)' )   from Test union   select 'Gender=M' as Stat,   cats( sum(Gender='M' AND Group='group1'),' (',sum(Gender='M' AND Group='group1')/sum(Group='group1')*100,'%)' ),   cats( sum(Gender='M' AND Group='group2'),' (',sum(Gender='M' AND Group='group2')/sum(Group='group2')*100,'%)' )   from Test union   select 'Gender=F' as Stat,   cats( sum(Gender='F' AND Group='group1'),' (',sum(Gender='F' AND Group='group1')/sum(Group='group1')*100,'%)' ),   cats( sum(Gender='F' AND Group='group2'),' (',sum(Gender='F' AND Group='group2')/sum(Group='group2')*100,'%)' )   from Test ; quit; ... View more

Re: Subtotal count and percentage using proc sql

by Lapis Lazuli | Level 10 in SAS Procedures
‎08-27-2015 05:33 PM
‎08-27-2015 05:33 PM
Here's something to get you going (not tested): proc sql;   select 'Enrolled' as Stat, sum(Enrolled='Y' AND Group='group 1') as Group1 'Group 1',   sum(Enrolled='Y' AND Group='group 2') as Group1 'Group 2'   from YourData union   select 'Finished' as Stat,   cats( sum(Finished='Y' AND Group='group 1'),'(',sum(Finished='Y' AND Group='group 1')/sum(Group='group 1'),'%)' )   cats( sum(Finished='Y' AND Group='group 2'),'(',sum(Finished='Y' AND Group='group 2')/sum(Group='group 2'),'%)' )   from YourData; quit; You can also try processing with 'GROUP BY Group' clause but then your output will have two rows for Group 1 and Group 2 respectively--not columns.  You could transform the resulting table. ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-27-2015 04:40 PM
‎08-27-2015 04:40 PM
Yup, that works, DavidBruckner.  And you don't need to compute a separate variable but can apply a number format to the original variable like this: define PctWt / display format=8.4 style=[tagattr="format:#,###.00%"]; The only trouble is that the display in SAS is now not right--it shows percentile not percent. ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-27-2015 11:23 AM
‎08-27-2015 11:23 AM
data_null_, the only thing rounding fixes, well sort of, is the PRINT tab where all the numbers are now rounded to full percent8.0 format.  Made no difference in the REPORT tab. Why you say 'of course' about SQL and character output?  It outputs seemingly numeric #######0 and #######0.0 formats for Age Height and Weight so why not a numeric %.  Or are the former character formats?  In any way, the Age Height and Weight columns sort as numbers, which is the bottom line (for me at least).  The percent column does not--it sorts the percent as character strings and does not recognize that these are numbers not text strings.  VERY BAD! ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-27-2015 10:15 AM
‎08-27-2015 10:15 AM
Is anyone from SAS tech support monitoring these threads?  I should probably open a ticket with this issue or at least let them know is some way... ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-21-2015 11:53 AM
‎08-21-2015 11:53 AM
SASKiwi, I get the same but this is not what the program asks.  We should be getting #######.#"%"_);(#######.#"%") not ########"%"_);(########"%").  Now I am stuck with correcting the format manually and I have hundreds of columns. The current program is using ExcelXP tagset but we need to include graphs in the output which ExcelXP does not do.  Hence the need to migrate from ODS Tagsets.ExcelXP to ODS Excel. ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-20-2015 03:12 PM
‎08-20-2015 03:12 PM
SROMAA, I have Excel 2010.  What version of SAS are you using?  I still get percentages rounded to a full number or percent8.0 format, not percent8.1. ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-20-2015 10:56 AM
‎08-20-2015 10:56 AM
Like the idea of not using the format in the dataset and formatting in at the output stage.  Unfortunately, makes no difference in output--Excel still has shows percent8.0 rather than 8.2 that was requested by PROC REPORT. I hope this is a bug that SAS will work out by the time ODS EXCEL graduates from testing stage.    ... View more

Re: Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-15-2015 10:41 AM
‎08-15-2015 10:41 AM
Really?  To move percent-formatted columns from SAS to Excel you recommend that I turn them to text?  I hope that's not the answer!  PROC SQL already does that in the example above... ... View more

Outputting Percent. format in ODS EXCEL

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎08-14-2015 01:08 PM
1 Like
‎08-14-2015 01:08 PM
1 Like
I want to output a percent-formatted variable to Excel.  Very excited about the capabilities of the new ODS EXCEL but it misbehaves on me. I used three methods to print a percetn8.2 formatted variable: PRINT, SQL, REPORT.  All three produce different results. PRINT is the worst--it truncates the number to two decimals, outputs some of the numbers as text with '%' and others as numbers without '%' without truncation but rounded to two decimals. SQL outputs the variable properly, truncates all numbers to two digits but output is in text column rather than number. REPORT is the best -- outputs number with '%', does not truncate the number, but I can't get it to show how any decimals it rounds to a full number. Here's the code and I am running SAS 9,4 M2: data Class; set SASHelp.Class;   PctWt = Height/Weight;   format PctWt percent8.2; run; ods excel file="d:\Temp\Test.xlsx" style=Printer; ods excel options(sheet_name='Print'); proc print data=Class; run; ods excel options(sheet_name='SQL'); proc sql;   select *   from Class; quit; ods excel options(sheet_name='Report'); proc report data=Class; run; ods excel close; ... View more

Re: Can I see contents of SAS programs in Windows Preview Pane?

by Lapis Lazuli | Level 10 in SAS Procedures
‎06-16-2015 04:22 PM
1 Like
‎06-16-2015 04:22 PM
1 Like
Awesome.  Thanks. ... View more

Can I see contents of SAS programs in Windows Preview Pane?

by Lapis Lazuli | Level 10 in SAS Procedures
‎06-16-2015 01:39 PM
‎06-16-2015 01:39 PM
SAS program document *.sas is an unformatted text document much like any other *.txt document.  If I change the file extension from *.sas to *.txt the contents of my SAS programs show up in the Preview Pane of the Windows File Explorer.  Is there a way to get them to show up without changing the file extension?  Would be very useful for quick preview without having to open the programs. Thanks, Haris ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-02-2025 02:18 PM
Group Hubs for Haris
View All
Likes given to
Likes from
Quick links