In your example 2.333......333 is the unformatted (underlying) value in Excel, which is what SAS reads and imports.  You can apply a SAS format such as 16.1 or comma20.1 after the import to achieve what you want. The standard import procedure in SAS does not carry across the format applied in Excel, although in the case of dates SAS uses the Excel format to identify the value as a date, import it and adjust the base date and apply a SAS date format which might or might not look similar to the Excel format. You might be able to achieve what you want by exporting the data as a text file (CSV or tab delimited) and importing that into SAS. Richard ... View more

Having worked with two packages (Model Manager, and Market Optimization), my view is that there is a ton of work created by these products.  It's just different work than existed before.  You need to prepare the data in a form that the software expects, applying business rules along the way.  That in itself is a matter of person-months if not person-years.  And business rules change over that long a time period, creating the need for updates to the development work.  Then you need to properly utilize the outputs ... add months of development work.  Add to that the fact that the developer then has a niche that would be difficult to fill ... from where I sit the developers have nothing to worry about. ... View more

where month(reporting_date) = 12 Richard ... View more

How are you going to do the merge?  You need some common variable in each table to join on to avoid a cartesian product in SQL.  If there is none a datastep merge without a by variable might work for you though the result may not be quite what you expect. Step 1: set up a macro to do the merge - here assuming no common variable %macro merge_ctry (ctry, crncy) ;      data &ctry._combined ;           merge ctry_&ctry                     crncy_&crncy                     ;      run ; %mend ; Step 2: use a datastep to execute the macro for each ctry - crncy pair data _Null_ ;      set countries ;      if exist(ctry) and exist(crncy) ;      exec_macro = cats('%merge_ctry(', ctry, ', ', crncy, ');') ; /* single quotes essential */      call execute (exec_macro) ; run ; NB the macro invocations will be streamed to execute after the data step terminates. Obviously this is untested but it is a viable approach. Richard ... View more

Linus' reply is a bit terse.  The intnx function will provide an answer, provided you supply the right question.  Do you want 9 calendar months exactly (ie to the same day - if possible - 9 months previously), or do you just need the month and the first day will do; or maybe push all dates back by the same amount (0.75 year = 274 days)? Taking these options in reverse order: Prev_date = date - 274 ; Prev_date = intnx("MONTH", date, -9) ; Prev_date = intnx("MONTH", date, -9, "SAME") ; INTNX is documented here SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition BTW, if your dates are datetime intervals you need to use "DTMONTH" instead of "MONTH" ; and for the 274 day calculations use Prev_date = intnx("DTDAY", date, -274, "SAME") ; Richard ... View more

If you don't have Proc REG you either do not have the SAS STAT product installed or it is damaged.  You need SAS STAT to do multivariate analyses.  In Base SAS you are limited to univariate analyses and correlations. Richard ... View more

Issuing X "dir"; in my local SAS session (not EG) resulted in an open cmd window with the contents of the directory listing and a prompt (issued without noxwait). Open your Server list, right mouse click on the active server, tab "Software", "View Initialization Log". This may give you a clue where the server actually resides. ... View more

or if  Round(temp,0.1) = as long as you are comparing nearest tenth. ... View more

Data want ;      Set have ;      outcome = max (anxiety, stress, multiple, etc1, etc2, etc3, etc4) ; Run ; Richard ... View more

If you want to create VarFinally based on the values in VAR1,VAR3 and VAR4 and you have no control over how the lengths of those variables were defined (say you imported them from Excel) then a little defensive coding will make it possible. data WANT ;   set HAVE;   length VarFinally $17. ;   VarFinally = substr(var1||repeat(' ',15)),1,15)||substr(var3,1)||substr(var4,1); run; ... View more

data want(drop= i x rename=(y=x)); set have; i=1; do while (scan(x,i,'or ') ne ' '); id=_n_; y=scan(x,i,'or '); output; i=i+1; end; run; ... View more

I do not think there is a substitute for the experience your interviewer is looking for.  This leads to a chicken and egg situation - you can't get a job without the experience and you can't get the experience without the job.  Eventually the supply of available experienced job seekers will run out and recruiters will have to look for people with the potential to work in these areas, so being able to demonstrate the potential is the key.  You will need to show if possible you have good experience in other industries, that you can demonstrate versatility, and you can demonstrate you are a quick learner. You do not say what type of job you were being interviewed for.  If you have marketing campaign experience and the job requires that ability that should be transferrable.  If you have done propensity modelling and the job requires creating application scorecards, that should be a good fit.  If you have commercial collections experience and the job requires monitoring collections performance you probably know enough to start.  Employers feel safer picking people who have worked in their industry, even if the task is quite generic.  Keep trying - eventually someone will need to fill a vacancy so urgently that previous experience becomes less of an issue. Richard ... View more