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: 
zdassu
‎07-17-2019
  • 45 Posts
  • 1 Likes Given
  • 2 Solutions
  • 3 Likes Received

Re: today() function between two dates

by Quartz | Level 8 in SAS Programming
‎07-17-2019 10:31 AM
‎07-17-2019 10:31 AM
Hi I tried that code but it does not bring back any records at all, the results table is blank ... View more

today() function between two dates

by Quartz | Level 8 in SAS Programming
‎07-17-2019 10:12 AM
‎07-17-2019 10:12 AM
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; ... View more

Removing decimals places in SAS

by Quartz | Level 8 in SAS Programming
‎07-04-2019 06:11 AM
‎07-04-2019 06:11 AM
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     ... View more

Re: Convert Merge to SQL

by Quartz | Level 8 in SAS Programming
‎04-11-2019 05:05 AM
‎04-11-2019 05:05 AM
Unfortunately, I am unable to access the SAS Server from Hadoop ... View more

Re: Convert Merge to SQL

by Quartz | Level 8 in SAS Programming
‎04-11-2019 05:04 AM
‎04-11-2019 05:04 AM
Hi I am a little confused how the code works, where would I put my column names ... View more

Re: Convert Merge to SQL

by Quartz | Level 8 in SAS Programming
‎04-05-2019 08:13 AM
‎04-05-2019 08:13 AM
Our Servers are moving from SAS server to a Hadoop Server   ... View more

Re: Convert Merge to SQL

by Quartz | Level 8 in SAS Programming
‎04-05-2019 07:04 AM
‎04-05-2019 07:04 AM
Hi I agree, However I have to convert this to SQL because i have to re-write the Scripts in Hadoop ... View more

Convert Merge to SQL

by Quartz | Level 8 in SAS Programming
‎04-05-2019 06:30 AM
‎04-05-2019 06:30 AM
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 ... View more

Re: Bringing back distinct column from a dataset

by Quartz | Level 8 in SAS Programming
‎01-08-2019 08:43 AM
‎01-08-2019 08:43 AM
Thanks for your help kiranv_ ... View more

Bringing back distinct column from a dataset

by Quartz | Level 8 in SAS Programming
‎01-08-2019 07:27 AM
‎01-08-2019 07:27 AM
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; ... View more

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

by Quartz | Level 8 in SAS Programming
‎10-25-2018 07:19 AM
3 Likes
‎10-25-2018 07:19 AM
3 Likes
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; ... View more

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

by Quartz | Level 8 in SAS Programming
‎10-25-2018 07:01 AM
‎10-25-2018 07:01 AM
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 ... View more

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

by Quartz | Level 8 in SAS Programming
‎10-25-2018 06:07 AM
‎10-25-2018 06:07 AM
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 ... View more

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

by Quartz | Level 8 in SAS Programming
‎10-25-2018 06:03 AM
‎10-25-2018 06:03 AM
Thanks for your help but how do I count all records in name for say Oct 2008 and so on ... View more

Group by Month and Year and Count by Name field

by Quartz | Level 8 in SAS Programming
‎10-25-2018 05:23 AM
‎10-25-2018 05:23 AM
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 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-17-2019 02:41 PM
Likes given to
View All
Likes from
View All
Quick links