I have character variables values that represent a date.  An example of a date is the following:  July 2015 is displayed as 201507. What I want to do is create a scatter plot and alter the Xaxis that shows the dates, but without altering the date, I am unable to alter the Xaxis range.  I want to create a scatter plot with a regression line using the character date.   Below is an example of a dataset I am using.    The dataset is the average MPG in a given month for my car that I want to plot over time.  I try to plot using the character date, but I am not able to do the regression line since it is a character.    Do I have to reformat the character date? Convert it to numeric?  If I convert it to numeric, my xaxis gets messed up.     Any help would be appreciated. data mpgdate; length chardate $10; infile datalines; input chardate $ avempg; date = input(chardate,yymmn.); return; datalines; 201401 36 201402 24 201403 28 201404 30 201405 32 201406 33 201407 31 201408 35 201409 29 201410 28 201411 36 201412 30 201501 29 201502 27 201503 30 201504 28 201505 32 201506 31 201507 33 201508 26 201509 32 201510 34 201511 35 201512 34 ; run;   axis1 order=(0 to 5 by .5) minor=none; axis2 order=(201404 to 201604 by 1); 　 　 ods listing close; ods html file='Scatterplot.html' path='.' style=statistical; ods graphics / reset width=600px height=400px imagename='ScatterPlot' imagefmt=gif; title "Average MPG per Month"; 　 proc sgscatter data=mpgdate;   plot (avempg) * (chardate) / reg=(nogroup clm degree=2) grid ; run; ods html close; ods listing;     ... View more

Hi, I want to assign a value in the sequence {X1, Y1, X2, Y2}, starting with a random value from that sequence then cycle through the sequence over and over for the number of observations. For example: if the random value from the sequence {X1, Y1, X2, Y2} is Y1, then the next value should be X2, then Y2, then X1, then Y1, then X2 and so on.  Not sure how to do the alphanumeric assignment. Thanks, Josh ... View more

Let's say I have 100 Temporary Employees, variable label TE, and they are assigned a number 1 -100. I want to assign the Temp Employ a Rotation number, variable label RO, of 1 through 3 repeatedly and have it start with a random rotation number. So if the random number generated for the first TE is RO = 2, I want the next RO=3, then start the cycle over of assigning RO of 1-3 for the rest of the TEs. I know this is basic, but I am struggling how to write this. here is my example: Data haveemp; INPUT TE; Datalines; 1 2 3 4 5 6 7 8 9 10 11 12 ; data wantrot; length RO 8; set haveemp; if TE = 1 then RO = ceil(4*ranuni(0)); Do i = 2 to 12; ... end; run; I am not sure what to do after the do statement. I have a mod(n-1,3)+1 type of thinking for the other ROs but I am not sure how to ensure a proper cycle with the random number generated for the first TE. Any help would be appreciated. ... View more

I am using proc tabulate to cross variables then outputting to an excel sheet using ods tagset. So I am using a dataset that has a zipcode with some of those zipcodes having a leading zero. When I output to excel using ods tagset, it chops off the zero. I also want to change the color of the cell based on the value of the cell. I want the cell to have a color if there is no missing value or greater than zero. Here is a sample set of my data: data test; input Areacode Deliverygrp $ weeknumdeliv; datalines; 01033 H1 02 01033 H1 02 01033 H1 05 01033 H2 01 01033 H2 01 01033 H2 30 02213 H1 44 02213 H1 35 02213 H1 35 02213 H1 35 10033 H1 04 10033 H1 04 10033 H1 06 10033 H2 10 10033 H2 29 21226 H2 15 21226 H2 12 21226 H2 03 ; run; ODS TAGSET.EXCELXP file = 'C:\myfilelocation\testtry3.xls'; proc tabulate data = test; by deliverygrp; class areacode weeknumdeliv classlev areacode/style={tagattr ="00000"}; table areacode, weeknumdeliv*N = " "; run; ODS TAGSETS.EXCLXP CLOSE; Should I use a proc format procedure for the cell color or is this another tagattr type of redefining the output? Or is this something entirely different? Any suggestions would be great. Thanks all! I have attached the excel file. ... View more

I have a dataset that I want to perform checks on: 1st Check: determine if all wanted variables exist in the dataset 2nd Check: determine if there are any extra/unwanted variables in the dataset other than the wanted variables Let's say I am using this data below: Data test1; input id score1 score2 score3 score4 score5 score6; cards; 24 100 97 99 100 85 85 28 98 87 98 100 44 90 run; I want to check if id, score1 score2 score3 and score4 exist in the dataset (let's assume I am pulling this dataset from a database and checking to see if someone created the correct dataset with those wanted variables only). My desire is to perform those two checks above and either output a dataset called check_var_problem1, if not all the wanted variables exist, and check_var_problem2, if there exists more than the wanted variables in the dataset. If a dataset cannot be created with the problems, then a note would be acceptable in the LOG that says something like (Check1): "score2 is not in this dataset" or (Check2): "This dataset contains score5, score6 in the dataset". I tried using a loop to check for the missing variables, as well as creating macro variables.  See my code below: %let var1 = id; %let var2 = score1; %let var3 = score2; %let var4 = score3; %let var5 = score4; data check_var_problem1; dsid = open('test1'); do i = 1 to 5; check=varnum(dsid, 'var&i'); if check = 0 then put 'var&1 does not exist'; end; run; Any help is appreciated. Thanks, ... View more