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: 
jonatan_velarde
‎01-01-2025
  • 171 Posts
  • 23 Likes Given
  • 2 Solutions
  • 5 Likes Received

Re: PROC NPAR1WAY mean/median comparison

by Calcite | Level 5 in Statistical Procedures
‎08-31-2016 11:10 AM
‎08-31-2016 11:10 AM
Hello,   I am attempting to run the Dunn Macro package of code right now. I am about half way through but have gotten snagged on a data step. It seems like there are more coming up as well.    data KW_MC_TMP5;set KW_MC_TMP5; 1294 N=_N_; 1295 keep n mean1-mean&groups; WARNING: Apparent symbolic reference GROUPS not resolved. ERROR: Missing numeric suffix on a numbered variable list (mean1-mean). ERROR 22-322: Syntax error, expecting one of the following: a name, ;, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 200-322: The symbol is not recognized and will be ignored.   Is there a way to resolve this? I am relatively new to SAS and trying to learn while using (not highly recommended) but any advice with this will be greatly appreciated.  The upcoming steps have similar synthax.    data KW_MC_TMP6;set KW_MC_TMP6; N=_N_; keep n n1-n&groups; run;   data KW_MC_TMP7;set KW_MC_TMP7; N=_N_; keep n gp1-gp&groups; run;   Thanks!  ... View more

Re: Modeling and generate output PROC MIXED

by Lapis Lazuli | Level 10 in SAS Programming
‎08-18-2016 07:33 PM
‎08-18-2016 07:33 PM
Reeza good night and Thanks for your contribution: i am studing this seminar, and the last example is exactly what i was looking for, well it need some modifications, i began this and unfortunately already stoped here: i can make the loop for single model: %macro mymixed(num);   %do i = 1 %to #     title "dependent variable is v&i";     proc mixed data=have;       model v1 = trait&i;     run;   %end;   %put &i; %mend; %mymixed(3) here, to continue can you help me to code the bi and three  multi trait: where: model v1 = trait1 trait2; model v1 = trait1 trait3; model v1 = trait2 trait3; model v1 = trait1 trait2 trait3; Thanks ... View more

Re: Transform characters column to date

by Lapis Lazuli | Level 10 in SAS Programming
‎03-31-2016 02:26 PM
‎03-31-2016 02:26 PM
thank you Ballardw: I will still using old school importing ahahaha, save as CSV, space separated file and format it in the input statement. thanks a lot my friend ... View more

Re: Arrangement of DATA, adding information

by Diamond | Level 26 in SAS Programming
‎03-10-2016 10:05 AM
‎03-10-2016 10:05 AM
Minor touching up of the code, I always forget ifn() function: data want; set have (rename=(damage=check)); do damage=0 to 4; result=ifn(damage=check,1,0); output; end; run; ... View more

Re: Grouping and Percentage from raw data set

by Lapis Lazuli | Level 10 in SAS Programming
‎01-27-2016 08:56 PM
‎01-27-2016 08:56 PM
proc print noobs;run; Very nice ... View more

Re: Summary by level in a dataset

by PROC Star in SAS Programming
‎01-20-2016 09:51 AM
‎01-20-2016 09:51 AM
SAS has a very simple tool to create this type of report.  This should become part of your repertoire:   proc freq data=have; tables cg_grow; run;     ... View more

Re: Creating a new Variable - Grouping columns by an interaction

by Super User in SAS Programming
‎01-19-2016 09:54 PM
‎01-19-2016 09:54 PM
You didn't post the output you need yet ? Assuming I understand what you mean.     data have; input LAMBING_ORDER ANIMAL SEX$ DAM SIRE ANIMAL_BIRTH_DATE:mmddyy10. month_ABD day_ABD year_ABD ANIMAL_BIRTH_TYPE; format animal_birth_date yymmdd10.; cards; 1 6870 M 1 2 10/13/2009 10 13 2009 1 1 5555 F 3 4 10/14/2009 10 14 2009 1 1 5556 M 5 6 10/14/2009 10 14 2009 2 1 5557 M 5 6 10/14/2009 10 14 2009 2 1 5558 M 7 8 10/15/2009 10 15 2009 2 1 5559 F 9 10 10/15/2009 10 15 2009 2 1 5560 F 9 10 10/15/2009 10 15 2009 2 1 5561 F 11 10 10/15/2009 10 15 2009 2 1 5562 F 11 10 10/15/2009 10 15 2009 2 1 5563 M 12 10 10/16/2009 10 14 2009 1 1 5564 F 12 10 10/16/2009 10 14 2009 1 2 6971 F 12 10 10/27/2010 10 13 2010 3 2 6972 F 12 10 10/27/2010 10 13 2010 3 2 6973 M 12 10 10/27/2010 10 13 2010 3 ; run; data want; length flag $ 40; flag='more than two lambs'; do until(last.DAM); set have; by ANIMAL_BIRTH_TYPE DAM notsorted; if sex = 'M' then has_M=1; if sex = 'F' then has_F=1; end; do until(last.DAM); set have; by ANIMAL_BIRTH_TYPE DAM notsorted; if ANIMAL_BIRTH_TYPE = 1 and sex = 'M' then flag='one male lamb'; if ANIMAL_BIRTH_TYPE = 1 and sex = 'F' then flag='one female lamb'; if ANIMAL_BIRTH_TYPE = 2 and has_M and not has_F then flag='two male lambs'; if ANIMAL_BIRTH_TYPE = 2 and has_F and not has_M then flag='two females lambs'; if ANIMAL_BIRTH_TYPE = 2 and has_M and has_F then flag='one male lamb and one female lamb'; output; end; drop has_:; run; ... View more

