I have a large data set like this : NAME  MONEY  NB  NUMBER    CLASS John      300        1         4           ab_4_ab_1 Max       250        2         5           be_2_be_1 Matt      1520       2          2          da_3_da_2 I use this code : data want; set have; if nb = 2 then do; money = money / number; nb = nb / 2; output; end; output; drop number; run; to get this data :   NAME    MONEY   NB     CLASS John       300         1       ab_4_ab_1 Max         50          1       be_2_be_1 Max         50          1       be_2_be_1 Matt        760        1       da_3_da_2 Matt        760        1       da_3_da_2   I want to assign to the first duplicate observation the first four character of CLASS and the last four character of CLASS for the second duplicate observation. I mean how get  this : NAME    MONEY   NB   CLASS John       300         1      ab_4_ab_1 Max         50          1       be_2 Max         50          1       be_1 Matt        760        1       da_3 Matt        760        1       da_2     ... View more

I have a large data set like this : NAME   MONEY   NB  NUMBER John        300       1         4 Max         250       2         5 Alex         657       1         3 Matt        1520      2         2   For NB = 2, I want to divide NB by 2 , divide MONEY by NUMBER and also keeping observations for NB = 1. I mean how get this  : NAME   MONEY   NB John        300       1 Max         50         1 Max         50         1 Alex         657       1 Matt        760       1 Matt        760       1 ... View more

To generate random date in sas, I use this code data random_date; mindate='01jan2015'd; maxdate='30dec2017'd; range = maxdate-mindate+1; format mindate maxdate randate date9.; do i = 1 to 100000; RanDate = mindate + int(ranuni(12345)*range); output; end; run; But how can I generate uniques randoms dates ? ... View more

I split my data into training/validation/test. I use PROC ADAPTIVEREG and i want to compute Mean Square Error on test data This is my code : proc adaptivereg data=test_data; class job; model money = age job / dist=gamma link=log ; run; how can I compute Mean Square Error on this data?   ... View more

Hello, I apply the Generalized Additive Models to this model : money = year + job my response variable is continuous (money) and the other variable is not continuous (job). This is what I did with SAS :   proc gam data=mydata; model money = spline(year) spline(job); output out=estimates p; run; But I got this error : ERROR: Variable JOB in list does not match type prescribed for this list. How can I fix it ? ... View more

I have two data A and B with more than 500 observations like this : data A : ID      NAME     DATE 320   ANNA     12NOV2016 177   JOSH      14FEB2017 177   JOSH     16JAN2015 185   MIKE      03APR2017 185   MIKE       12FEB2017 190   ANGIE    12JAN2017   data B : ID       NAME 320    ANNA 177    JOSH 160    MAX   I want to find observations which are in A but are not in B and by keeping the most recent date. I mean how can I get something like this ? : ID      NAME     DATE 185   MIKE     03APR2017 190   ANGIE    12JAN2017     ... View more

I have a data set like this : ID      NAME      BEGIN               END 345   CARL      16MAR2017     31MAR2017 345   CARL      03APR2017      30APR2017 120   ROSA      01JAN2017    14FEB2017 120   ROSA      02DEC2016      31DEC2016   How can I delete occurence but taking the most recent date ? I mean get some thing like this : ID      NAME      BEGIN               END 345   CARL      03APR2017      30APR2017 120   ROSA      01JAN2017    14FEB2017   ... View more

I have a data set like this :   NAME               SURNAME RAYNALD         ALEXANDRE RAYNALD        ALEXANDRE RAYNALD        ALEXANDRE ALICE              ANDRE ALICE              ANDRE GERALDINE    ANDRE   How can I get some thing like this ?  : NAME               SURNAME RAYNALD         ALEXANDRE ALICE              ANDRE GERALDINE    ANDRE ... View more

This is mydata : data mydata; input age note; cards; 15 17.5 35 18 22 16.25 21 14.5 17 18.5 15 16 22 14.5 35 12.5 21 13.25 ; run; and i want to compute note_Q1 and note_Q3 for each age. So I did : %macro compute(age); %do i=1 %to &age; proc means data=mydata(where=(age=&i.)) q1 q3; var note; class age; ods output summary=data_&i.; run; %end; %mend; %compute(35); but i get this warning message : NOTE: There were 0 observations read from the data set WORK.MYDATA. WHERE age=1; WARNING: Output 'summary' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. How can I get only on table with proc means result by age ?   ... View more