About jayvisw11

jayvisw11 · ‎01-09-2022

Hi, I am trying to create a dual axis bar-line chart with a date column on the axis. I need the format of x-axis to be in weeks. I was able to achieve that but i do not have any insight into the date range of the week. Is there any way to show the x-axis in weeks with the timeframe? attached a screenshot for better understanding. Thank you!

jayvisw11 · ‎12-19-2021

Hi, I am a new SAS VIYA user. Is there any alternative method in proc fedsql that performs the same operation as 'not in' method in SQL? Thank you!

jayvisw11 · ‎10-25-2021

Hi, Thank you for your reply. It is table created using FedSQL from an external database. E8601dz27.6 is the format of the value. data casuser.reporting_table_1; set casuser.reporting_table_1; eventtime_1 = input(eventtime,E8601dz27.6); format eventtime_1 E8601DT.; drop eventtime; rename eventtime_1 = eventtime; run; When I ran this code, I still see that the eventtime variable data type is double instead of a datatime format.

jayvisw11 · ‎10-25-2021

Small correction to my above comment, typing the column name within " " worked for me. Thank you!

jayvisw11 · ‎10-25-2021

Hi, I have a date variable (eventtime) in my table in varchar format Eg:2021-10-18T16:33:30.388148Z. how can i convert the data type from varchar to utc date? Thank you!

jayvisw11 · ‎10-22-2021

I tried to run using the name literal too but it didn't work. Finally, typing the column name within ' ' worked for me. Thank you!

jayvisw11 · ‎10-22-2021

Hi, I am trying to run a query to join two tables in a database using proc fedsql. One of the column names in table1 contains period (column name: event.eventid). While trying to run the query this I am seeing an error that event table is not found in from clause where as the table name is table1. Can anyone help me with resolving this issue? Thank you!

jayvisw11 · ‎10-22-2021

Two things helped me in resolving the issue. 1. Including the schema option while creating the caslib to establish a connection to Data warehouse via ODBC. 2. Using proc fedsql instead of proc sql to query the DW. I hope this helps. Thank you! 🙂

jayvisw11 · ‎10-19-2021

Hi, My issue is resolved now. Thank you for your response 🙂

jayvisw11 · ‎10-18-2021

Hi, I am a new SAS Viya User. I am trying to connect to the AWS Athena Data warehouse by establishing a ODBC connection. I created a caslib using the caslib statement and assigned the caslib. Can I access the files/tables in the Data warehouse without loading the data to caslib? TIA

Online Status	Offline
Date Last Visited	‎07-18-2022 09:00 PM

Dual Axis Bar-line chart format x-axis date column to weeks

NOT IN in PROC FEDSQL

Re: Convert varchar variable to datetime format

Re: table name contains period causing errors

Convert varchar variable to datetime format

Re: table name contains period causing errors

table name contains period causing errors

Re: Accessing AWS Athena Data warehouse via ODBC

Re: Accessing AWS Athena Data warehouse via ODBC

Accessing AWS Athena Data warehouse via ODBC

Dual Axis Bar-line chart format x-axis date column to weeks

NOT IN in PROC FEDSQL

Re: Convert varchar variable to datetime format

Re: table name contains period causing errors

Convert varchar variable to datetime format

Re: table name contains period causing errors

table name contains period causing errors

Re: Accessing AWS Athena Data warehouse via ODBC

Re: Accessing AWS Athena Data warehouse via ODBC

Accessing AWS Athena Data warehouse via ODBC

SAS Analytics Explorers