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: 
DLROW
‎07-13-2021
  • 58 Posts
  • 13 Likes Given
  • 1 Solutions
  • 1 Likes Received

Re: Count Web hits

by Quartz | Level 8 in SAS Programming
‎07-13-2021 03:19 PM
‎07-13-2021 03:19 PM
I'll look into it. Thanks. ... View more

Re: Count Web hits

by Quartz | Level 8 in SAS Programming
‎07-13-2021 03:12 PM
‎07-13-2021 03:12 PM
I thought so. Thank you. ... View more

Re: Count Web hits

by Quartz | Level 8 in SAS Programming
‎07-13-2021 09:13 AM
‎07-13-2021 09:13 AM
I was given an URL (website) and asked to get the hit count. I am not sure if this can be done from SAS. I did look into PROC HTTP which cannot do anything on this requirement I guess. I also searched but couldn't find any solution. My thought is, coding should be done on the website itself and I can not do any coding from SAS. Please suggest. ... View more

Count Web hits

by Quartz | Level 8 in SAS Programming
‎07-12-2021 01:41 PM
‎07-12-2021 01:41 PM
Hi - Can you please let me know how to write the program to count number of web hits for each month in SAS EG? ... View more

Re: PROC ODS - Highlighting a cell

by Quartz | Level 8 in ODS and Base Reporting
‎10-01-2020 02:51 PM
‎10-01-2020 02:51 PM
Thanks all. I went through those papers and I got what I need.      ... View more

PROC ODS - Highlighting a cell

by Quartz | Level 8 in ODS and Base Reporting
‎09-30-2020 10:57 PM
‎09-30-2020 10:57 PM
Hi - I need to highlight a variance (cell)  that is >=15% or <=-15%. Below is the sample and code. Please help. Thanks. ODS EXCEL; PROC REPORT Data=DATA1 COLUMNS First Group Second Group Date_MMYYYY, TOTAL_COUNT Date_MMYYYY,VARIANCE; define FIRST GROUP / group 'First group' ORDER = INTERNAL; define SECOND GROUP / group 'Second Group' ORDER = INTERNAL; define DATE_MMYY / across ''; define TOTAL_COUNT / analysis '' format=comma20.; define VARIANCE / analysis '' format=percent8.2; Run; title; ods excel close;     ... View more

Re: PROC REPORT with BY Statement

by Quartz | Level 8 in ODS and Base Reporting
‎04-06-2020 10:51 AM
‎04-06-2020 10:51 AM
Thank you all. I was able to get the 'BY variable' in the title.  ... View more

PROC REPORT with BY Statement

by Quartz | Level 8 in ODS and Base Reporting
‎04-02-2020 10:21 PM
‎04-02-2020 10:21 PM
I'm using a BY statement in PROC REPORT and report is correctly exported to excel with separate work sheet for each group in the BY variable.   I like to display the corresponding group variable value as a Column Label in each work sheet. Can you suggest a solution?   proc report data=ABC BY  GRP_VARIABLE; COLUMN C1 C2  define C1 / center display 'First Column'; define C2 / center display '<Group Variable Value>'; I' m trying get the group variable value and display that as column label or as part of the title on each work sheet. Please advice. Thank you.   ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 03:09 PM
‎09-18-2019 03:09 PM
Thanks for your reply Tom.    Have you created the stored process and run the report from SAS Report tab (through EXCEL SAS ADDIN) ? If so , please try that.  How do you attach the results here. I am not able to.   ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 02:34 PM
‎09-18-2019 02:34 PM
Yes, it is not a variable but we do see the row numbers as 1 2 3 .... before the column 'Name'.   output :       Name Sex Age Height Weight 1    Alfred M 14 69 112.5 2    Alice F 13 56.5 84 3    Barbara F 13 65.3 98 ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 02:01 PM
‎09-18-2019 02:01 PM
  I see the screen shot if I download it though.   If you run the below code you could see the  obs number (1st column) 1 2 3 4 ..I want to get rid of those numbers.   proc sql nonumber; create table test as select * from sashelp.class; run; ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 12:44 PM
‎09-18-2019 12:44 PM
Attached again. Can you see the output? ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 11:55 AM
‎09-18-2019 11:55 AM
Still I get the number if I create the table. When this report is run from  SAS Reports (Excel SAS Addin)  this number is also being populated in an excel.     Code: proc sql nonumber; create table test as select * from sashelp.class; run;   ... View more

Re: Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 11:39 AM
‎09-18-2019 11:39 AM
I get the obs column number as 1 2 3 4 ...for each row. When the report is exported to excel I get the number. Please see the attached. Thanks.   Example :           field name1     fieldname2      fieldname 3 1      value             value               value  2      value             value                value  3      value            value               value  4      value           value                 value  5       value         value                value  ... View more

Proc SQL - OBS Coloumn

by Quartz | Level 8 in Microsoft Integration with SAS
‎09-18-2019 11:26 AM
‎09-18-2019 11:26 AM
Hi - How to hide Obs column in proc sql. Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-13-2021 01:11 PM
Likes given to
Likes from
View All
Quick links