About mikersas

mikersas · ‎07-31-2020

I'm trying to post in a community but I forgot my id. How do I find it or create a new one?

mikersas · ‎04-15-2020

I have some tables in html. How do I save them as EXCEL spreadsheets with formatting?

mikersas · ‎11-06-2015

Actually, I'm getting double counting in the relevant hash rows. I'm attaching the code, log, hash table input, hash table output and input data.

mikersas · ‎11-06-2015

New to Hash Tables. Trying to tally mutilple fields in a table that are in error. I'm not getting there.. This is the code: Data _null_; format DATA_name $32.; format counter_save 8.; If _N_ = 1 then do; declare Hash FieldCounters(HashExp:8, multidata&colon; 'YES'); rc = FieldCounters.DefineKey ('DATA_name'); rc = FieldCounters.DefineData ('DATA_name','counter'); rc = FieldCounters.DefineDone (); declare hiter hifc("FieldCounters"); call missing(DATA_name); do until (eof1); set work.DEFAULTVALUESHASH end= eof1; rc = FieldCounters.add(); end; end; set targt.OD001(keep=ENTITY_CRE_FLG ERROR_HOLD) end=end1; If ENTITY_CRE_FLG ne 'Y' then do; DATA_name = 'ENTITY_CRE_FLG'; rc = FieldCounters.find(key:'DATA_name'); counter_save = counter + 1; counter = counter_save; rc = FieldCounters.replace(); end; If missing(ERROR_HOLD) = 0 then do; DATA_name = 'ERROR_HOLD'; rc = FieldCounters.find(key:'DATA_name'); counter_save = counter + 1; counter = counter_save; rc = FieldCounters.replace(); end; if end1 then do; put '######### Got here'; rc=FieldCounters.output(dataset: 'work.hashout'); end; run;

mikersas · ‎01-06-2015

It works if changed_event is placed before id_rssd in the columns statement and if you do it all in one compute statement:

mikersas · ‎01-05-2015

No improvement. I also tried the following but it didn't help either: Let me better explain what I'm trying to do: I've got to define a display field to point to a url (this is working). compute rssd_url; call define ('id_rssd','url',rssd_url); endcomp; I then need to change the color of the text based on the value of another field (which is not working): compute id_rssd; If changed_event = '0' then do: call define (_col_, 'style', 'style=[foreground=blue]'); end; If changed_event = '1' then do; call define (_col_, 'style', 'style=[foreground=green]'); end; endcomp;

mikersas · ‎01-02-2015

I thought this code would change the font color of a fieldf based on the value of another field in the columns: compute id_rssd; if changed_event = '0' then do; call define (_col_, 'style', 'style=[foreground=blue]'); end; if changed_event = '1' then do; call define (_col_, 'style', 'style=[foreground=green]'); end; endcomp; But it didn't do anything. The text came out black.

mikersas · ‎12-04-2014

I have an EG project that runs fine but I need to create a stored process which is to be executed by the user from the SAS add-in. What do I have to change in the ODS statement to route the .xls file to the EXCEL session?

mikersas · ‎11-01-2014

Sorry - here's the program that created the .xml file:

mikersas · ‎10-31-2014

I'm trying to create a friendly hyperlink with EXCELXP but when I open the .xml file, EXCEL throws an error and points to a log that doesn't exist. This is the fragment of the SAS program that creates the hyperlink: Which creates this: ODS code attached

mikersas · ‎10-22-2014

The problem was that the field was formatted as NEGPAREN8.2 in the table. As soon as I changed it to 8.2 and recreated the table - it worked. Thanks all!

mikersas · ‎10-22-2014

Same result. Is the number supposed to be stored by excel as text? Maybe I should change the format in the table.

mikersas · ‎10-22-2014

Something missing? ods tagsets.ExcelXP file='D:\Admin\CA_NIC.xml' style=printer; ods tagsets.ExcelXP options(sheet_interval='bygroup' sheet_label='Distrct' absolute_column_width = '6,10,11,11,25,10,25,6,6,6,30,25,11,11,11,11'); Title 'Current Quarter Assets vs. Previous Quarter'; Proc print data=Admin.Canicmerged noobs label split='*'; by lead_ofc_id; var id_rssd; var PctDiff / Style={tagattr='format:0.00;[Red]$0.00$'}; var &qtr2 ; var &qtr1 ; var idrssd ; var supr_event_nr ;

mikersas · ‎04-23-2012

Thanks. Is there a reference for this macro? Sounds as if it may help.

mikersas · ‎04-23-2012

We'll be moving to DIS 4.3. By the notes section The SQL Server tables we're referencing are already registered. The descriptions we get in the label field are just repeats of the column names. But most of the tables have real data dictionaries with useful information. It's this information we want to merge in.

Online Status	Offline
Date Last Visited	‎05-17-2022 07:10 PM

How do I create a forum id ?

Re: How to import HTML files which are saved in Excel files bu using s...

Re: Counter Not Working in Hash Table

Counter Not Working in Hash Table

Re: Proc Report Compute to Change Text Color

Re: Proc Report Compute to Change Text Color

Proc Report Compute to Change Text Color

Create EXCELXP output to run Stored Process that executes in EXCEL

Re: Create Friendly Hyperlink to Web Site With EXCELXP

Create Friendly Hyperlink to Web Site With EXCELXP

Re: Merge External Data Dictionary Information into DI Studio

How do I create a forum id ?

Re: How to import HTML files which are saved in Excel files bu using s...

Re: Counter Not Working in Hash Table

Counter Not Working in Hash Table

Re: Proc Report Compute to Change Text Color

Re: Proc Report Compute to Change Text Color

Proc Report Compute to Change Text Color

Create EXCELXP output to run Stored Process that executes in EXCEL

Re: Create Friendly Hyperlink to Web Site With EXCELXP

Create Friendly Hyperlink to Web Site With EXCELXP

Re: Redlighting negative numbers not working

Re: Redlighting negative numbers not working

Redlighting negative numbers not working

Re: Merge External Data Dictionary Information into DI Studio

Re: Merge External Data Dictionary Information into DI Studio

SAS Analytics Explorers