@Nipun22 wrote: Hi Tom, actually i wanted to know if we place a "then" keyword at the end of the "if style" statement then the output dataset would have 7 observations. can you tell me why? Adding THEN will change these two statements like this: if <condition>; <statement>; into two statements like this: if <condition> then <statement1>; <statement2>; So when the IF/THEN statement basically does nothing since when it the condition is FALSE it moves to the next statement and when it is TRUE it executes an empty statement before moving to the next statement.  The second statement (in your case the INPUT statement) executes in either case.   In the original program when the condition in the subsetting IF statement is FALSE it will immediately stop the current data step iteration. Which will mean that only the cases where the condition is true will make it to the end of the data step code where SAS will execute the implied OUTPUT it adds to any data step that does not have an explicit OUTPUT statement.   Note that if you also remove the semicolon you end up with just one statement in this form: if <condition> then <statement>; Then in your case it will cause the other 6 variables on the line to only be populated for 3 of the 7 lines of input text.  The other observations will have missing values for those variables.   ... View more

Detecting:   proc format; value $missfmt ' ' = 'missing' other='present'; run; proc freq data=have; tables varname / missing; format varname $missfmt.; run; Fixing is up to you. There is no standard method. It depends on what you intend to do with the data. The most common option is to do nothing. Why would a missing qualitative value need to be replaced? At any rate, this is a valid DATA step statement:   if varname = ' ' then varname = 'N/A'; ... View more

It does not run for two variables. It runs separate analyses for each level of the variable sex. Since sex has two levels: M and F, you see two separate analyses in your output.    Similarly, the species variable in sashelp.iris has three levels, so the below code returns tree levels of analysis   proc univariate data = sashelp.iris; class species; var sepallength; run; ... View more

@sanyam13 wrote: My course content was Base SAS, advance SAS with Macros, Proc SQL . Anova , T test , LogicalRegression etc .  Also, avoid spelling mistakes in your resume, especially in important keywords such as "logistic regression" etc. ... View more

data test;  lenght y $200; x  =  'charles dickens' ; y =scan (x ,2 ) ; run; ... View more

Thank you sir , it helped a lot  ... View more

@sanyam13 wrote: one x   y   z 1  A  27 1  A  33 1  B  45 2  A  52 2  B  69 3  B  70 4  A  82 4  C  91   data two ; set one; by x y; if first.y; run;   proc print data = two noobs; run;   can somebody plz explain exactly what we are doing in this program and why i m getting this output    x  y  z 1 A  27 1 B  45 2 A  52 2 B  69 3 B  70 4 A  82 4 C  91 The "If first.y;" statement says to keep the record only for the first of each group of y values for each X group. Note that the 1 A 33 is not in the output as it is the second value of A for variable Y where X is 1. ... View more

Hi:   In addition to Tom's suggestion, if you took a slightly different approach, using simple list input (since the values are delimited by spaces) you don't need a conditional INPUT statement.   Just another possible approach.   Cynthia ... View more

@SuzanneDorinski already told you what happens. I just want to add some food for thought: a simpler form of the condition would be if Emp_N ne Emp_D; ... View more

@novinosrin wrote:   2. total number of loops processed = stopvalue1*stopvalue2*stopvalueN= 5*12=60  in your case  @sanyam13: It goes without saying that "stop value" in the above calculation does not always equal the value following the TO keyword (such as 10 in do i=1 to 10), but can differ from that value in many ways depending on start value (do i=0 to 10), increment (do i=1 to 10 by 2), WHILE/UNTIL conditions, the code performed in the loop (e.g. LEAVE statement), etc. ... View more

@sanyam13 wrote:   can you plz explain how come the length of variable sec is 25 ?    data test; first = 'ipswich, england'; sec = substr(first,1,7)!!','!!'England'; run; SAS makes guesses about the required length for a new variable, depending on the length of variables and literals used. To prevent such guesses from happening (as they usually don't end up with the desired result), it is best practice to use the length statement. ... View more

You get what you pay for. If you have to verify your course materials, its not really a good use of your time. ... View more