cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Luis3
‎10-29-2019
  • 9 Posts
  • 2 Likes Given
  • 1 Solutions
  • 1 Likes Received

alpha numeric

by Fluorite | Level 6 in SAS Programming
‎10-28-2019 08:48 PM
‎10-28-2019 08:48 PM
Hi all,   How can I convert a alphanumeric format (character) : 5 x 10 ^ 6 to numeric 5000000.   Thanks.   Luis. ... View more

Re: Double Macrovariable

by Fluorite | Level 6 in SAS Programming
‎09-10-2017 09:50 AM
‎09-10-2017 09:50 AM
I will ask tomorrow, look like nobody can help me today with it. 😞 ... View more

Re: Double Macrovariable

by Fluorite | Level 6 in SAS Programming
‎09-10-2017 08:46 AM
‎09-10-2017 08:46 AM
Hi, I want different loops, 1 to m1 1 to m2 1 to m3 1 to m4 1 to m5   I thought &&m&i could do the job.   Basically, i want a dataset that goes from subjid=1 with m1 records, subjid=2 with m2 records,....and subjid=5 with m5 records.   thanks. ... View more

Double Macrovariable

by Fluorite | Level 6 in SAS Programming
‎09-10-2017 08:30 AM
‎09-10-2017 08:30 AM
Hi everyone,   I hope you can help me with this.   data have; input subjid count; datalines; 1 145 2 124 3 34 4 65 5 180 ; data want0 ; set have end=last;; by subjid; if last then call symput('totsub',put(subjid,best.)); run; %put &totsub.; data _null_; SET WANT0; call symputx(cats('M',subjid),count); run; 　 %put &m5.;     　 data want; set want0; do i=1 to &totsub.; do j=1 to &&m&i.; ***it doesnt work, I need help on this; output; end; end; run; ... View more

Re: Graph in SGPLOT (label and minor tick marks in x axis )

by Fluorite | Level 6 in SAS Programming
‎08-26-2017 10:04 AM
1 Like
‎08-26-2017 10:04 AM
1 Like
I solved my own question 🙂   I havr to use minor option and then minorcount=9:   xaxis label='Rain' grid values= (10 20 30) minor minorcount=9;   Solved 🙂   Reproducing GPLOT graph using SGPLOT:   data dowhlc; input subjid high low close; datalines; 1 6511.38 6318.96 6442.49 2 6586.42 6437.10 6544.09 3 6621.82 6481.75 6600.66 4 6621.82 6481.75 6600.66 5 6511.38 6318.96 6442.49 6 6511.38 6318.96 6442.49 7 6586.42 6437.10 6544.09 8 6621.82 6481.75 6600.66 9 6621.82 6481.75 6600.66 10 6511.38 6318.96 6442.49 11 6511.38 6318.96 6442.49 12 6586.42 6437.10 6544.09 13 6621.82 6481.75 6600.66 14 6621.82 6481.75 6600.66 15 6511.38 6318.96 6442.49 16 6511.38 6318.96 6442.49 17 6586.42 6437.10 6544.09 18 6621.82 6481.75 6600.66 19 6621.82 6481.75 6600.66 20 6511.38 6318.96 6442.49 21 6511.38 6318.96 6442.49 22 6586.42 6437.10 6544.09 23 6621.82 6481.75 6600.66 24 6621.82 6481.75 6600.66 25 6511.38 6318.96 6442.49 26 6511.38 6318.96 6442.49 27 6586.42 6437.10 6544.09 28 6621.82 6481.75 6600.66 29 6621.82 6481.75 6600.66 30 6511.38 6318.96 6442.49 ;   ods listing close; ods graphics / reset width=600px height=400px imagefmt=gif;   /* The SCATTER statement generates the scatter plot with error bars. */ /* The SERIES statement draws the line to connect the means. */ proc sgplot data=dowhlc noautolegend;   scatter x=subjid y=close / yerrorlower=low yerrorupper=high markerattrs=(color=blue symbol=CircleFilled); series x=subjid y=close / lineattrs=(color=blue pattern=2); xaxis label='Rain' grid values= (10 20 30) minor minorcount=9; title1 'Plot Means with Standard Error Bars from Calculated Data'; run;     ods listing; ... View more

Re: Graph in SGPLOT (label and minor tick marks in x axis )

by Fluorite | Level 6 in SAS Programming
‎08-26-2017 09:54 AM
‎08-26-2017 09:54 AM
Label 10 20 30 can be done adding this line:   xaxis label='Rain' grid values= (10 20 30);   Now, I need to add the minor tickmarks , any one can help me with it?   thanks. ... View more

Re: Graph in SGPLOT (label and minor tick marks in x axis )

