About newbi

newbi · ‎08-18-2011

I used the following code test=notpring(Name); if test>0 then Name=substr(Name,1,test-1) || substr(Name,test+1) The value return for name was - ACES &8S How can i get the value to shown as : ACES & 8s ? Thanks

newbi · ‎08-17-2011

I will be running this under unix. What option do i have with unix ?

newbi · ‎08-17-2011

Is it possible to export or ftp sas dataset into csv, xml or excel and schedule to run the export job ? Thanks

newbi · ‎08-15-2011

Thanks for all your help

newbi · ‎08-15-2011

define order/format=comma10. style(column)=data_date9 did not work

newbi · ‎08-15-2011

I have proc report with some of the data in Comma10. format. When i output the report data in Excel i loose the comma formatting. define order/ format = comma10.; How can i resolve this issue ?

newbi · ‎08-12-2011

How can i add date to report title ? Report name as of previous day (Today()-1) Thanks

newbi · ‎08-12-2011

Thanks. It did work fo rme.

newbi · ‎08-12-2011

Art, You code work but for some reason when i apply it to my code it doesn't work. Here is my code. Am i missing anything ? Options datastyle=ymd; ods html file = 'path' Proc Report ...... Column Date / Format=mmddyy10. group 'date' missing noprint; compute before Date / Style=[just=l]; text1 = 'Date = ' || trim(left(input(put(date,z8.),anydtdte.))); .....

newbi · ‎08-12-2011

This gives me sas date - 18850

newbi · ‎08-12-2011

Mine is numeric as well

newbi · ‎08-12-2011

mmddyy10. did not work.

newbi · ‎08-12-2011

I have date in proc report as : 20110812 but i would like to format it as 08-12-2011 What format do i need to use ?

newbi · ‎08-11-2011

Good Afternoon, I have data value ‘Ace & 8s’ and proc report is displaying ‘Aces & 8®s’ How can i show the actual data value in report ? Thanks

newbi · ‎08-05-2011

Thanks

Online Status	Offline
Date Last Visited	‎03-22-2022 01:38 PM

Re: Writing fixed-width text files

Re: Writing fixed-width text files

Re: Writing fixed-width text files

Re: Writing fixed-width text files

Writing fixed-width text files

Re: Proc SQL Delete From - Disk Space

Proc SQL Delete From - Disk Space

Re: Based on date create new variable

Based on date create new variable

Re: Remove Spaces

Proc Report - Data Format

SAS Export Data

SAS Export Data

Proc Report ODS to Excel

Proc Report ODS to Excel

Proc Report ODS to Excel

Proc Report Title

Re: Proc Report Date Format

Re: Proc Report Date Format

Re: Proc Report Date Format

Re: Proc Report Date Format

Proc Report Date Format

Proc Report Date Format

Proc Report - Data Format

Re: Date Format Questions