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: 
damanaulakh88
‎01-04-2018
  • 81 Posts
  • 5 Likes Given
  • 0 Solutions
  • 38 Likes Received

Re: Formatting dates in SAS

by Obsidian | Level 7 in SAS Procedures
‎03-06-2013 11:20 PM
‎03-06-2013 11:20 PM
Hi Omega, Please find below the code and its output for you problem:- Code:- ================================================= data new; informat mydate mmddyy10.; input mydate ; format mydate mmddyy10.; datalines; 03/04/2013 11/03/2012 04/11/2012 01/01/2011 05/09/2009 ; run; data new1(drop= month day year); set new; month=month(mydate); day=day(mydate); year=year(mydate); new_date=cats(month,"/",day,"/",year); run; =============================================== Output:- ================================================ Obs        mydate    new_date 1     03/04/2013    3/4/2013 2     11/03/2012    11/3/2012 3     04/11/2012    4/11/2012 4     01/01/2011    1/1/2011 5     05/09/2009    5/9/2009 ================================================== /Daman ... View more

Re: Problem with PROC EXPAND and ID statement

by Obsidian | Level 7 in SAS Procedures
‎03-06-2013 11:02 PM
‎03-06-2013 11:02 PM
Hi , Please refer to this . I think this might help you :- A BY statement can be used with PROC EXPAND to obtain separate analyses on observations in groups defined by the BY variables. The input data set must be sorted by the BY variables and be sorted by the ID variable within each BY group. Use a BY statement when you want to interpolate or convert time series within levels of a cross-sectional variable. For example, suppose you have a data set STATE containing annual estimates of average disposable personal income per capita (DPI) by state and you want quarterly estimates by state. These statements convert the DPI series within each state:    proc sort data=state;       by state date;    run;    proc expand data=state out=stateqtr from=year to=qtr;       convert dpi;       by state;       id date;    run; /Daman ... View more

Re: How could I write this macro?

by Obsidian | Level 7 in SAS Procedures
‎03-06-2013 02:42 AM
3 Likes
‎03-06-2013 02:42 AM
3 Likes
Hi, Please find below the updated code:- %macro name_1 (mon); proc sort data=&mon._; by bank_number account_number ; run; %mend; %name_1 (FEB_2010); Thanks. /Daman ... View more

Re: How could I cut short these 35 repeated statements?

by Obsidian | Level 7 in SAS Procedures
‎03-06-2013 02:40 AM
‎03-06-2013 02:40 AM
Hi Mirisage, Please find below the macro for your code:- ====================================== data  FEB_2010; input bank_number account_number balance; datalines; 123 1313 232131 322 2321 231232 ; run; %macro mnth(mon); data &mon._ (rename=(balance=&mon._balance)); set &mon. (keep= bank_number account_number balance); run; proc print data=&mon._; run; %mend; %mnth(FEB_2010);- This you can repeat with any month. ============================================= Output:- =======================================================                                                        bank_    account_    FEB_2010_                                                Obs    number     number      balance                                                 1       123       1313        232131                                                 2       322       2321        231232 ========================================================= /Daman ... View more

Re: insert missing values when condition not satisfied

by Obsidian | Level 7 in SAS Programming
‎02-26-2013 02:10 AM
‎02-26-2013 02:10 AM
Hi Mano, Please find below code for your problem:- data new; informat EVENT_DATE date9. VISIT_DATE date9.; input EVENT_TYPE $ EVENT_DATE VISIT_DATE REASON_FOR_VISIT $10.; FORMAT EVENT_DATE date9. VISIT_DATE date9.; datalines; ARI 01JUN2012 01JUN2012 ARI ARI 20JUN2012 20JUN2012 ARI ARI 04AUG2012 04AUG2012 ARI ARI 04AUG2012 10AUG2012 ARI-WORSE ARI 12SEP2012 12SEP2012 ARI WORSE 01OCT2012 01OCT2012 WORSE WORSE 01OCT2012 12OCT2012 WORSE ; run; proc sql; create table final as select a.* from new a where event_date=visit_date union select b.event_date,b.visit_date," " as event_type, b.reason_for_visit from new b where b.event_date<>b.event_date); quit; Output:- Hope this solves your problem /Daman ... View more

Error in PROC AUTOREG.

by Obsidian | Level 7 in SAS Procedures
‎02-25-2013 12:54 AM
‎02-25-2013 12:54 AM
Can you please help me on this below error:- WARNING: Exact fit. No residual in model to analyze. NOTE: The above message was for the following BY group:       Terminal=Hamar postterminal prodgrservniva=10 prodgrformat=Små WARNING: Exact fit. No residual in model to analyze. NOTE: The above message was for the following BY group:       Terminal=Hamar postterminal prodgrservniva=10 prodgrformat=Store WARNING: Exact fit. No residual in model to analyze. NOTE: The above message was for the following BY group:       Terminal=Hamar postterminal prodgrservniva=10 prodgrformat=Klump ERROR: Floating Point Overflow. ERROR: Termination due to Floating Point Exception NOTE: The SAS System stopped processing this step because of errors. Below is the code i am using:- PROC AUTOREG DATA=prognose noprint;         by terminal prodgrservniva prodgrformat;         MODEL ant_sendinger=         man tir ons tor fre lor son         rompaske1 rompaske2 rompaske3 romjul         fellesferie skoleferie         hel_for_arb jul_ny_aften helg_f_jul         arb_etter_hel trend1 trend2         /NLAG=2 NOINT method=ml                                 ;         OUTPUT OUT=res_prognose         p=antallhat pm=antalltrend r=residind lcl=lcl ucl=ucl alphacli=0.20;       RUN; Thanks, Daman ... View more

