Hi,   I am looking to create a new column that groups my data every n rows. For example I have 1,000 rows, I would like to create a column that assigns the first 100 rows Group 1, the next 100 rows Group 2, and so on until the final row.   Does anyone know how to accomplish this?   Thanks. ... View more

Hi,   I am trying to create an automated time staamp. This is what I have so far:   %LET TIME = %SYSFUNC(TIME() );   But this isn't giving me what I need. I need 9 digits with no "." in it, for example HHMMSSSSS. Does anyone know how to do that?   Thanks. ... View more

Hey,   I am looking to export multiple data sets into one DLM/CSV file, column names are not the same and formats are different. So far I have:   PROC EXPORT DATA=TEMP1 OUTFILE='C:\myfile' DBMS=DLM REPLACE; PUTNAMES=NO; DELIMITER='|'; RUN;   I still need data files TEMP2 and TEMP3 added. Any help would be appreciated.   Thanks. ... View more

Is there a way to find the central zip of a group of zips? For instance if I am given 30 different zips how can I find the central zip of that cluster?   Thanks. ... View more

Hi, I am trying to draw 10 mile radius circles around my locations on a map. Does someone know how to do this? Here is my code: /**FOR A COUNTIES MAP THE X AND Y COORDANIATES NEED TO BE CHANGED SO THIS IS DONE HERE**/ DATA P1; SET P1(WHERE=(STATE=34));   X=ATAN(1)/45 * LONG;   Y=ATAN(1)/45 * LAT; RUN; /**MAKE STAR MARKER OR ANOTHER TYPE OF MARKER**/ DATA P;/*ANNOTATE DATA SET*/ SET P1;/*PROVIDER DATA WITH X/Y*/ LENGTH FUNCTION STYLE COLOR $ 8 TEXT $4; XSYS = '2'; YSYS = '2';  HSYS = '3'; WHEN = 'A';  /**MAKE STAR MARKER OR ANOTHER TYPE OF MARKER**/ FUNCTION='LABEL'; STYLE='MARKER'; TEXT='V' SIZE = 1.75; IF PILOT='P' THEN COLOR='BILG';/**GREEN**/ IF PILOT='E' THEN COLOR='ORANGE';/**ORANGE**/ IF PILOT='A' THEN COLOR='CXFF0000';/**RED**/ IF COUNT=1 THEN POSITION='5'; IF COUNT=2 THEN POSITION='A'; IF COUNT=3 THEN POSITION='F'; OUTPUT; RUN; Thanks. ... View more