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: 
ADN
‎03-19-2024
  • 16 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

SAS Export data with double quotes escaped with backslash.

by Fluorite | Level 6 in SAS Programming
‎03-19-2024 01:03 AM
‎03-19-2024 01:03 AM
I have a SAS dataset which I want to export as csv with each value enclosed around double quotes(").  Now one of the values is as Arijit "Debnath.   Currently the ds2csv macro exports it as "Arijit ""Debnath" I want it to be exported as "Arijit \"Debnath".   Is there any way to achieve the same. ... View more

Re: SAS UTF-8 Error while processing data from Azure Databricks

by Fluorite | Level 6 in SAS Programming
‎03-08-2023 09:57 AM
‎03-08-2023 09:57 AM
I did. But same error. ... View more

SAS UTF-8 Error while processing data from Azure Databricks

by Fluorite | Level 6 in SAS Programming
‎03-08-2023 08:11 AM
‎03-08-2023 08:11 AM
I am pulling data from Azure Databricks using JDBC when I get an error as below. It seems to be a transcoding issue. My SAS session is running on LATIN1 encoding. I am using below command to run my programs right now. Any idea how to invoke SAS in UTF-8 mode from command line in Unix.   ERROR: Data from column 'Var1' in row 273138 of the result set was not presented in UTF-8 format. The length of this data is 17 bytes, and the first 7 characters are 'Castili'. Adding -JREOPTIONS (-Dfile.encoding=UTF-8) to the SAS invocation may circumvent the issue. Otherwise the data should be corrected to UTF-8 format. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. SAS Unix command:  /opt/sas/sharebi/config/Lev1/Applications/SASGridManagerClientUtility/9.4/sasgsub -gridsubmitpgm data_pull.sas -gridwork /data/team_abc/log -gridwaitnoresults ... View more

Re: Live data connection to Postgres from SAS VA 7.4

by Fluorite | Level 6 in SAS Visual Analytics
‎08-01-2019 04:07 AM
‎08-01-2019 04:07 AM
By a live connection, I mean the VA report should show exactly what is in the database table at that point of time.   The data in my Postgres database is updated 3-4 times a day. Is there any other way of doing this other than running a scheduled job? ... View more

Live data connection to Postgres from SAS VA 7.4

by Fluorite | Level 6 in SAS Visual Analytics
‎07-31-2019 07:26 AM
‎07-31-2019 07:26 AM
Hi,   I am trying to create a report in SAS VA 7.4 and my data resides in a Postgres Database. I want to have a live connection to the database. Is it possible to do it without importing the table everytime into SAS Visual Analytics Public LASR library?   Thanks. ... View more

Re: Clickable link in SAS VA 7.4

by Fluorite | Level 6 in SAS Visual Analytics
‎07-08-2019 04:20 AM
‎07-08-2019 04:20 AM
Hi, Thanks for the solution. But I am actually looking for the same report in SAS VA and not as html. ... View more

Clickable link in SAS VA 7.4

by Fluorite | Level 6 in SAS Visual Analytics
‎07-05-2019 02:21 AM
‎07-05-2019 02:21 AM
Hi,    It is possible to create a clickable hyperlink like the one below in Excel in SAS VA 7.4 in a list table (Instead of the user double clicking on a row to open the link).   ... View more

XML Map: Showing element tags when value is missing

by Fluorite | Level 6 in SAS Programming
‎11-05-2018 02:34 AM
‎11-05-2018 02:34 AM
I am using XMLV2 engine to export SAS datasets to xml. The issue is when a numeric value is missing. By default SAS shows  <column_name>.</column_name>. If I set options missing="" then I get only <column_name />.   Is there any way to show <column_name></column_name> without the dot for numeric missing values when using xmlmap.   Sample Code is given below: libname lib1 xmlv2 "/data/sample.xml" xmlmap="/data/sample_data.map"; data lib1.abcd; set temp;/*Dataset containing 10 numeric and 10 character columns*/ run;   ... View more

Re: Proc SQL join with OR in where clause

by Fluorite | Level 6 in SAS Programming
‎05-24-2018 04:07 AM
‎05-24-2018 04:07 AM
The master table Z is a union of all the ID's present in tables T1/T2/T3 and T4. ID's present in all the 5 tables are disctinct.   Unfortunately the data belongs to my client and I cant post it. But here is some sample data for the same.   data T1; input ID $20; datalines; 1 2 3 ; run;   data T2; input ID $20; datalines; 4 5 6 ; run;   data T3; input ID $20; datalines; 7 8 9 ; run;   data T4; input ID $20; datalines; 10 11 12 ; run;   data Z; input ID $20; datalines; 1 2 3 4 5 6 7 8 9 10 11 12 ; run; ... View more

Proc SQL join with OR in where clause

by Fluorite | Level 6 in SAS Programming
‎05-24-2018 03:23 AM
‎05-24-2018 03:23 AM
Hi,   I have 4 tables T1,T2,T3 and T4 and also a master table Z. The condition I have to join the tables to the master table is    T1.ID1=Z.ID OR T1.ID2=Z.ID OR T1.ID3=Z.ID OR T1.ID4=Z.ID   Is there any way to optimize these type of joins? This join is taking too much time for me(> 1 hr).   The tables T1,T2,T3 and T4 have 100k obs and Z has 400k obs approx. ... View more

Re: Font properties in ODS Excel

by Fluorite | Level 6 in ODS and Base Reporting
‎04-20-2017 05:18 AM
‎04-20-2017 05:18 AM
I am using sas 9.04.01M3P062415   I think the Fonts are not coming as expected. Rest is still fine........ ... View more

Font properties in ODS Excel

by Fluorite | Level 6 in ODS and Base Reporting
‎04-19-2017 09:10 AM
‎04-19-2017 09:10 AM
Hi,   I am using SAS ODS Excel to generate excel files with tables. My question is how do I set the font, font size, color and font weight.    Previously I used something like this in SAS ods excelxp tagset. But that does not seem to be working anymore.   define tot_defects/ display style(header)={font_face="Calibri" font_size=12pt font_weight=bold background=CX2E8B57 foreground=CXFFFFFF just=c} style(column)={font_face="Calibri" font_size=10pt just=c};     ... View more

Re: Import only Delivered columns using XMLMAP

by Fluorite | Level 6 in SAS Programming
‎04-13-2017 08:43 AM
‎04-13-2017 08:43 AM
Hi, Can you elaborate? Not entirely clear to me.... ... View more

Re: Import only Delivered columns using XMLMAP

by Fluorite | Level 6 in SAS Programming
‎04-13-2017 06:54 AM
‎04-13-2017 06:54 AM
Yes. As such it is not much of an issue. But I cannot differentiate between these two cases:   The sender sent a column but it is blank altogether The sender didn't send a column at all   In the first case, I have to report it as a defect while in the second case I don't do anything..... ... View more

Re: Import only Delivered columns using XMLMAP

by Fluorite | Level 6 in SAS Programming
‎04-13-2017 06:46 AM
‎04-13-2017 06:46 AM
The issue I have is that in totality the sender is supposed to send 10 columns. But they don't send all the 10 columns at once. They send it incrementally. So when he sends me 5 columns, I only want the 5 columns to popup in my table... ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-19-2024 12:32 PM
Likes given to
View All
Quick links