Thank you so much. Both options work. I tried both and found that the datacontrastcolors gives less control compared to the other one. Best Regards
... View more
Thank you. I have incorporated your code as following: data dattrmap; retain ID "myid"; INPUT value :$20. linethickness linecolor $ linepattern $; datalines; One 2 red soild TWO 2 red dash THREE 2 blue solid FOUR 2 blue dash ; run; ods graphics on; proc sgplot data=numbers dattrmap=dattrmap; where time between 0 and 53; series x=time y=rate / group=group_cat attrid=myid; keylegend / title='Group Categories' position=right; xaxis grid label="Week"; yaxis grid; run; ods graphics off; However, this gives me an error: ERROR 772-580: Syntax error: expecting a constant or a dynamic.
... View more
Hello, I am using the following code: ods graphics on; proc sgplot data=numbers noautolegend; series x=time y=rate / group=group_cat; keylegend / title='Group Categories' position=right; xaxis grid label="Week"; yaxis grid; run; ods graphics off; and the plot I get is below: I need help with changing the patterns, thickness and colors of each line in this plot. The variable group_cat has 4 categories. Is it possible to do it within this code or do I need to create 4 variables representing the 4 categories and add 4 series statements? Thank you.
... View more
Hello, Does any one has a SAS code to calculate Standardized mean differences. I have unmatched data and I need to calculate SMDs for categorical and continuous covariates by exposure status. Thanks.
... View more
Thank you for your reply. It seems it is left aligned. All ids have 3 characters. I so not see any leading zeros but I am not sure if there are blanks after. The variable prints as below:
... View more
I have two datasets with an id variable to merge them with. Data1: variable name=id variable type=character length 255 format $255. informat $255. Data2: variable name=patid variable type= numeric length 8 format 11. informat 11. I tried to use the following code to convert the numeric variable in data 2 to character for merging: data new; set data2; id=put(patid, $255.); run; However, it gives me the following error: ERROR 29-185: Width specified for format is invalid. I tried a format with shorter length and then tried merging. The complete code is below: data new; set data2; id=put(patid, $3.); run; proc sort data=data1; by id; run; proc sort data=new; by id; run; Data final; merge data1(in=in1) new (in=in2); by id; if in1; run; The above code runs but for the variables within the data new, I am getting missing values in the final table. So the merge was actually not successful. Can anyone please help me what to do? Thanks.
... View more
Hi, Is there an easy way of creating 5-year age groups from a numeric age variable? I need 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44 ..............75-79 and 80+ Thanks
... View more
@PGStats Thanks a lot. This is exactly what I was looking for. Could not have accomplished it without your help as I am pretty new to sas with zero experience of proc sql. Thanks again.
... View more
I am sorry about not providing the data earlier. Please see below; This is the data that I have (its only the data from two companies and the original has a lot of companies): data have; infile datalines; input company $ year age $ gender $ attended; cards; A 2012 19-29 Male 12 A 2012 19-29 Female 10 A 2012 30-39 Male 7 A 2012 30-39 Female 5 A 2012 40-49 Male 14 A 2012 40-49 Female 32 A 2012 50+ Male 11 A 2012 50+ Female 8 A 2013 19-29 Male 3 A 2013 30-39 Male 7 A 2013 30-39 Female 2 A 2013 40-49 Female 6 A 2013 50+ Male 3 A 2013 50+ Female 4 B 2012 19-29 Male 2 B 2012 30-39 Male 5 B 2012 30-39 Female 7 B 2012 40-49 Male 5 B 2013 30-39 Male 3 B 2013 30-39 Female 5 B 2013 40-49 Male 8 B 2013 40-49 Female 2 B 2013 50+ Male 6 B 2013 50+ Female 5 ; run; And before doing anything else with it, I want to have all the year age and gender combinations for each company. This would give me a zero value for the combinations missing above. It should look like below: A 2012 19-29 Male 12 A 2012 19-29 Female 10 A 2012 30-39 Male 7 A 2012 30-39 Female 5 A 2012 40-49 Male 14 A 2012 40-49 Female 32 A 2012 50+ Male 11 A 2012 50+ Female 8 A 2013 19-29 Male 3 A 2013 19-29 Female 0 A 2013 30-39 Male 7 A 2013 30-39 Female 2 A 2013 40-49 Male 0 A 2013 40-49 Female 6 A 2013 50+ Male 3 A 2013 50+ Female 4 B 2012 19-29 Male 2 A 2012 19-29 Female 0 B 2012 30-39 Male 5 B 2012 30-39 Female 7 B 2012 40-49 Male 5 B 2012 40-49 Female 0 B 2012 50+ Male 0 B 2012 50+ Female 0 B 2013 19-29 Male 0 B 2013 19-20 Male 0 B 2013 30-39 Male 3 B 2013 30-39 Female 5 B 2013 40-49 Male 8 B 2013 40-49 Female 2 B 2013 50+ Male 6 B 2013 50+ Female 5 I want it to look like above so that I can easily merge it with the following data that has complete combinations of year age and gender data tomerge; infile datalines; input year age $ gender $ employees; cards; 2012 19-29 Male 215 2012 19-29 Female 263 2012 30-39 Male 271 2012 30-39 Female 273 2012 40-49 Male 245 2012 40-49 Female 165 2012 50+ Male 237 2012 50+ Female 186 2013 19-29 Male 192 2013 19-29 Female 154 2013 30-39 Male 176 2013 30-39 Female 231 2013 40-49 Male 188 2013 40-49 Female 176 2013 50+ Male 134 2013 50+ Female 201 ; I hope it is more clear now. Thank you.
... View more
