About NN

NN · ‎12-07-2011

This is something that i tried and got a proper result ods _all_ close; filename message email to="myid@mymail.com" from = "myid@mymail.com" subject = "test" ct="text/html"; ods html body = message style = minimal rs=none; proc sql; select * from sashelp.class; run; ods html close; ods listing;

NN · ‎12-07-2011

Hi, I ran two proc reports first one with a break after and rbreak after PROC REPORT DATA=SASHELP.CLASS; COLUMN SEX NAME AGE HEIGHT; DEFINE SEX / GROUP; DEFINE NAME / GROUP; DEFINE AGE / SUM; DEFINE HEIGHT / SUM; BREAK AFTER SEX / SUMMARIZE; RBREAK AFTER / SUMMARIZE; COMPUTE AFTER SEX; CALL DEFINE (_ROW_,"STYLE","STYLE=[BACKGROUND = GREEN]"); SEX = 'S'; ENDCOMP; COMPUTE AFTER; CALL DEFINE (_ROW_,"STYLE","STYLE=[BACKGROUND = RED]"); SEX = 'T'; ENDCOMP; RUN; And the second one with a break before and rbreak before. PROC REPORT DATA=SASHELP.CLASS; COLUMN SEX NAME AGE HEIGHT; DEFINE SEX / GROUP; DEFINE NAME / GROUP; DEFINE AGE / SUM; DEFINE HEIGHT / SUM; BREAK BEFORE SEX / SUMMARIZE; RBREAK BEFORE / SUMMARIZE; COMPUTE BEFORE SEX; CALL DEFINE (_ROW_,"STYLE","STYLE=[BACKGROUND = GREEN]"); SEX = 'S'; ENDCOMP; COMPUTE BEFORE; CALL DEFINE (_ROW_,"STYLE","STYLE=[BACKGROUND = RED]"); SEX = 'T'; ENDCOMP; RUN; Can someone please guide as to why the background and formatting change in the second report.. If you could direct to some sas notes that would help too.. Thanks

NN · ‎12-06-2011

Hi, Have a look at the information provided in the link below..It should guide you in the right direction http://support.sas.com/kb/30/889.html

NN · ‎12-03-2011

Hi, If your objective is to provide a date & time range or value Then as a sample you can try using the below code in your code section %macro report(); proc sql; select count(*) from sashelp.timedata where datetime /*if using mulitple values then uncomment the below code*/ /* in (*/ /*%if &date_count = 1 %then %do;*/ /*"&date"dt*/ /*%end;*/ /*%else %do i=1 %to &date_count;*/ /*"&&date&i"dt*/ /*%end;*/ /*);*/ /*if using using a range then uncomment the below code*/ /*between "&date_min"dt and "&date_max"dt ;*/ run; %mend; %report; Donot forget to use timestamp or Timestamp range as your prompt type... Same should then work.. Your Prompt Values would look something like January 12, 1998 06:00:00 AM

NN · ‎12-02-2011

Hi, Your note NOTE: I am working on SAS EG 4.2. and later I want to use this stored process in BI Dashboard 4.3. got me wondering if you were executing your STP on EG or via Information Delivery Portal. Just had a feeling that maybe %_eg_whereparam works only on EG and maynot work when running via portal.. However cannot confirm this as not in front of my application right now.. You should look at the notes provided by Tricia.. Which gives you the option for a date range. . However in your code it looks like you are selecting a list of dates hence you can also look at something in the lines of this proc sql; create table temp as select distinct colA, colB, date, sum(colD), sum(colE) from libref.dataset WHERE DATE in ( %if &date_count = 1 %then %do; "&date"d %end; %else %do i=1 %to &date_count "&&date&i"d %end; ); quit;

NN · ‎12-02-2011

just a small question .. are you running your stored process in EG itself...

NN · ‎12-02-2011

Hi art, Sorry for not confirming earlier . Im working on a Unix platform .. Hence i think DDE might not work here... Tom, What you have suggested is what i am currently using... Thanks for the VValuex ... Got to learn something new today.. As Ballardw says i too prefer not using excel but had no choice here.. thanks again...

NN · ‎12-02-2011

This is great.... Had been looking for something like this..

NN · ‎11-30-2011

Hi Greg, Will this work for .xls files? It think what you are suggesting will work if i was importing a .csv file. But sadly i have to work with a .xls file. Thanks..

NN · ‎11-30-2011

Read About CNTLIN= . Might be what you are looking for.

NN · ‎11-29-2011

Hi, Not sure if i can be of much help here... We used to create our own error messages for our stored processes in sas 9.1.on Unix environment. To hide the log we used the Debug mask by creating a hidden prompt and setting the value _debug = 0 Then i think the stperror macro gave the information if there was an error in the processes and based on the return codes that sas generated we used to customise the output that was shown to the user. Will this be of any help...

NN · ‎11-29-2011

Hi, Sorry for the delayed reply. Let me first put forward my concern. I have multiple users each of who upload an excel file to my sas directory. Post which a batch job runs to process these files Now there are two columns one is an ID and the other a Pincode. Now ideally these two columns are supposed to be character columns with numeric digits. But certain users may upload it as character in their excel where as others may upload it as numeric. So i wanted to check if it was possible to import the data as character irrespective of the type in which the user has uploaded. Though i am not facing any issues even if the columns are imported in numeric. I just wanted to know if what i was asking was possible..... Judging from what i have read and others have suggested changing the physical file seems to be the only optiion available currently... Thanks...

NN · ‎10-12-2011

Hi, There is a Filelocks= option that can be used in the libname statement when defining a libref . I am not sure if that will help your case but you can definetely look into it.

NN · ‎10-12-2011

Hi Bill, What you have suggested does work but what i wanted was that even my numeric columns should be read as character . i.e. I should not have to convert the column to character in the physical excel file. Hi Linus, The Mixed = yes would also not resolve my purpose in this condition. Appreciate you help...

NN · ‎09-30-2011

Hi, Just a quick question are you executing the stored process in Sas Enterprise Guide or Sas Information Delivery Portal.

Online Status	Offline
Date Last Visited	‎05-17-2025 10:30 AM

Re: caslib - Projects path in Deny List

caslib - Projects path in Deny List

GET POST methods for SAS VIYA Model studio

Restore a Model Studio project in SAS Viya

Re: Get the value of a system option

Get the value of a system option

Re: Convert string to datetime ignore timezone

Convert string to datetime ignore timezone

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: Convert string to datetime ignore timezone

Re: How to get source file path for deployed job

Re: How to get source file path for deployed job

Re: Remove unbalanced parentheses in a string

Re: Remove unbalanced parentheses in a string

Re: Get the value of a system option

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: restrict length for sas dataset column read from sql nvarchar(max)

Re: How to get source file path for deployed job

Bulkload to postgresql on AIX

Re: Send results of PROC SQL in an e-mail automatically

Break and Rbreak Before

Generate message to user as SP output

Re: Error with "WHERE %_eg_WhereParam" in STP multiple value prompt wi...

Error with "WHERE %_eg_WhereParam" in STP multiple value prompt with d...

Error with "WHERE %_eg_WhereParam" in STP multiple value prompt with d...

Proc import excel - Default character

How do I control what a SAS Stored Process returns when there is a sto...

Proc import excel - Default character

create a user defile format

How do I control what a SAS Stored Process returns when there is a sto...

Proc import excel - Default character

Data set locking issue on EG4.2.

Proc import excel - Default character

Stored process and ExcelXP tagset error and odd results