Check this solution %MACRO TGRUP; DATA _NULL_;      SET T_GROUP;      CALL SYMPUT('MAXN', MAXNUM); RUN; %DO I=1 %TO &MAXN;      DATA T_GROUP&I;           SET T_GROUP;           IF GROUP_COUNT= &I THEN DO;           CURRENT = INT(TIME() *100);           RANDOM = INT(RANUNI(CURRENT)*100000);           OUTPUT T_GROUP&I;           END;      RUN;      PROC SORT DATA = T_GROUP&I; BY RANDOM; %END; %MEND TGRUP; %TGRUP; Hope this helps....! Thanks Dhanasekaran R ... View more

Please try this FILENAME CODEDIR PIPE "dir /s /d c:\sametime"; DATA DSN;      INFILE CODEDIR TRUNCOVER;      INPUT VAR1 $ 50.;      .....      SAS STATEMENTS      ..... RUN; you can use this CODEDIR anywhere in your program. Hope this helps Thanks Dhanasekaran R ... View more

Informats are typically used to read or input data from external files called flat files. The informat instructs SAS on how to read data into SAS variables. If informats are instructions for reading data, then you can view formats as instructions for outputting data. Thanks Dhanasekaran R ... View more

You can use Column Input to read from right to left. DATA DSN;   INPUT WEIGHT 10-12 HEIGHT 7-9 AGE 5-6 SEX $ 4-4 ID 1-3; DATALINES; 001F36175180 ; RUN; PROC PRINT DATA = DSN; RUN; Thanks Dhanasekaran R ... View more

Hi As Art told we can't use PROCs inside DATA Step. But here is one possible solution. DATA _NULL_;   SET DSN END=EOF;   CALL SYMPUT('FILE'||LEFT(_N_),"&directory"||DBFILE);   IF EOF THEN CALL SYMPUT('NUM',_N_); RUN; %MACRO IMPORT;    %DO I=1 %TO #       PROC IMPORT OUT=DSN&I.         DATAFILE=&&FILE&I.         DBMS=DBF REPLACE;       RUN;    %END; %MEND IMPORT; %IMPORT; Hope this helps. Thanks Dhanasekaran R      ... View more

If you are familiar with PROC SQL then you can use that also. PROC SQL;    SELECT YEAR,QUARTER,NAICS,SUM(HIRES) AS HIRESN    FROM NEWDS    GROUP BY YEAR, QUARTER, NAICS; QUIT; Thanks Dhanasekaran R ... View more

Hi, There are lot of methods available for merging 2 datasets. But which method you use is based on the type of data and number of observation it has. 1. PROC SQL;      SELECT VAR1,VAR2,T1.VAR3,VAR4,VAR5         FROM TABLE1 AS T1,TABLE2 AS T2         WHERE T1.VAR3=T2.VAR1;   QUIT; In PROC SQL itself there are many methods available (Inner Join, Left Join, Right Join) and apart from that you can use SET operators (EXCEPT,INTERCEPT, UNION) to merge datasets. (But each one serve different purpose). 2. SET statement a)     DATA dataset-name;        SET sas-dataset;        SET sas-dataset;     RUN; b)    DATA dataset-name;       SET sas-dataset;       SET sas-dataset KEY=index-name;     RUN; When you specify the index name in the KEY=option, processing changes from sequential to direct access, and SAS reads only the observation that satisfies the lookup. Hope this answers your question. Thanks Dhanasekaran R ... View more

Here is a command that we can use it for checking the file size in windows environment( through DOS prompt) for %I in (testfile.txt) do @echo %~ZI We can execute windows command inside SAS using 'X' Command statement or CALL SYSTEM routine. Please try this. Thanks Dhanasekaran R ... View more