About chrissowden

chrissowden · ‎10-27-2018

I am trying to assign random numbers 1-18 as a new variable to my dataset.

chrissowden · ‎10-26-2018

Job_code in the variable job code there are levels " example TM1" is level 1...etc. Its a mixed variable and I want to separate the numeric value from the characters. If it doesn't have any numeric then leave it as is "example SPC" . I am trying to calculate a bonus variable using the numeric value from job_code. Finally, produce a new variable for the year-end bonus, which is defined as: 3% for level 1 employees, plus $1,500 for all with 30 or more years of service 3.75% for level 2, plus $2,500 for all with 30 or more years of service 4.5% for level 3, plus $3,000 for all with 30 or more years of service 3.5% for others, plus $2,000 for all with 30 or more years of service proc datasets lib=work kill;run; filename rawdata '\\seashare\blumj\SAS Programming Data\Raw Data'; data pay; infile rawdata('payroll.txt'); input @1 DOB date9. @10 Hire_date date9. Empid$ 19-22 gender$ 23 job_code$ 24-26 salary:comma.; Today=today(); days = today - dob; age = floor(days / 365); work_days=today-hire_date; Yrs_at_job=floor(work_days/365); if age ge 62 then Retirement='Y'; else if age ge 55 and Yrs_at_job ge 25 then Retirement='Y'; else Retirement='N'; format Today date9. DOB date9. Hire_date date9. ; drop days today work_days ; run;

chrissowden · ‎10-15-2018

proc format; value $dest 'DFW'='Dallas/Forth Worth' 'LAX'='Los Angeles' 'ORD'="O'Haire" 'WAS'= 'DC-ALL Airports' 'CDG'= 'De Gaulle' 'CPH'= 'Copenhaugen' 'FRA'='Frankfurt' 'LHR'='London-Heathrow' 'YYZ'='Toronto' ; run; Proc SQL; create table ex1 AS select distinct s.state as Staff_State,s.empid,sup.state as SUP_Sate,p.jobcode, put(f.destination,$DEST.) AS dest,f.date from mysas.supervisors AS Sup full Join mysas.staffmaster AS s ON s.empid=sup.empid full Join mysas.payrollmaster as P ON s.empid=p.empid full join mysas.flightschedule as f ON s.empid=f.empid where destination in('CPH') and date ='04MAR2004' ; quit; when I try to select destination and the date I am getting an error in the log: date is a numeric value with date9. format. _____ ERROR: Expression using equals (=) has components that are of different data types.

chrissowden · ‎10-11-2018

That is the entire instructions that I have.

chrissowden · ‎10-11-2018

Where the endpoint is December 2006—e.g. 3 month return refers to return over Oct, Nov & Dec of 2006; 3 year return refers to Jan 2004 through December 2006 I am having a hard time getting the monthly and yearly returns here is my code: proc sort data=mysas.funds out=funds; by indicecode ; where year(dt) <= 2006; run; data ex1; set funds end=last; by indicecode ; if last.indicecode then do; count=_n_; col1=(fund_tot + return)*100; output; end; /* keep indicecode mean return count; */ run;

chrissowden · ‎09-04-2018

I am having a hard time coming up with the graph that I posted below. The code that I have so far is posted below. Can anyone help me out? ods listing close; proc means data=sashelp.cars min max mean median; class type origin; var mpg_city; ods output summary=cars; run; proc sgplot data=cars; highlow x=type low=mpg_city_min high=mpg_city_max / group=type type=bar transparency=.3 dataskin=pressed fillattrs=(color=cx66FF66) barwidth=.7; footnote j=left 'Across Vehicle Types'; run;

chrissowden · ‎08-28-2018

Hey Everyone, I am trying to add a format that would show all obs that have smoked at some time. The 1,2,3,9 should represent that value as a smoker as some point in the gestation. if I remove the 1,2,3,9 then I get everything else and it works great. But I want to add who has smoked at some point to my proc means. proc format; value smk 0 ='Non-Smoker' 1= 'Smoker Currently' 2='Smoker until current pregnancy' 3='Stopped before current pregnancy' 9='Unknown' 1,2,3 ='Smoker at some point' **trying to add this format** ; run; proc means data=mysas.birthweight n mean median std nonobs; format smoke smk.; class smoke; var birth_wt gestation; label birth_wt ='Birth Weight (.oz)' gestation='Gestation Period (days)'; run;

chrissowden · ‎08-06-2018

Thanks so much. I had to make some changes to your code, but I got it to work. Thanks a bunch!

chrissowden · ‎08-02-2018

It's a big practice dataset from work. it was just an idea that I was thinking about.

chrissowden · ‎08-02-2018