Re: Poisson distribution - Is there a Test for normality on it?

by SAS Super FREQ in Statistical Procedures
‎01-07-2016 01:28 PM
‎01-07-2016 01:28 PM
Do you mean "Is there a test to determine whether data are Poisson distributed?"  (You can't check for "normality" unless you think the data are normally distributed.)   If so, the answer is yes. You can fit a Poisson distribution to the data and examine the goodness of fit statistics. ... View more

Re: Date parameters in SAS Visual Analytics

by Calcite | Level 5 in SAS Programming
‎01-04-2016 08:57 AM
‎01-04-2016 08:57 AM
You can try the below code   Proc SQL; Select Sum (Worker) as Order, Worker, Date from Table1 Group by Worker, date Order by Worker, date; Quit;   ... View more

Re: Solving example - Weight gain for repeated measures

by Jade | Level 19 in Statistical Procedures
‎12-30-2015 02:06 PM
1 Like
‎12-30-2015 02:06 PM
1 Like
This makes some very VERY large assumptions about growth over these time periods.  This assumes that growth rate is independent of initial body weight and of mature body size, and where the individual is on the growth trajectory--all of which are inaccurate, especially when it come to estimating efficiency.  While this is an interesting approach to growth and efficiency from a mathematical point of view, it doesn't fit well with the known literature.  See, for example, Mercer (1980) Mathematical models in nutrition. Nutr. Rept Int. 21, 189-198 and Mercer et al. (1979) Prediction of food intakes and growht rates in weanling rats by the four-parameter model equation. Nutr. Rept. Int, 19, 1-8.   This would provide a good starting parameter for nonlinear modeling.   Steve Denham ... View more

Re: Adjusted growing curves - repeated and multi trait model...PROGRAM...

by Jade | Level 19 in Statistical Procedures
‎12-30-2015 01:11 PM
‎12-30-2015 01:11 PM
Again, this may be a simple one.  Make sure that you have initial values for all of the parameters.  In the code here, you have   parms a0 = 1 b0 = -0.5 = -0.25;   This will lead to problems.  I think you want:   parms a0 = 1 b0 = -0.5  b1= -0.25;   However, I'm still not sure if this will run.  You may need to embed macro code to get to the various sections. But that still isn't my major concern.  This piecewise fitting will not yield a continuous growth curve, as you have no equations/variables designed to maintain the continuity.  And without them, it would be a stroke of luck if the model converged.  For an example of continuity based equations/variables, look at the first example in the PROC NLIN documentation (Segmented Model).  There are both continuity and smoothness conditions presented.  You will need to symbolically calculate the necessary additional variables and add them into the code to make this work.   Now if you have defined interventions at the time points, you could fit separate models,     Steve Denham ... View more

Re: Numeratin Dates conected with obsrvations

by Barite | Level 11 in SAS Programming
‎12-29-2015 12:17 PM
‎12-29-2015 12:17 PM
data have; infile cards dsd; informat ANIMAL_BIRTH_DATE mmddyy10.; format ANIMAL_BIRTH_DATE mmddyy10.; input Animal     DAM     ANIMAL_BIRTH_DATE; cards; 6191,5495,7/26/2007 6191.1,5495,7/26/2007 6393,5501,8/15/2007 6394,5501,8/15/2007 6563,5501,8/5/2008 6564,5501,8/5/2008 6844,5501,10/10/2009 6845,5501,10/10/2009 7361.1,5501,1/4/2012 7362,5501,1/4/2012 6463.1,5757,7/24/2008 6843.1,5757,10/10/2009 6843,5757,10/10/2009 ; run; proc sort data=have;by dam animal_birth_date animal; data want; set have; by dam animal_birth_date animal; if first.animal_birth_date then count +1; if first.dam then count = 1; run; ... View more

Re: IMPORT DATA FROM CSV FILE ERROR

by Super User in SAS Programming
‎12-28-2015 08:49 PM
‎12-28-2015 08:49 PM
This is an error that's harder to debug. Check your data file for an unexpected space or something else that might through an error. If you can post your code that may help. If you're using SAS UE restart. ... View more

Re: How to Keep formats (DATE) working with the same dataset

by Super User in SAS Programming
‎12-28-2015 11:17 AM
1 Like
‎12-28-2015 11:17 AM
1 Like
How you "export to Excel" affects content as seen by Excel. Proc Export exchanges data values and formats are characteristics, not values in some cases.   Look at these posts for some ideas: https://communities.sas.com/t5/General-SAS-Programming/date-problem-exporting-to-excel/m-p/229853#M33750 https://communities.sas.com/t5/General-SAS-Programming/Data-Export-to-excel-with-formatting/m-p/173583#M5873 https://communities.sas.com/t5/General-SAS-Programming/Losing-formats-using-an-ODS-to-Excel/m-p/175432#M6978   Proc print to an ODS destination is often easier to get formatted values, especially dates, to Excel. ... View more

Re: Merging man data sets - Doubts

by Super User in SAS Programming
‎12-27-2015 08:20 PM
‎12-27-2015 08:20 PM
proc sort data=sashelp.class out=duplicate nounikeys; by age; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-01-2025 10:23 AM
Likes given to
Likes from
View All
Quick links