About JUN_Sands

Ksharp · ‎06-16-2015

Add LOG to see what exactly happened. C:\SAS\sas.exe -sysin "C:\Batch\Email_Test.sas" -log "C:\Batch\Email_Test.log"

ballardw · ‎06-02-2015

One generic cause could be a STARTPAGE following a long table. The table could end near the bottom of a page and the end spaces afterward appear on a new page. A STARTPAGE in could then add a new page creating a blank. Coupled with lots of unspecified layout controls and no data it is fairly hard to be more specific.

JUN_Sands · ‎05-27-2015

Please see revised question. Desired output has been added. Thanks.

gerald_pulver_ucdenver_edu · ‎06-14-2015

Thank you! This was just what I needed. I have been using a MUCH longer complex macro. It's curious that SAS doesn't properly recognize the code for purposes of assigning correct colors to the various lines. Nonetheless, your code works like a charm! Gerry

ballardw · ‎05-19-2015

If you have any doubt add a label statement to the code. By default variable characteristics such as Label or Format will be the one associated with the first listed data set for those items common to more than one set.

Ksharp · ‎05-13-2015

Check how to start SAS with utf-8 at : National Language Support (NLS) Reference Guide You can change it at CONFIG file or Start it with command .But Jaap pointed out , you should check it firstly . "C:\Program Files\SAS\SASFoundation\9.2(32-bit)\sas.exe" -CONFIG "C:\Program Files\SAS\SASFoundation\9.2(32-bit)\nls\zh\SASV9.CFG" -encoding utf-8 and Check its LOG: 1 proc options option=encoding; 2 run; SAS (R) PROPRIETARY SOFTWARE RELEASE 9.2 ENCODING=UTF-8 Specifies default encoding for internal processing of data. NOTE: 鈥淧ROCEDURE OPTIONS鈥濇墍鐢ㄦ椂闂达紙鎬诲鐞嗘椂闂达級: 瀹為檯鏃堕棿 0.01 绉? CPU 鏃堕棿 0.01 绉? Xia Keshan

JUN_Sands · ‎05-06-2015

Hi Ballardw, 'Alter Table' resolved the issue. Thanks so much !

Cynthia_sas · ‎05-01-2015

Hi: I'm not on a connection where I can do a search right now, but I *know* there is a Tech Support note on this. Have you searched at support.sas.com? As I remember it boils down to 2 techniques: 1) using ODS ESCAPECHAR and the PREIMAGE style override to put the logo into your SAS TITLE statement and 2) using PROC TEMPLATE. I am positive that if you search the Tech Support notes and/or the forum, you will find the link. to the note with the code. cynthia

normarc · ‎05-01-2015

WOW! I had forgotten the power and beauty of Call Execute! Only 3 or 4 lines of code... All driven by the contents of the Location table. data _null_; set location; call execute( 'Proc Sql; Create Table Sum_'||translate( trim( Location_Name ), '_', ' ' )|| ' as Select column1, Sum( column2 ) as Scolumn2 From '||SAS_Name||' Group By Column1; Quit;' ); run;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

SAS Batch File

ODS PDF - How to deal with blank page

Re: Transpose data with dynamic variable lists

Transpose data with dynamic variable lists

Re: Drop variables that have only missing or null values

Re: Drop variables that have only missing or null values

Drop variables that have only missing or null values

Re: Merge / Append two differnt columns into one column

Merge / Append two differnt columns into one column

Re: Import excel or text file with chinese language

Drop variables that have only missing or null values

Re: SAS Batch File

Re: ODS PDF - How to deal with blank page

Re: Transpose data with dynamic variable lists

Re: Drop variables that have only missing or null values

Re: Merge / Append two differnt columns into one column

Re: Import excel or text file with chinese language

Re: Creating new column with Macro Variables

Re: Company Logo image putting in Header of each pages

Re: Macro Loop