I want to merge multiple datasets with multiple variables but the length of the character variables are different in each dataset. I created an example that works but I want to know how I can improve it to make it easier to apply when the number of datasets is 5-10 with 20 variables to check for length. Thanks for your thoughts data d1; length var1 $10. var2 $10.; input var1 var2; cards; apple carrots orange cabbage ; data d2; length var1 $30. var2 $30.; input var1 var2; datalines; apple-pie-recipe carrot-soup orange-juice-for-breakfast cabbage-soup-for-supper ; data d1_i (drop= var1_old var2_old); set d1(rename= (var1=var1_old var2=var2_old)); length var1 $30.; var1=var1_old; length var2 $30.; var2=var2_old; run; data want; set d1_i d2; run;   ... View more

I have some variables with negative values that are assigned for the missing observations. When I assign the value labels in proc format; the first time SAS reaches a negative value faces an error. My list of variables is long with several similar negative observations (-9). Please see my code and error below. Thank you for your suggestions.    value income 1 = "less than 20000" 2 = "20000-40000" 3 = "40000-60000" 4 = "60000-80000" 5 = ">80000" -9 = "Don’’t know"; format income income.; 1556 + 9 = "Don’’t know" - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

I have a data set with the list of food items that kids ate during the day. For each category, for example, vegetables, there are words that are misspelled. I created a frequency for the variable vegetable and identified the misspelled words that I need to correct. I want to keep the correct reports as is. The way I introduce ELSE, my code only applies the last IF for lettuce and replaces cabbage with the original cabage. Thanks for your help.  data have; length vagatables $ 20; length fruits $ 20; input vagetables $ fruits $ ; datalines; cabage orange cabbage apple carrot strwberry lettuce apple Letuce cherry ; run; proc print data=have; run; data want; set have; if vagetables = "cabage" then vagetables_new="cabbage"; if vagetables = "Letuce" then vagetables_new="lettuce"; else vagetables_new=vagetables; run; proc print data=want; run; The dataset have Obs vagetables fruits 1 cabage orange 2 cabbage apple 3 carrot strwberry 4 lettuce apple 5 Letuce cherry The dataset want Obs vagetables fruits vagetables_new 1 cabage orange cabage 2 cabbage apple cabbage 3 carrot strawberry carrot 4 lettuce apple lettuce 5 Letuce cherry lettuce ... View more

I work with SAS and the other members of my team work with SPSS and I usually need to translate codes between SPSS and SAS. I wonder if someone may help me to translate this. I want to create new_var from var I appreciate any hint that may help me to translate this. Thanks   STRING new_var (A200). EXECUTE. COMPUTE new_var=CHAR.SUBSTR(var,1,CHAR.INDEX(var,"?")-1). IF NOT(CHAR.INDEX(var,"?")>0) new_var = var. EXECUTE. ... View more