Two step proc sort.
proc sort data=have;
by id descending date;
run;
proc sort data=have nodupkey out=want dupout=duplicates;
by id;
run;
OR the second step can be the one below.
data first;
set have;
by id;
if first.id then output;
run;
... View more
Its the date not starting until row 52 that's causing the problems then.
One workaround is to save as csv and import using proc import. Get the code from the log and modify the date1 field.
OR
Sort your excel sheet such that the missings are at the end
OR
change your guessing rows settings in registry
and the easiest by far...
read it in and then convert :).
HTH,
Reeza
... View more
A work around is always good.
You don't need to post actual data, but what the data looks like in Excel
ie
date1 date2
March 31, 2001 3-31-2001
or
date1 date2
3/31/01 20110331
There are many ways that dates could be formatted and without 'seeing' it almost impossible to offer any better suggestions.
... View more
I think rather than %, calculate freq/counts and then you can use a proc freq to get the difference between cohorts for the different ratios and calculate odds ratio between the two.
Hopefully someone can verify that's correct...
... View more
Change mixed to yes and make sure your excel file has the date format applied as a format.
Then apply the date format in SAS.
Ie.
data want;
set have;
format date1 date2 date9.;
run;
If you want to convert the date to a date in SAS instead look up the anydttm format(might be missing a few letters there).
HTH,
Reeza
Message was edited by: Reeza
... View more
You can do it using the font.properties command, see paper 022-31 by Bessler on DDE.
[pre]
data _null_;
File DDEcmds;
put '[select("R5C3:R7C5")]';
put '[font.properties("Verdana","Bold Italic",16,,,,,,,3)]';
run;
[/pre]
... View more
I wonder if a where statement in a data step or Proc SQL would be more efficient if you only have 10 observations you're looking for. If you're not sure that the ids would be in table2 then a left join is the safest thing to do.
I have no idea though and did a quick google search and didn't come up with anything.
... View more
It is a friday afternoon...for the sql statement also need a format,
format=date9.
proc sql;
select max(date) as max_date format =date9., min(date) as min_date format =date9.
from sashelp.stocks;
quit;
... View more
I don't know how to do it with proc means directly but what about outputting it to a dataset and printing it or using proc sql?
[pre]
proc means data=temp.ms_trans noprint;
var efectv_dt;
output out=sample min=min_date max=max_date;
run;
proc print;
run;
OR
proc sql;
select max(efectv_dt) as max_date, min(efectv_dt) as min_date
from temp.ms_trans;
quit;
[/pre]
... View more
You've got some syntax errors in your last two lines:
if populationmunicipality LT 10000, then group='rural';
else group='urban'
An extra comma and no semicolon after the last line.
You should look up proc means though, using by groups specifically. You don't necessarily have to recode your text categories into binary variables in SAS.
... View more
Thanks Alll, got it working!
Add on to this question, is there an easy way (ie with the options in HBAR) to get the percentages added in to the chart or do I need to use an Annotate dataset?
... View more
Hi All,
I'm analyzing some survey data and want to present some data in a horizontal bar chart. The data is in terms of agreement, neutral or disagreement. I can get the data in the chart but not in the order I'd like.
I would like to have the Questions order by the Agree %, so the topic that most people agree with is at the top of the charts. Second I would like the 'bars' within the questions arranged from Agree to Neutral to Disagree. I could drop the Disagree without changing the appearance, but thought I'd leave it in for now.
I'm using a sample for Rob Allisons page.
Here's what I have so far.
Thanks!
[pre]
data have;
input question $ agreement $ percent;
cards;
Q1 Agree 0.25
Q1 Neutral 0.30
Q1 Disagree 0.45
Q2 Agree 0.55
Q2 Neutral 0.10
Q2 Disagree 0.35
Q3 Agree 0.45
Q3 Neutral 0.25
Q3 Disagree 0.3
;
run;
proc sort data=have; by agreement descending percent; run;
goptions gunit=pct htitle=4 ftitle="albany amt/bold" htext=2 ftext="albany amt";
axis1 label=none;
axis2 label=none order=(0 to 1 by .1) minor=(number=1) offset=(0,0) value=(h=3pct);
legend1 label=none position=(bottom)
shape=bar(3,3) across=3;
/* pattern v=solid color=red; */
pattern1 v=solid color=cxbd0026; /* kind of a seafoam green */
pattern2 v=solid color=cxc7e9b4; /* this is the hex rgb color for mild blue */
pattern3 v=solid color=cx43a2ca; /* reddish color */
title1 "Percent Agreement";
proc gchart data=have;
hbar question / discrete
type=sum sumvar=percent
subgroup=agreement/* this controls the coloring */
nostats
maxis=axis1 /* midpoint axis */
raxis=axis2 /* response/numeric axis */
autoref /* reflines at every major axis tickmark */
legend=legend1
coutline=same
;
run;
quit;
[/pre]
... View more
Have you set the nowait/noxsync options if you're using DDE?
Also if the process is saving over a file and you say don't save or some other excel prompt comes up you may cause the session to be interrupted. I try and make sure Excel is closed, especially the file I'm working on when using DDE.
HTH,
Reeza
... View more
I think you need to look at processing data with a macro variable LIST rather than array.
See this paper:
http://www2.sas.com/proceedings/sugi30/028-30.pdf
HTH,
Reeza
... View more
I think you need to look at processing data with a macro variable LIST rather than array.
See this paper:
http://www2.sas.com/proceedings/sugi30/028-30.pdf
HTH,
Reeza
... View more
