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: 
Ankitsas
‎09-01-2015
  • 14 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Leave 3 best results in table

by Calcite | Level 5 in SAS Programming
‎05-04-2013 10:35 AM
‎05-04-2013 10:35 AM
Or, you can use the below code - data test; input  Name $ Age ; datalines; Tom        15 Garry       14 Susan     14 Paul        13 Shaun     12 ; proc sort data=test; by descending age; run; data name; set test; if _n_ <=3; run; ---Ankit ... View more

Re: Macro variable check

by Calcite | Level 5 in SAS Programming
‎03-25-2013 02:31 PM
‎03-25-2013 02:31 PM
Replace -- %If &ak in %str(abd2001,abd2005) with %If &ak in (abd2001,abd2005) Note - %str is used to mask commas,% etc. ... View more

Re: macro to merge datasets with same dataset name but different libna...

by Calcite | Level 5 in SAS Programming
‎03-12-2013 06:06 AM
‎03-12-2013 06:06 AM
Below is the changed code - x=&i; run; %end; %mend; %t; %macro dd; data mpp; set %do i =1 %to 3 ; rs&i..t %end; ; run; %mend; %dd Note - i removed libname and replaced merge with set statement. Regards, Ankit ... View more

Re: Date issue

by Calcite | Level 5 in SAS Programming
‎03-11-2013 12:32 PM
‎03-11-2013 12:32 PM
Hi saspert, Please look at the below code and it will serve your purpose. data a; input date1 : mmddyy10. date2 : mmddyy10.; format date1 date2 date9.; datalines; 07/31/2011 07/01/2011 12/31/2011 12/01/2011 ; data b; set a; if date1='31dec2011'd then output;     // adding a 'd' is possible only with date9. date format and not with mmddyy date format. run; Note - In the above example i am reading  the nonstandard date value , sas stores date values in numeric format, then i am using format statement to convert the date value into a comparable format. Let me know in case of any queries. Thanks, Ankit ... View more

Re: Filling missing values

by Calcite | Level 5 in SAS Procedures
‎02-03-2013 10:04 AM
‎02-03-2013 10:04 AM
Hi Costasg, Sincere apology, please find the updated code below :- data test; set tmp1.air; run; /*****filling country value*****/ proc sort data=test out=test_sorted; by mgrno descending country; run; data step1(drop=country rename=(country_new=country)); set test_sorted; by mgrno ; retain country_new; if first.mgrno then country_new=country; run; /****filling  Exchange Code, Stock Class Code, Stock Class Description and Industry Code***/ proc sort data=step1 out=step1_sorted; by ticker descending EXCHCD descending STKCD descending STKCDESC descending INDCODE; run; data step2(drop=EXCHCD STKCD STKCDESC INDCODE rename=(exchcd_new=EXCHCD STKCD_new=STKCD STKCDESC_new=STKCDESC INDCODE_new=INDCODE)); set step1_sorted; by ticker; retain exchcd_new STKCD_new STKCDESC_new INDCODE_new; if first.ticker then do; exchcd_new=EXCHCD; STKCD_new=STKCD; STKCDESC_new=STKCDESC; INDCODE_new=INDCODE; end; run; Please use this code and hope it will work Thanks, Ankit ... View more

Re: Filling missing values

by Calcite | Level 5 in SAS Procedures
‎02-03-2013 09:34 AM
‎02-03-2013 09:34 AM
Hi Costasg, Below is the code which should help you to serve your purpose - data test; set tmp1.air; run; /*****filling country value*****/ proc sort data=test out=test_sorted; by mgrno descending country; run; data step1(drop=country rename=(country_new=country)); set test_sorted; by mgrno ; retain country_new; if first.mgrno then country_new=country; run; /****filling  Exchange Code, Stock Class Code, Stock Class Description and Industry Code***/ proc sort data=step1 out=step1_sorted; by ticker descending EXCHCD descending STKCD descending STKCDESC descending INDCODE; run; data step2(drop=EXCHCD STKCD STKCDESC INDCODE rename=(exchcd_new=EXCHCD STKCD_new=STKCD STKCDESC_new=STKCDESC INDCODE_new=INDCODE)); set step1_sorted; by ticker; if first.ticker then do; exchcd_new=EXCHCD; STKCD_new=STKCD; STKCDESC_new=STKCDESC; INDCODE_new=INDCODE; end; run; Let me know in case of any queries Thanks, Ankit ... View more

