About dewanganrahul

dewanganrahul · ‎07-28-2022

I am working on conversion of SQL Server queries into SAS code. Add_Days has been used to add no of days in date column. For example- add_days(date_column,15). Please suggest alternate for this function which can be used in SAS with PROC SQL.

dewanganrahul · ‎07-28-2022

This function is used with one of the variable/column and I am using multiple variable selection with case when statement, so to go for other sas option/tool looks more effort or may not convenient. So hardly looking to check it with same PROC SQL option. If not possible ultimately then I can go for other option. I don't have SQL Server to perform this checks. In-fact, the requirement is to convert the SQL Server queries to SAS code. The best and less effort option, I found is PROC SQL.

dewanganrahul · ‎07-28-2022

I have SQL Server queries which needs to be convert into SAS code. So, I am writing the queries under PROC SQL in SAS and using the cast function in SELECT CLAUSE, but I am getting error at place 'as'. PFB, the example:- proc sql; select cast(variable_name as nvarchar) as Variable1 from table1; quit; I am getting the error at first 'as' place and showing me the syntax error.

dewanganrahul · ‎07-28-2022

@PaigeMiller Can you please provide the solution which can be written under PROC SQL? Since, I am converting the SQL Server queries to PROC SQL code in SAS. FYI: I am writing in the SELECT CLAUSE.

dewanganrahul · ‎07-28-2022

Please let me know the equivalent function for string_agg (which is generally used in SQL Server) in SAS. It is being used in SQL Server as:- Sting_Agg(Variable_Name,';'). Where Variable_Name is any variable in sas and ; is separator. PFB, is the clear picture of how it works

dewanganrahul · ‎07-28-2022

Please let me know the equivalent function for string_agg (which is generally used in SQL Server) in SAS. It is being used in SQL Server as:- Sting_Agg(Variable_Name,';'). Where Variable_Name is any variable in sas and ; is separator. Attached is the clear picture of how it works

Online Status	Offline
Date Last Visited	‎07-28-2022 09:32 AM

Looking for equivalent function in SAS

Re: Looking for equivalent function is SAS

How to use cast function in SAS

Re: Looking for equivalent function is SAS

Looking for equivalent function is SAS

Looking for equivalent function in SAS

Re: How to use cast function in SAS

Re: How to use cast function in SAS

Looking for equivalent function in SAS

Re: Looking for equivalent function is SAS

How to use cast function in SAS

Re: Looking for equivalent function is SAS

Looking for equivalent function is SAS

Looking for equivalent function in SAS

SAS Analytics Explorers