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: 
Nishant_saxena
‎02-22-2018
  • 11 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Checking repetition by column

by Calcite | Level 5 in SAS Programming
‎07-11-2017 11:52 AM
‎07-11-2017 11:52 AM
Hi guys, I'm stuck on a very simple n small problem and note able to form the logic. Please help me out.   sample dataset is:   store_id          configuration         store_name 1                             1                          A 2                             2                          A 3                              2                         B 4                             1                          C 5                              2                         C 6                             1                          D   I want to know if all stores sell all configurations or not ?? Please help me. Thanks ... View more

SAS Reporting based on column

by Calcite | Level 5 in ODS and Base Reporting
‎07-10-2017 03:35 PM
‎07-10-2017 03:35 PM
Hi all, Please help me out with this simple logic  my data set is : probablity      champ     date                        comment 100                xyz         08APR2012            deal closed 100               pqr         09MAY2013            deal closed 90                xyz         22JAN2011             not closed 80               xyz         20FEB2011              deal closed     and the desired output I want is like:   champ      probablity       date                       comment xyz           100           08APR2012             deal closed                  90            22JAN2011              not closed                  80            20FEB2011              deal closed pqr           100         09MAY2013              deal closed     Please help me out. Thanks   ... View more

Re: Calculating percentage in proc means or proc report or proc tabula...

by Calcite | Level 5 in SAS Procedures
‎07-04-2017 11:39 AM
‎07-04-2017 11:39 AM
Hi, I am not having anything in my input data which tells me about sum I calculated it by proc measn The solution you provided contains sales data but in my data I dont have it (rather I have to calculate it)   i am attaching input file in the attachment PLEASE IGNORE MISSING VALUES ... View more

Calculating percentage in proc means or proc report or proc tabulate

by Calcite | Level 5 in SAS Procedures
‎07-04-2017 09:55 AM
‎07-04-2017 09:55 AM
Hi All, I am stucked here: My code is:   proc means data=final_file_distance sum; class store_postcode; var retail_price; output out=rs2; run;   Output is attached in attachment.   What /I want is : (1) to calculate overall sum of " sum" column as total_sale (2) PErcentage of sale for every StorePostcode   (i.e sum/total_sale)% for individual StorePostcode ... View more

Re: Proc Report (Customizing output report)

by Calcite | Level 5 in SAS Procedures
‎07-04-2017 03:20 AM
‎07-04-2017 03:20 AM
hi there by inserting this line: output out= _result_ sum=; eveything is done  But how to display my table in reverse order i.e. 100 will be my first observation and 10 will be my last observation?? ... View more

Proc Report (Customizing output report)

by Calcite | Level 5 in SAS Procedures
‎07-03-2017 01:30 PM
‎07-03-2017 01:30 PM
Hi all, I need help in customizing my report generated by using proc report.   code I tried is: proc means data=olympics_digi_cleaned sum descending ; class _probability___; var Total_Media_value; run;   Output is attached in attachments.     What I want is : (1)   To display Prob_Digi in place of _probablity___  as my column name (2)    to display all the data in reverse order i.e _probablity 100 will be my first observation and 0 will be my last observation (3)   To display sum o all observation in sum column at last (4)   At last I also want to add a column that contain the product of _probablity___ and sum.   ... View more

Re: Do while loop SAS

by Calcite | Level 5 in SAS Programming
‎07-02-2017 11:00 AM
‎07-02-2017 11:00 AM
I was trying some stuff like:   data milage; do gallons= 1 to 10; while(distance<250); run; ... View more

Re: Do while loop SAS

by Calcite | Level 5 in SAS Programming
‎07-02-2017 10:57 AM
‎07-02-2017 10:57 AM
This solution is exactly working Thanks a lot ... View more

Do while loop SAS

by Calcite | Level 5 in SAS Programming
‎07-02-2017 08:19 AM
‎07-02-2017 08:19 AM
I am stuck to this prob;em please help me out:   A bike deliver a milage of 20 miles per gallon. write a code in SAS so that the code stops generating observations when distance reaches 250 miles or when 10 gallons of fuel  have ben used.   ... View more

Re: To fetch date difference without knowing end date.

by Calcite | Level 5 in SAS Procedures
‎07-02-2017 08:05 AM
‎07-02-2017 08:05 AM
This solution is working. Thanks a lot ... View more

To fetch date difference without knowing end date.

by Calcite | Level 5 in SAS Procedures
‎06-30-2017 10:37 AM
‎06-30-2017 10:37 AM
I have following data set and want to calculate number of years from 31 march 2014 for each record from couponexpiry column.(USING INTCK FUNCTION) Please revert with working solutions as soon as possible thanks   storeid hlthfood size org custid gender shopfor veg style usecoup week seq carry coupval amtspent couponexpiry 1 0 2 2 1 0 1 0 1 3 1 4 0 4 215.28 20/02/2014 1 0 2 2 1 0 1 0 1 3 2 4 4 3 0 21/02/2014 1 0 2 2 1 0 1 0 1 3 3 4 3 2 192.81 22/02/2014 1 0 2 2 1 0 1 0 1 3 4 4 2 1 8.24 23/02/2014 1 0 2 2 2 0 1 0 1 3 1 3 0 3 16.71 24/02/2014 1 0 2 2 2 0 1 0 1 3 2 3 3 1 171.91 25/02/2014 1 0 2 2 2 0 1 0 1 3 3 3 1 4 12.82 26/02/2014 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-22-2018 12:56 PM
Quick links