About Iris83

Iris83 · ‎05-10-2016

No but , there are only 6 so i don't mind writting them manualy , it's more writting all the other that is complicated . Thanks for your help

Iris83 · ‎05-10-2016

Thank you very much for the tips . All my column are in different formats ... That's why i can't change all the column's formats into date format . The t1* as you said is bit working in my situation ... Regards

Iris83 · ‎05-10-2016

PROC SQL ; create table table1 as Select /*all the columns*/ T1.date FORMAT=DDMMYY8. , T1.bithdaydate FORMAT=DDMMYY8. , From work.table t1 ; Quit ; That's what i want to produce because my dates are in number format ... However i want to avoid writting all the column's name . Thanks for your help ! Regards , Iris

Iris83 · ‎05-10-2016

Iris83 · ‎03-31-2016

I am trying to put the value of the plot on a bar+line graph . If I'm using the option POINTLABEL in my symbol , it has no affect on the graph . However , I can add the markers in the word Add-in so there must be way to program it . eg . SYMBOL1 INTERPOL=JOIN Pointlabel HEIGHT= 10pt FONT=MARKER VALUE=SQUARE CV=BLACK LINE=1 WIDTH=2 ..... PROC GBARLINE DATA=&table; BAR &variable / SUMVAR=TotalFleetPCT NOFRAME OUTSIDE=PCT TYPE=SUM COUTLINE=SAME RAXIS=AXIS1 MAXIS=AXIS2; PLOT / SUMVAR= ... TYPE=SUM AXIS=AXIS3 LEGEND=LEGEND1; RUN; QUIT; Thanks for your help , Iris

Online Status	Offline
Date Last Visited	‎05-13-2016 06:58 PM

Re: Proc sql

Re: Proc sql

Proc sql

proc SQL

POINTLABEL in GBARLINE

Re: Proc sql

Re: Proc sql

Proc sql

proc SQL

POINTLABEL in GBARLINE