data tbl; retain ord subord label _1 _2 _3 _9; merge shell_final combo; by subord; if subord not in (1,4,5)then do; if not missing(_1) then col1=put(_1, 3.)||' ('||put((_1/&tot1)*100,3.)||'%)'; else if missing(_1) then col1=put(0,3.); if not missing(_2) then col2=put(_2, 3.)||' ('||put((_2/&tot2)*100,3.)||'%)'; else if missing(_2) then col2=put(0,3.); if not missing(_3) then col3=put(_3, 3.)||' ('||put((_3/&tot3)*100,3.)||'%)'; else if missing(_3) then col3=put(0,3.); if not missing(_9) then col9=put(_9, 3.)||' ('||put((_9/&tot9)*100,3.)||'%)'; else if missing(_9) then col9=put(0,3.); 　 end; drop _1 _2 _3 _9; run; data tbl2; retain ord subord label _1 _2 _3 _9; merge shell_final combo; by subord; 　 array vars{4} $ _1 _2 _3 _9; do i=1 to 4; if vars{i} ^=' ' and label='No' then vars{i}=put(vars{i}, 3.)||' ('||put((vars{i}/&tot9)*100,3.)||'%)'; end; run; I am trying to see if there is a way that I can replicate the first code into an array. tbl works for what I am doing but was wondering if I could use an array to accomplish the same thing. In the second code cluster is my attempt to trying an array, but it doesn't work.

chrissowden · ‎08-02-2018

That's awesome!! works great!

chrissowden · ‎08-02-2018

data test; set one; new_var = compress(val,','); run; this is what I got to work, it removes the commas but I was trying to use a do loop to get it to populate into a 4 different obs.

chrissowden · ‎08-02-2018

data one; length id val $200; input id val ; datalines; 1 3,8,9,8 2 3,8,9,8 ; run; /*output should be 1 3 1 8 1 9 1 8 2 3 2 8 2 9 2 8 */ I tried using the scan function but it doesn't work. I am trying to separate the values after the commas to a new variable as listed above

chrissowden · ‎08-01-2018

ods html path="C:/Users/csowden/Desktop/SAS programs" (url=none) file="output.html"; that is what I have. I am on SAS grid. I wouldn't think that has anything to do with it. ods printer file='C:/AnimGif/ByGroup/Anim.gif'; /* images saved into animated GIF */ ERROR: Physical file does not exist, /apps/sas/SAS94/Config_GCS/Lev1/SASApp94/Computer/Users/csowden/Desktop/SAS The SAS System programs/output.html. ERROR: No body file. HTML output will not be created. ERROR: The HTML destination is not active; no select/exclude lists are available. ods html select all; /* restore screen output */ ERROR: The HTML destination is not active; no select/exclude lists are available. ERROR: Physical file does not exist, /apps/sas/SAS94/Config_GCS/Lev1/SASApp94/C:/AnimGif/ByGroup/Anim.gif.

chrissowden · ‎08-01-2018

data stocks; set sashelp.stocks; Month = month(date); /* 1, 2, 3, ..., 12 */ Year = year(date); /* 1986, 1987, ..., 2005 */ run; proc sort data=stocks; by date; run; ods html; ods graphics / imagefmt=GIF width=4in height=3in; /* each image is 4in x 3in GIF */ options papersize=('4 in', '3 in') /* set size for images */ nodate nonumber /* do not show date, time, or frame number */ animduration=0.5 animloop=yes noanimoverlay /* animation details */ printerpath=gif animation=start; /* start recording images to GIF */ ods printer file='C:\AnimGif\ByGroup\Anim.gif'; /* images saved into animated GIF */ ods html select none; /* suppress screen output */ proc sgplot data=stocks; title "Stock Performance"; by year; /* create 20 images, one for each year */ series x=month y=close / group=stock; /* each image is a time series */ xaxis integer values=(1 to 12); yaxis min=10 max=210 grid; /* set common vertical scale for all graphs */ run; ods html select all; /* restore screen output */ options printerpath=gif animation=stop; /* stop recording images */ ods printer close; I am getting the following errors: ERROR: Insufficient authorization to access /apps/sas/SAS94/Config_GCS/Lev1/SASApp94/sashtml.htm. ERROR: No body file. HTML output will not be created. ERROR: The HTML destination is not active; no select/exclude lists are available. ERROR: Insufficient authorization to access /apps/sas/SAS94/Config_GCS/Lev1/SASApp94/C:\AnimGif\ByGroup\Anim.gif.

Online Status	Offline
Date Last Visited	‎09-12-2022 12:49 PM

ERROR 79-322: Expecting a (. ERROR 76-322: Syntax error, statement wil...

Re: Proc Template bottom line before printing footnotes

Re: Proc Template bottom line before printing footnotes

Proc Template bottom line before printing footnotes

empty macro variable

Split columns into multiple proc reports

Negative Difference in Risk Tables

SGPLOT GIF output

Adding same variables that have the same page number

Re: marco variables

SGPLOT HighLow

Assigning random numbers in a particular range 1-18

Variable with character and numeric

Proc SQL

Re: Calculating returns using funds dataset

Calculating returns using funds dataset

SGPLOT HighLow

NEED HELP !!! Proc format and proc means

Re: array idea help

Re: array idea help

array idea help

Re: help with function

Re: help with function

help with function

Re: Output GIF

Output GIF