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: 
DeepikaM
‎11-04-2015
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Removing Exponents while creating CSV file using ODS CSV

by Calcite | Level 5 in SAS Programming
‎11-04-2015 04:55 AM
‎11-04-2015 04:55 AM
Hi,   Yes thats correct. But I want a solution which we can apply in SAS code which I gave above. So that when the CSV file is created , we will be able to see the number without exponents(original value)   Is there any possible solution which can be applied in ODS CSV or PROC REPORT?   Thanks in Advance. ... View more

Removing Exponents while creating CSV file using ODS CSV

by Calcite | Level 5 in SAS Programming
‎11-04-2015 01:54 AM
‎11-04-2015 01:54 AM
Hi, I am creating a semicolon seperated CSV file using ODS CSV. Numeric column which is phone number and 15 digits long are being displayed as exponents in CSV file(opening using MS Excel). Also I have one character column which holds numeric value which is 20-25 digits , even that column is displayed as exponents in CSV file(opening using MS Excel). Please find the code below which I am using: ods csv file="&FileLoc.&FileName..csv" options(delimiter=";"); Options missing=''; proc report data=INVOICE_NOVAT split='#' ls=255; columns ( PHONE_NUMBER USER_NAME USER_REFERENCE1 USER_REFERENCE2 USER_REFERENCE3 YEAR MONTH INVOICE_ID FEES_NET DOMESTIC_USAGE_NET); define PHONE_NUMBER/display 'Subscription' ; define USER_NAME/display 'User'; define USER_REFERENCE1/display 'User reference 1'; define USER_REFERENCE2/display 'User reference 2'; define USER_REFERENCE3/display 'User reference 3'; define YEAR/display 'Year'; define MONTH/display 'Month'; define INVOICE_ID/display 'Invoice Number' ; define FEES_NET/display 'Fees'; define DOMESTIC_USAGE_NET/display 'Domestic usage (speech/SMS/MMS/data)'; run; ods csv close; Examples: INVOICE_ID : 5504694476130 PHONE_NUMBER : 580000404271 Your help is highly appreciated. ... View more

Linking a report that contain info windows

by Calcite | Level 5 in SAS Visual Analytics
‎06-23-2015 04:51 AM
‎06-23-2015 04:51 AM
Hi All, I have a requirement where I want to create a hyperlink for a report which contain info windows. I am not able to create link for that report. It gives Error saying "The report could not be opened" Kindly help me and confirm if it is not possible to create link for such type of report. Thanks in advance. Regards Deepika Mehta ... View more

Increase threshold for List table

by Calcite | Level 5 in SAS Visual Analytics
‎04-15-2015 03:41 AM
‎04-15-2015 03:41 AM
Hi, I am facing issue wherein we have lot of records(approx 3 lacs) to be viewed in List table. It shows only 50,000 records when exported in MS excel. I have gone through SAS VA admin guide 7.1, we have to set properties in SMC to increase the thresholds The property used to increase the limit is:      vae.FetchRowsServerLimit This is used only for explorers. I am not able to view the same setting in my SMC. Is there is any option where we can increase the display limit in the Report designer and Viewer? Please suggest. Regrads, Deepika Mehta ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-04-2015 05:36 AM
Quick links