SAS Support Communities

data want; set have; if Time eq 0 then charvar ='PRE-DOSE'; else charvar = STRIP(PUT(TIME, best32.)); run; ... View more

@rishabhmehra13 wrote: .... when("Hyundai") country=""SouthKorea"; ....     ... View more

data want; set have; by Configuration Month; Difference= dif(Retail_price); if first.Configuration then Difference=.; run; ... View more

You have extra semicolons in your PROC IMPORT statments. OUT, DBMS, REPLACE are all parts of PROC IMPORT, and must end up by only one semicolon. Try this: PROC IMPORT DATAFILE="/home/teleous0/Cody/drugtest.xls" OUT=mtl.drugtest DBMS=XLS; GETNAMES=YES; RUN;   Also GETNAMES valid values only is YES or NO. Which specifies whether the IMPORT procedure generate SAS variable names from the data values in the first record in the input file or not.   ... View more

You do not have variable called SCORE in your data set You mean   MODEL count = TRAIT TEST; ... View more

First, MAXDEC is not System option. System options are instructions that affect your SAS session. You can check them here: SAS System Options   MAXDEC is one of PROC MEANS statment options. You can find detials about it in PROC MEANS documentaions here   And let suppose you went through the doc and you did not understand, Why do not you run this option in simple SAS code and test it by yourself. For example run the following steps and change the value of maxdec and know by yourself: data cake; input LastName $ 1-12 Age 13-14 PresentScore 16-17 TasteScore 19-20 Flavor $ 23-32 Layers 34 ; datalines; Orlando 27 93 80 Vanilla 1 Ramey 32 84 72 Rum 2 Goldston 46 68 75 Vanilla 1 ; proc means data=cake n mean max min range std fw=8 maxdec=2; var PresentScore TasteScore; run; You are welcome to ask anytime, but do more effort to find the answer by yourself or at least in writing your question.   All the best!!! ... View more

No, not in SAS. Only if it come before the set statment in the order in your data step. ... View more

This is called Sum Statment in SAS. And it is equivalent to using the SUM function and the RETAIN statement. As you noticed in your data you have missing values so to do the cumulative summation you need the SUM function and Retain or as shortcut you can use the SUM statment. ... View more