About shonn2nd

shonn2nd · ‎03-21-2019

PG, Thank you for the answer. So, do you mean by default even if I don't declare ods graphics on, the current sas version will still produce graphics or because ods graphics off don't really turn the plotting off? Thanks.

shonn2nd · ‎03-21-2019

Thank you. When I tried ods graphics off. My second code couldn't produce the graphics. But when I tried ods graphics on and ods graphics close (my first code) and executed my second code, the results still showed the graphics. Is this because ods graphics close doesn't really turn off the plotting function? If I really want to turn plotting off, I have to use ods graphics off instead.

shonn2nd · ‎03-21-2019

Hi all, I am not sure what is the difference between the following codes with one having ODS GRAPHICS ON and the other without. Since I found that the results are the same: First one: ODS GRAPHICS ON; PROC GLM DATA=viagra plots=all ; CLASS dose; MODEL libido = dose /SOLUTION ; MEANS dose; ESTIMATE 'linear' dose -1 0 1; ESTIMATE 'linear' dose -1 0 1; ESTIMATE 'placebo vs other' dose -2 1 1 /; ESTIMATE 'low vs high' dose 0 -1 1 /; MEANS dose /TUKEY REGWQ HOVTEST WELCH ; RUN; QUIT; ods graphics close; Second one: PROC GLM DATA=viagra plots=all; CLASS dose; MODEL libido = dose /SOLUTION ; MEANS dose; ESTIMATE 'linear' dose -1 0 1; ESTIMATE 'linear' dose -1 0 1; ESTIMATE 'placebo vs other' dose -2 1 1 /; ESTIMATE 'low vs high' dose 0 -1 1 /; MEANS dose /TUKEY REGWQ HOVTEST WELCH ; RUN; QUIT; Both codes produce the same plots. Then why do we need ODS GRAPHICS ON in the first code? (attached is my dataset). Thanks.

shonn2nd · ‎03-15-2019

Hi KurtBremser, Could you briefly talk about the logic of that weird code? what does that mean: if casenum is equal to one of the list and equal to zero then that case will be deleted? Thanks.

shonn2nd · ‎03-15-2019

I am a little bit confused about the following code: DATA myshortoutputfile; SET myoutputfile; casenum = _N_; IF casenum IN ( 164, 47, 55, 68, 2, 52, 61, 10, 1, 169) EQ 0 THEN DELETE; RUN; why do we need EQ 0 and THEN DELETE here? Isn't this code equal to: data myshortoutputfile; set myoutputfile; casenum = _N_; if casenum IN (164, 47, 55, 68, 2, 52, 61, 10, 1, 169); run; Thanks.

shonn2nd · ‎03-14-2019

Hi Tom, Thank you for pointing that out! After I change 6. to 1. and the issue is solved: data mydata; set mydata; film1 = put(film, 1.); *the key is here; run; then data mydata; length filmname & 16.; set mydata; if film1= '1' then filmname = 'batman'; else if film1 = '2' then filmname = 'goodwillhunting'; run;

shonn2nd · ‎03-14-2019

Thank you. Do you think the main issue lies in the process of converting numeric variable to character variable? Since when I checked ViewTable, film1 is more like centered instead of right-aligned like other char variables.

shonn2nd · ‎03-14-2019

Hello Astounding, Thank you for the help, but I don't know why It doesn't work. I think I forgot to tell an information here. Below is the original dataset when all the variables are still numeric: data mydata; input film rating; *film is numeric; datalines; 1 2.8 1 3.8 1 4.4 1 2.9 1 2.3 2 2.7 2 3.8 2 3.3 2 4.0 2 4.2 ; run; then I convert "film" to character variable by creating film1 variable: data mydata; set mydata; film1 = put(film, 6.); run; then I started to use the approach you suggested: data mydata; set mydata; length filmname $15; if film1 = "1" then filmname = "batman"; else if film1 = "2" then filmname = "goodwillhunting"; run; But it doesn't work. filmname is empty. Do you know why? Thanks.

shonn2nd · ‎03-14-2019

Hello sbjwhl, Thank you for the help, but I don't know why It doesn't work. I think I forgot to tell an information here. Below is the original dataset when all the variables are still numeric: data mydata; input film rating; *film is numeric; datalines; 1 2.8 1 3.8 1 4.4 1 2.9 1 2.3 2 2.7 2 3.8 2 3.3 2 4.0 2 4.2 ; run; then I convert "film" to character variable by creating film1 variable: data mydata; set mydata; film1 = put(film, 6.); run; then I started to use the approach you suggested: data mydata; length film1 $16.; set mydata; if film1 = "1" then film1 = "batman"; else if film1 = "2" then film1 = "goodwillhunting"; run; But it doesn't work. Film1 is still 1 and 2. Do you know why? Thanks.

shonn2nd · ‎03-13-2019

Not sure why if/then statement can't recode a character variable. My code doesn't work. Can anyone hep me? Thanks. data mydata; input film $ rating; datalines; 1 2.8 1 3.8 1 4.4 1 2.9 1 2.3 2 2.7 2 3.8 2 3.3 2 4.0 2 4.2 ; run; data mydata; set mydata; if film = "1" then filmname = "batman"; else if film = "2" then filmname = "goodwillhunting"; run;

shonn2nd · ‎03-07-2019

Dear all, I have a question. After I import data set from SPSS into SAS, SAS VIEWTABLE will only show the value labels of survey items (if those items have value labels). SPSS allows you to switch back and forth between value and value labels by click a button on the tool bar. I am wondering how I can switch back and forth between value and value labels in my data set in SAS. Only showing value labels gives me difficulty to see the correspondence between value labels and values. Although SAS treats Likert scale items as numeric variables, when I try proc freq, the output will only show value labels without any information about the original values. Thank you for any help.

Online Status	Offline
Date Last Visited	‎07-30-2019 09:37 PM

Re: Not sure what is the function with ODS GRAPHICS ON

Re: Not sure what is the function with ODS GRAPHICS ON

Not sure what is the function with ODS GRAPHICS ON

Re: confused about IF..IN () EQ then DELETE

confused about IF..IN () EQ then DELETE

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

recode character variable with if/then statements

Re: Not sure what is the function with ODS GRAPHICS ON

Re: Not sure what is the function with ODS GRAPHICS ON

Re: Not sure what is the function with ODS GRAPHICS ON

Re: Not sure what is the function with ODS GRAPHICS ON

Re: confused about IF..IN () EQ then DELETE

Re: Not sure what is the function with ODS GRAPHICS ON

Re: Not sure what is the function with ODS GRAPHICS ON

Not sure what is the function with ODS GRAPHICS ON

Re: confused about IF..IN () EQ then DELETE

confused about IF..IN () EQ then DELETE

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

Re: recode character variable with if/then statements

recode character variable with if/then statements

how to switch between value and value labels in SAS dataset after impo...