First: Your problem is in your logic. As you know -1 > - 2 so is -.124999999999999 > -.125 that is mean that when you say low - (-0.1) = 'A' -0.2 - (0) = 'B' you will get overlap, so you can not say low - -124999999999999 = 'A' -0.125 - (-0.624999999) = 'B' Second: you do not need () in format Finally: try this, it should work proc format; value V1format low - -0.875 = 'A' -0.874999999 - -0.625 = 'B' -0.624999999 - -0.375 = 'C' -0.374999999 - -0.125 = 'D' -0.124999999 - 0 = 'E' 0-0.1249999999 = 'F' 0.125 - 0.3749999999 = 'G' 0.375 - 0.6249999999 = 'H' 0.625 - 0.8749999999 = 'I' 0.875 - high = 'J'; run;
... View more
What if the data sets have different names not a series like class1 , class2 ...... and i do not know there names in advance_ the data sets i mean_, all what i know is the lib name
... View more
How to delete every observation in each dataset in a specific lib. PROC DELETE delete all the data set, what i need is to delete all the data set observations not the data sets it self.
... View more
This note let you know about the missing values that were created. for example check this 4. Missing values in assignment statements . It give you an example with details about this note.
... View more
What do you mean: Do you want each observation in your data set to printed in separate file, where they are printed in three lines and each variables printed beside the column name as in the example you provided above.
... View more
Did you made sure that the "data" folder exist in "myfoldrs" folder physically? Libname Statement create a short reference to your folder it will not create one for you.
... View more
What do you mean by "how many answers are correct?" The most of the questions have only one correct answers and some questions _which are minority_ have more than one correct answers and you can notice that from the question and the exam system gives you the ability to choose more than one answers.
... View more
How this is not working for you data have; input y; cards; 80 120 1390 2235042 ; run; data want; set have; yy=strip(put(y,8.1)); z= length(yy); v=8-z; x=catt(yy,repeat('0',v-1)); run;
... View more
If you want to deal with char, you can also use the repeat function for example: data want ; y='33.3'; z=length(y); v=8-z; x=catt(y,repeat('0',v-1)); run;
... View more
data want (drop=newV ); set have; by id1 id2; if (first.id2 ) then do; retain newV ' '; if STATUS = ' ' then Do ; STATUS = 'V'; newV=STATUS; End; Else if STATUS in ('C','V') then newV=STATUS; End; Else do; If STATUS in ('C','V') then newV=STATUS; Else if STATUS=' ' then STATUS=newV; end; run;
... View more
