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: 
PrimeDougR
‎11-14-2018
  • 9 Posts
  • 1 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Macro variable value containing superscript 2

by Fluorite | Level 6 in SAS Programming
‎10-09-2018 03:49 PM
‎10-09-2018 03:49 PM
OK.  I was able to get it to work, although I'm not sure I completely understand.  Even though I used COMPRESS for my superscript values, I was still getting a blank space at the beginning.  So I tried SUBSTR, looking for the second character only.  That worked!   options validvarname=any; proc sql; create table work.DougTest (Drug char(50)); insert into work.DougTest values('Aspirin') values('Insulin'); run; proc sql; create table work.WithSuperscripts as (select Drug, strip(Drug)||substr(compress(kcvt('00b9'x,'utf-16be','utf-16be')),2,1) as Super1, strip(Drug)||substr(compress(kcvt('00b2'x,'utf-16be','utf-16be')),2,1) as Super2 from work.DougTest); proc sql print; select * from work.WithSuperscripts; ... View more

Re: Macro variable value containing superscript 2

by Fluorite | Level 6 in SAS Programming
‎10-09-2018 03:17 PM
‎10-09-2018 03:17 PM
Below is a small-scale version of what I am attempting to do.  In my results, Super1 and Super2 are not showing the drug name and superscript attached correctly.   Drug Super1 Super2 Aspirin Aspirin ¹ Aspirin ² Insulin Insulin ¹ Insulin ²   options validvarname=any; proc sql; create table work.DougTest (Drug char(50)); insert into work.DougTest values('Aspirin') values('Insulin'); run; proc sql; create table work.WithSuperscripts as (select Drug, Drug||compress(kcvt('00b9'x,'utf-16be','utf-16be')) as Super1, Drug||compress(kcvt('00b2'x,'utf-16be','utf-16be')) as Super2 from work.DougTest); proc sql print; select * from work.WithSuperscripts; ... View more

Re: Macro variable value containing superscript 2

by Fluorite | Level 6 in SAS Programming
‎10-09-2018 02:25 PM
‎10-09-2018 02:25 PM
Running your code, I got this for results:   Obs destination style 1 TAGSETS.SASREPORT13(EGSR) HTMLBlue ... View more

Re: Macro variable value containing superscript 2

by Fluorite | Level 6 in SAS Programming
‎10-09-2018 12:48 PM
‎10-09-2018 12:48 PM
There may be an issue with how our SAS is set up.  But it isn't recognizing the superscript part of '^{super 1}'.  I did set '^' as the escapechar and ran your code, but the values are coming back simply as numbers.   Obs drug sup1 sup2 1 Aspirin1 1 2 2 Ibuprofen2 1 2 ... View more

Macro variable value containing superscript 2

by Fluorite | Level 6 in SAS Programming
‎10-09-2018 11:01 AM
‎10-09-2018 11:01 AM
I have a program that attempts to define two macro variables - one being superscript 1 and one being superscript 2.  The program then uses a CASE statement to determine if that superscript should be appended to a drug name for a later publication.   I am using this to define the global variables:   /* 1 superscript */ call symput('sup1',kcvt('00b9'x,'utf-16be','utf-16be')); /* 2 superscript */ call symput('sup2',kcvt('00b2'x,'utf-16be','utf-16be'));   The CASE statements later do work, as I have another variable with a 'YES' or 'NO ' indicating whether the superscripts should be applied.  And that works correctly for both superscripts.  However, DRUG_NAME || "&sup1" appears to work correctly, giving me the drug name with a superscript 1 at the end.  However, DRUG_NAME || “&sup2” does not.  I only get the drug name - no superscript.  In addition, the program runs much slower and I am experiencing OutOfMemory errors when this is included.  I don't know if this is program memory or log memory.   Am I defining superscript 2 incorrectly? ____________________   First case statement does not work.  Second case statement does work:   select case when E."Brand Name"n is null then PN1.Pub_Name else PN1.Pub_Name || "&sup2" end as Pub_Name, case when E."Brand Name"n is null then 'No ' else 'Yes' end as Strength_Exclusion ... View more

Re: Sending emails from SAS with embedded table from dataset

by Fluorite | Level 6 in ODS and Base Reporting
‎04-20-2018 11:51 AM
‎04-20-2018 11:51 AM
I had the same problem.  If you don't already have it, try adding:   Options validvarname='any';   This enabled my Cron jobs to run successfully. ... View more

Re: CRON scripts and multiple worksheet output

by Fluorite | Level 6 in SAS Enterprise Guide
‎10-13-2017 09:33 AM
‎10-13-2017 09:33 AM
This question has been resolved.  It actually involved SAS columns that were using "field name"n references.   When I added             options validvarname=any;   this resolved the problem.  I still don't know why it worked without that option when running the SAS program, but failed when running it via a CRON script.  But at this point, the fact that it now runs both ways is all that matters.   ... View more

Re: CRON scripts and multiple worksheet output

by Fluorite | Level 6 in SAS Enterprise Guide
‎10-12-2017 12:21 PM
‎10-12-2017 12:21 PM
Here is the essence of my program:   libname sasprod "/sas_shared/data"; PROC SQL; CREATE TABLE work.DataTable1 AS Select   Field1,   Field2,   Field3,   Field4,   Field5 from sasprod.Table1 where Field1 = 'P' and (Field2 = 'ABC' or Field2 = 'DEF')) ); QUIT; data _variables_; D = date() - 1; call symput('D',put(D,MMDDYY10.)); D_yyyymmdd = (year(D) * 10000) + (month(D) * 100) + day(D); call symput('D_yyyymmdd',D_yyyymmdd); file_name = "/sastmp/sas_shared/output/TestFile &D_yyyymmdd..xlsx"; call symput('file_name',trim(file_name)); run; proc export data = work.DataTable1    outfile="&file_name"    dbms=xlsx    replace;    sheet="Detail"; run; proc sql; create table work.Table1Summary as (Field2, count(Field3) as Count3, Sum(Field4) as Sum4, sum(Field5) as Sum5 from work.DataTable1 group by Field2); run; proc export data = work.Table1Summary    outfile="&file_name"    dbms=xlsx    replace;    sheet="Summary"; run;   ... View more

CRON scripts and multiple worksheet output

by Fluorite | Level 6 in SAS Enterprise Guide
‎10-12-2017 09:39 AM
‎10-12-2017 09:39 AM
I have a SAS 9.4 program that outputs an Excel workbook with 2 tabs.  When I run the program it works correctly.  When run by a scheduled CRON script, however, only the first tab is included.   Is there a difference in the way the SAS program runs when it is run manually vs. when it is called and run by a CRON script?   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-14-2018 11:47 AM
Likes given to
View All
Quick links