Re: Clarification on deleting observations from dataset

by Obsidian | Level 7 in SAS Procedures
‎02-22-2013 03:29 AM
3 Likes
‎02-22-2013 03:29 AM
3 Likes
Hi , Run it with Single Quotes , it will work then:- For Example:- ===================== or Combo like '%23601%' - CORRECT or Combo like "%23601%"- WRONG ===================== /Daman ... View more

Re: Clarification on deleting observations from dataset

by Obsidian | Level 7 in SAS Procedures
‎02-21-2013 10:48 PM
3 Likes
‎02-21-2013 10:48 PM
3 Likes
Hi Nicholas, Here you go with the modified code :- proc sql; create table nicholas._21603_trimmed as select * from nicholas._21603_ except select * from nicholas._21603_ where Combo like '%Low%' or combo like'%High%'; quit; /Daman ... View more

Re: Clarification on deleting observations from dataset

by Obsidian | Level 7 in SAS Procedures
‎02-21-2013 05:44 AM
‎02-21-2013 05:44 AM
And moreover if you want to do it through dataset then below is the code:- ============== data final; set new; if index(COMBO,'Low') >0 then delete; run; ============== /Daman ... View more

Re: Clarification on deleting observations from dataset

by Obsidian | Level 7 in SAS Procedures
‎02-21-2013 05:34 AM
‎02-21-2013 05:34 AM
Hi Nicholas, Try this code this is working:- ============ data new; input sno combo $; datalines; 1 Low_A 2 Low_B 3 High_c ; run; proc sql; create table final as select * from new except select * from new where combo like '%Low%'; quit; ===================== Output:- ============ Obs    sno    combo 1      3     High_c ============= ... View more

Re: Displaying percentage change over time

by Obsidian | Level 7 in SAS Procedures
‎02-20-2013 10:33 PM
‎02-20-2013 10:33 PM
Hi Greg, Please find below the code you require :- ================================================================ data new; infile datalines dlm=',' dsd; input year $ gr_count ug_count; datalines; "2008",5045,7420 "2009",5500,7837 "2010",5696,8481 "2011",5708,9010 "2012",5725,9443 ; run; data percent; set new; a=lag(gr_count); change=((gr_count-a)/a)*100; mean=mean(change); run; proc transpose data=percent out=new prefix=Year; id year; var change; run; data final(drop= _NAME_); set new; Average=mean(of Year2008-Year2012); run; ======================================================================= Output:- =============================================================================                              Obs    Year2008    Year2009    Year2010    Year2011    Year2012    Average                               1         .        9.01883     3.56364     0.21067     0.29783    3.27274 ============================================================================== /Daman ... View more

Re: proc sql distinct query

by Obsidian | Level 7 in SAS Programming
‎02-20-2013 07:42 AM
‎02-20-2013 07:42 AM
Hi Vijay, Please find below the code and its output:- ========================================== data new; input col1 $ col2 $ col3 $ col4 $ col5 $ amount; datalines; a b c d e 23 d e f g h 34 a b g h j 36 a b c d e 45 a b c d e 90 d e f g h 80 a s d f g 70 ; run; proc sql; create table summarize as select distinct col1,col2,col3,col4,col5 ,count(*) as Count , sum(amount) as Sum from new group by col1,col2,col3,col4,col5; quit; =========================================== Output:- =====================================                                     Obs    col1    col2    col3    col4    col5    Count    Sum                                      1      a       b       c       d       e        3      158                                      2      a       b       g       h       j        1       36                                      3      a       s       d       f       g        1       70                                      4      d       e       f       g       h        2      114 ===================================== I hope this solves your query. /Daman ... View more

Re: problem with RBREAK Statement in PROC report

by Obsidian | Level 7 in SAS Procedures
‎02-20-2013 05:35 AM
‎02-20-2013 05:35 AM
Hi, Try this, proc report data = sasuser.admit out = want; columns actlevel (min max),fee height; define fee/analysis sum; define actlevel/group; break after actlevel/ ol skip summarize; rbreak after/summarize dol dUl; run; /Daman ... View more

Re: append / join the columns to the duplicate records, using proc sql...

by Obsidian | Level 7 in SAS Programming
‎02-19-2013 06:15 AM
‎02-19-2013 06:15 AM
Hi , Try this , it works fine:- ================================ data t; input id port $; cards; 001 b_12 001 p_92 ; data b; input id inst $; cards; 001 mthd ; proc sql; create table aa as select a.id ,a.port,b.inst from t a left join b on a.id=b.id; quit; proc print data=aa; run; ============================================== Output:- ============================================                                                  Obs    id    port    inst                                                   1      1    b_12    mthd                                                   2      1    p_92    mthd ============================================== /Daman ... View more

Re: Merge some columns, please!

by Obsidian | Level 7 in SAS Procedures
‎02-19-2013 06:08 AM
‎02-19-2013 06:08 AM
Hi MigueANA, Please find below some more dynamic code :- ================================== %macro trns(); data want(keep=bank year assets liabilities); set have;   %do i=0 %to 2; /* You need to change the loop her if you want to add more years*/      year=201&i.;      assets=assets201&i.;      liabilities=Liabilities201&i.;output;   %end; run; %mend; %trns; proc print data=want; run; =================================== Output:- ================================                                        Obs    Bank    year    assets    liabilities                                         1     JP      2010       5            6                                         2     JP      2011       3            4                                         3     JP      2012       1            2                                         4     City    2010      13           16                                         5     City    2011      11           14                                         6     City    2012      10           12 =================================================== /Daman ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-04-2018 06:05 PM
Likes given to
Quick links