Re: Filling missing values

by Calcite | Level 5 in SAS Procedures
‎02-03-2013 08:24 AM
‎02-03-2013 08:24 AM
Hi Costasg, Can you please elaborate on the statement "So COUNTRY variable should be filled according to manager number and RDATE" ?i was trying to work around on this, but the sentence sounds little noisy so thought to ask you. Thanks, Ankit ... View more

Re: Select all

by Calcite | Level 5 in SAS Programming
‎02-02-2013 03:58 AM
‎02-02-2013 03:58 AM
Hi James, Below is the code you should use to get the desired output. proc sql; create table table-name as SELECT * FROM table      WHERE Date = '31MAR2011'D; quit; Thanks, Ankit ... View more

Merging datasets without using MERGE statement

by Calcite | Level 5 in SAS Programming
‎07-03-2011 03:24 PM
‎07-03-2011 03:24 PM
Friend, Use proc sql using inner join instead of merge statement... Ankit ... View more

collapse data

by Calcite | Level 5 in SAS Programming
‎06-26-2011 01:48 PM
‎06-26-2011 01:48 PM
Friend, Please find the below code , this will you the output as per your needs:- data test; input @1 full_name $10.  @12 city $7. @20 state $  @23 h_rc1 comma5. @28 p_rc1 comma5. @32 s_rc1 comma5. @37 t_rc1 comma5.; datalines; Rice Brown Raleigh NC $167 0   0    0 Rice Brown Raleigh NC 0    0   $123 0 Rice Brown Raleigh NC 0    124 0    0 Rice Brown Raleigh NC 0    0   0    $125 ; data test1; set test; by full_name city state; if first.state then s=0; if first.state then s1=0; if first.state then s2=0; if first.state then s3=0; s+h_rc1; s1+p_rc1;s2+s_rc1;s3+t_rc1; if last.state; h_rc1=s; p_rc1=s1; s_rc1=s2; t_rc1=s3; run; ... View more

Re: Delete empty rows from a dataset

by Calcite | Level 5 in SAS Programming
‎06-20-2011 02:20 AM
‎06-20-2011 02:20 AM
this code is not removing the empty rows ... View more

Re: Max/Min date function on a variable

by Calcite | Level 5 in SAS Programming
‎06-19-2011 07:58 AM
‎06-19-2011 07:58 AM
Friend, I hope the below code will suffix your problem, if not please do update me to make corrections data test; input id date date7. sales; format date date7.; datalines; 1 01Jan11 12 1 02Jan11 20 2 12Jan11 34 2 23Feb11 21 ; proc sort; by id descending date; run; data test1; set test; by id; if first.id then total_sales=0; total_sales+sales; if last.id; run; proc print; run; ... View more

Re: merging datasets to generate new column

by Calcite | Level 5 in SAS Programming
‎06-18-2011 02:16 PM
‎06-18-2011 02:16 PM
Dude, The code is as follows , you will get what you need:- data store1; input id product type $; datalines; 1 112 refferal 2 112 approval 3 112 ship 4 113 ship ; run; data store2; input product productname $; datalines; 112 xyz 113 abc 115 def ; run; proc sort data=store1; by product; run; proc sort data=store2; by product; run; DATA store3; MERGE store1(in=a) store2(in=b); BY product; if a; RUN; ... View more

Re: Do loop or array?

by Calcite | Level 5 in SAS Programming
‎06-13-2011 04:31 PM
‎06-13-2011 04:31 PM
Friend, You can use the below code to count the number of zeros in an observation data a; input m1-m12; cards; 0 1 4 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 6 0 ; run; data aa; set a; count = 0; array a[12] m1-m12; do i = 1 to 12; if a = 0 then count+1; end; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links