My date is date=20361; I need my date format to be in YYYYMMDD format. I tried to use this format YMMDDxw. format   Piece of code :-   data _null_; tdy_date = put(date, yymmddn8.); call symput('today_dt', tdy_date); run;   data _null_; file output_&today_dt.; set output_ds; run; ... View more

I have a merge statement which needs to be converted to a proc sql join,   data a.main; merge main a.proxy; by id; run;   which i wrote it as,   proc sql; create table a.main as select * from main a join a.proxy b on a.id=b.id; run;   Now the tough part for me is, the data step has gone bit complex with parameters how do i replicate the same in proc sql ?   data a.main; merge main a.proxy (drop=name address city pin_code %if %eval(&ht2. IN XX YY ZZ) %then %str(orig_name); ); by id; run; run; ... View more

Hi,   I am executing my SAS pgms in unix environment, so executes the .sas pgms in shl. Now i have a requirement to break a datastep on a particular condition & return a code to shl, so that based on the return code shl will call a sql loader which loads data to oracle table.   data header; infile "<path>/data.dat" dlm="|"; input recds : $2. id : 18. name : $30. chk_flg : $1.; if(chk_flg) = 'Y'; then <the pgm needs to break with a return code>   run; ... View more

I am connecting to oracle to create a SAS work table temp using   create table temp as select distinct id,emp_id  from DATA_EXCL;   the id field in data_excl oracle table is varchar. So SAS is assigning this column 'char' value.   When i then merge it with my main SAS table i have the rec_id field as numeric. This is creating an error while merging. How do i convert the datatype of a variable fetched using proc sql ?   proc contents output: # Variable Type Len Format Informat Label 2 ID              Num 8      10.  10.   ID 1 EMP_ID    Char 15  $15.  $15. EMP_ID ... View more

Hi All,   I am writing a macro, which would remove records from my base dataset based on another table values(status), meaning    status table: id       emp_no  status 1        23333     expired 2       44444      active 3       66666      expired   Base table id   emp_no   DOB               address 1    23333     26-Oct-1990   Street 1 2    44444    23-jan-1990     Street 2 3    66666     14-feb-1987   Street 3   Output table(required) id emp_no   DOB               address 2    44444    23-jan-1990     Street 2   I have done it using merge, is there any more efficient way to achieve the same. ?   proc sql; create table status as (select empno,status from status where status = 'expired');run;   data outputds; merge base(in=a) status(in=b) by emp_no; if b then output expired; else output outputds; run; ... View more

%if "&option"="Y" %then %do; %make_dlm_file(dataset = base_recs, /* make_dlm_file creates a delimited output file */ filename = "/home/xxxxx/Output_&cntry._&id.txt", dlmr = "|", qtes = "no", header = "no", label = "no"); run; Is it possible to add a timestamp to the output file name :- /home/xxxxx/Output_&cntry._&id_<timestamp>.txt     ... View more