You can use the query builder to achieve this. Brief steps: you have two tables that share a key which is used to identify the accounts start your query with the table (called A from now on) that contains the accounts you are interested in join the second table (called B from now on) in the query using a left join on the select tab, get the columns from table A your are interested in add the the key column from table B to the select tab now define a filter on the key column from table B, all rows where this value is missing are only present in table A but not in table B Have a go ... View more

Hi Iramesh What exactly do you want to achieve? If you write a macro you do have the source code for it. For compiled stored macros, you can use the %COPY statement if the developer did not use the SECURE option on the %MACRO statement Bruno ... View more

Hi Have a look at the following discussion SAS Enterprise Guide has a Rank Task to find in the Daata category ... View more

SAS allows you to build custom date formats using Proc FORMAT, see an example below. Have a look at the doc for the PICTURE statement in Proc FORMAT for more information on other directives possible in a picture format. data have;   do month = 1 to 12;     myDate = mdy(month, 1, year(today()));     output;   end;   format myDate date9.; run; proc format;   picture x_yyyy_mm (default=7)     low - high = '%Y_%0m' (datatype=date)   ; run; proc sql;   select     myDate     , myDate as mydate2 format=yymmd.     , myDate as mydate3 format=x_yyyy_mm.   from     have   ; quit; ... View more

Proc REPORT can only work with one SAS Data Set, but you may use macro logic to run Proc REPORT several times with different SAS Data Sets ... View more

Hi JohnT You can not copy a SAS Data Set within the same library. However you can use other statements from Proc DATASETS to achieve the same. Have a look at the code below. It will delete an existing CLS2 data set. It then uses the APPEND statement, if the base table is not found, then append will make a copy of the data table and preserve index etc. data cls (index = (name) label="Original CLS");    set sashelp.class; run; proc datasets library = work;   delete cls2; run;   append  data=cls base=cls2; run; quit; ... View more

Suvi104 Have a look at the following code, it uses test data, the DATA Step is made to read this kind of data: data test;   infile cards dlm=";" truncover;   *   * check for the "record type" and keep record   *;   input     @1 recType $16. @   ;   *   * define the var for the header values, assume fixed number   *;   retain scenario year period view entity value pdr;   array myHeader{*} $ 12 scenario year period view entity value pdr;   *   * do not need the blank lines   *;   if char(RecType, 1) = " " then do;     delete;   end;     *   * start of header values, we will read the fixed number of lines   *;   if recType =: "!Scenario" then do;     do i = 1 to dim(myHeader);       input @1 tempValue $32.;       myHeader{i} = scan(tempValue, 2, "=");     end;   end;   else do;     *     * read the "data" lines and write to the output data set     *;     input       @1       v1 : $32.       v2 : $32.       v3 : $32.       v4 : $32.       v5 : $32.       v6 : $32.       v7 : 8.     ;     output;   end;   *   * we do not need these variables   *;   * drop recType i tempValue;   cards4; !Scenario=ACTUAL !Year=2013 !Period=Dec !View=YTD !Entity=29xxx !Value=USD Total !PDR=No GC14A03;[ICP Top];MGMT;EOP;AllCuxxx;GROSS;32.7802 GC14A03;[ICP Top];MGMT;EOP;CAxxx_TOT;GROSS;32.7802 !Scenario=scenario2 !Year=year2 !Period=period2 !View=view2 !Entity=entity2 !Value=vaue2 !PDR=pdr2 r1_GC14A03;[ICP Top];MGMT;EOP;AllCuxxx;GROSS;32.7802 r2_GC14A03;[ICP Top];MGMT;EOP;AllCuxxx;GROSS;32.7802 !Scenario=ACTUAL !Year=2013 !Period=Jan !View=YTD !Entity=2xx01 !Value=USD Total !PDR=No GC14A10;[ICP Top];MGMT;EOP;AllCuxxm3;GROSS;0 GC14A11;[ICP Top];MGMT;EOP;AllCuxxm3;GROSS;0 GC14A12;[ICP Top];MGMT;EOP;AllCuxxm3;GROSS;0 GC14A13;[ICP Top];MGMT;EOP;AllCuxxm3;GROSS;0 ;;;; ... View more

Have a look at this code COUNTW will count the "words" delimited by a blank, SCAN will get the proper string data postalcodes;   postal_codes = "T1S0C3 T1S1A1 T1S1A2 T1S1A4 T1S1A5 T1S1A6 T1S1A7 T1S1A8 T1S1A9 T1S1B1 T1S1B2";   length postalCode $ 16;   n_postalCodes = countw(postal_codes, " ");   do i = 1 to n_postalCodes;     postalCode = scan(postal_codes, i, " ");     output;   end;   drop postal_codes /* n_postalCodes i */; run;   ... View more

Fleroo I might have to do with the length, I am not sure, I generally put quotes around userid and password. Please mark the discussion as answered, so others can see immediately that this has been answered Enjoy using SAS ... View more