by Fluorite | Level 6 in SAS Programming
‎08-26-2017 09:45 AM
‎08-26-2017 09:45 AM
Hi again,   I did part of the job, now need to reproduce the same label and minot tick marks I used in GPLOT: If anyone can help me with it, to reproduce the same x axis I did for GPLOT, will be appreciate,   Thanks,   data dowhlc; input subjid high low close; datalines; 1 6511.38 6318.96 6442.49 2 6586.42 6437.10 6544.09 3 6621.82 6481.75 6600.66 4 6621.82 6481.75 6600.66 5 6511.38 6318.96 6442.49 6 6511.38 6318.96 6442.49 7 6586.42 6437.10 6544.09 8 6621.82 6481.75 6600.66 9 6621.82 6481.75 6600.66 10 6511.38 6318.96 6442.49 11 6511.38 6318.96 6442.49 12 6586.42 6437.10 6544.09 13 6621.82 6481.75 6600.66 14 6621.82 6481.75 6600.66 15 6511.38 6318.96 6442.49 16 6511.38 6318.96 6442.49 17 6586.42 6437.10 6544.09 18 6621.82 6481.75 6600.66 19 6621.82 6481.75 6600.66 20 6511.38 6318.96 6442.49 21 6511.38 6318.96 6442.49 22 6586.42 6437.10 6544.09 23 6621.82 6481.75 6600.66 24 6621.82 6481.75 6600.66 25 6511.38 6318.96 6442.49 26 6511.38 6318.96 6442.49 27 6586.42 6437.10 6544.09 28 6621.82 6481.75 6600.66 29 6621.82 6481.75 6600.66 30 6511.38 6318.96 6442.49 ;   ods listing close; ods graphics / reset width=600px height=400px imagefmt=gif;     proc sgplot data=dowhlc noautolegend; scatter x=subjid y=close / yerrorlower=low yerrorupper=high markerattrs=(color=blue symbol=CircleFilled); series x=subjid y=close / lineattrs=(color=blue pattern=2); run;     ods listing; ... View more

Graph in SGPLOT (label and minor tick marks in x axis )

by Fluorite | Level 6 in SAS Programming
‎08-26-2017 08:16 AM
‎08-26-2017 08:16 AM
Hi all, I have a question I hope you can help me with it.   It is possible to reproduce this Graph (showing label and minor tick marks in x axis, using SGPLOT instead?   I think the difficulty is insert the minor tickmarcks,  notice you can do it using GPLOT: minor=(number=9 color=red height=2 width=1)   but I am interested to create this graph in SGPLOT.   Thanks,   L.           data dowhlc; input subjid high low close; datalines; 1 6511.38 6318.96 6442.49 2 6586.42 6437.10 6544.09 3 6621.82 6481.75 6600.66 4 6621.82 6481.75 6600.66 5 6511.38 6318.96 6442.49 6 6586.42 6437.10 6544.09 7 6621.82 6481.75 6600.66 8 6621.82 6481.75 6600.66 9 6511.38 6318.96 6442.49 10 6586.42 6437.10 6544.09 11 6621.82 6481.75 6600.66 12 6621.82 6481.75 6600.66 13 6511.38 6318.96 6442.49 14 6586.42 6437.10 6544.09 15 6621.82 6481.75 6600.66 16 6621.82 6481.75 6600.66 17 6511.38 6318.96 6442.49 18 6586.42 6437.10 6544.09 19 6621.82 6481.75 6600.66 20 6621.82 6481.75 6600.66 21 6586.42 6437.10 6544.09 22 6621.82 6481.75 6600.66 23 6621.82 6481.75 6600.66 24 6511.38 6318.96 6442.49 25 6586.42 6437.10 6544.09 26 6621.82 6481.75 6600.66 27 6621.82 6481.75 6600.66 28 6511.38 6318.96 6442.49 29 6586.42 6437.10 6544.09 30 6621.82 6481.75 6600.66 run; data dowhlc2; set dowhlc; drop high low close; dow=high; output; dow=low; output; dow=close; output; title1 'Dow Jones High-Low-Close'; title2 'January, 1997'; footnote height=3 justify=right 'GR08N01 ' ; symbol interpol=hiloctj cv=blue ci=red width=2; axis1 order=(10 20 30) offset=(3,3) color=blue label=none major=(height=3 width=2) minor=(number=9 color=red height=2 width=1) width=3; axis2 color=blue label=none major=(height=3) minor=(number=4 color=red height=1) offset=(2,2); proc gplot data=dowhlc2; plot dow*subjid / haxis=axis1 vaxis=axis2; run; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-29-2019 12:49 AM
Likes given to
View All
Likes from
View All
Quick links