About zdassu

zdassu · ‎07-17-2019

Hi I tried that code but it does not bring back any records at all, the results table is blank

zdassu · ‎07-17-2019

Hi I am trying to bring back data between two dates using the today() function. I don't think I can do this in Data step but is there an equivalent that I can use. See code that I have created below data work.tempA; keep Name_Id Address_Id; set work.tempb; WHERE is_current_flg = 1 AND record_deleted_flg = 0 AND today()between Valid_From_Dt and Valid_To_Dt; run;

zdassu · ‎07-04-2019

Hi I have a table with decimal places, The field is text and I want to remove the decimal places which have no values. See examples below Current Table Field_1 22.5 1.000 40.000 1.25 I would like the table to look as per below, your help in this matter is much appreciated Field_1 22.5 1 40 1.25

zdassu · ‎04-11-2019

Unfortunately, I am unable to access the SAS Server from Hadoop

zdassu · ‎04-11-2019

Hi I am a little confused how the code works, where would I put my column names

zdassu · ‎04-05-2019

Our Servers are moving from SAS server to a Hadoop Server

zdassu · ‎04-05-2019

Hi I agree, However I have to convert this to SQL because i have to re-write the Scripts in Hadoop

zdassu · ‎04-05-2019

Hi How do I convert the following merge code to SQL? data SAP_Bill.erdo_main(sortedby=opbel); merge SAP_Bill.erdo_max SAP_Bill.erdk(in=a); by opbel; label erdk_frei_am='Invoice_Release_Date'; if a and first.opbel then output; run; I have included the names bwlow of the columns from the input tables and the output table, i would like the SQL code to have the same Output Erdo_Max Table (Input) opbel erdk_frei_am ERDK Table (Input) intopbel vkont opbel total_amnt budat simulated stokz tobreleasd ERDO_Main (Output) opbel erdk_frei_am intopbel vkont total_amnt budat simulated stokz tobreleasd Thanks In Advance

zdassu · ‎01-08-2019

Thanks for your help kiranv_

zdassu · ‎01-08-2019

Hi I am trying to group on a table and I am trying to bring back just 1 column, I can do using SQL but I was wandering if someone knows how to do it in data step. The table has many columns but I only want to bring back 1. Proc sql; select distinct t1.month_received from have t1; run; I tried using Proc Sort but I was not sure how to bring back just the one column, is there anyway I can bring back just the 1 column or do I have to create another data step proc sort data=have nodupkey out=have1; by month_received; run;

zdassu · ‎10-25-2018

I changed the code and it works fine proc sql; create table want as select put(Date,yymmd5.) as month, count(*) as count from have group by month order by month desc; quit;

zdassu · ‎10-25-2018

Thanks for your help, if I want the results to look like the below what do I have to chance in your code month count 10-06 673 10-05 79 10-04 942 10-03 970

zdassu · ‎10-25-2018

Thanks for your help but how do I count all records in name for say Oct 2008 and so on, so the results look like the below Name date 2 Oct 2008 7 Nov 2008

zdassu · ‎10-25-2018

Thanks for your help but how do I count all records in name for say Oct 2008 and so on

zdassu · ‎10-25-2018

Hi I was hoping someone can help, I have a data set with millions of lines and I want to group count by name field and group by date, However the date field currently has the day in there as well current format for the date field in the table is YYMMDD8, see some sample data below Name Date 54642 18-08-31 217233 18-08-15 502368 18-08-09 541562 16-08-31 553023 16-08-09 577616 17-05-31 601365 15-06-31 Kind Regards Zuneid

Online Status	Offline
Date Last Visited	‎07-17-2019 02:41 PM

Re: today() function between two dates

today() function between two dates

Removing decimals places in SAS

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Convert Merge to SQL

Re: Bringing back distinct column from a dataset

Bringing back distinct column from a dataset

Re: Group by Month and Year and Count by Name field

Re: Group by Month and Year and Count by Name field

Re: today() function between two dates

today() function between two dates

Removing decimals places in SAS

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Re: Convert Merge to SQL

Convert Merge to SQL

Re: Bringing back distinct column from a dataset

Bringing back distinct column from a dataset

Re: Group by Month and Year and Count by Name field

Re: Group by Month and Year and Count by Name field

Re: Group by Month and Year and Count by Name field

Re: Group by Month and Year and Count by Name field

Group by Month and Year and Count by Name field