what is the difference between $4. and $char4. formats in sas? ... View more

I am using below code .one and two has a column called reporting_date.In one and two , reporting_date is defined with format yymmdd10.I could check that using describe table command. But, when I try to do append , it is giving warning that format of reporting_date in one is date9 and format of reporting_date in two is yymmdd10. Why is this happening? data results; set one; run; proc append base=one data=two; run; ... View more

I want to read below column from input file and display them in the format specified..I want to write the sas format with below information .   column    datatype       logical_datatype        length        format ccy_ccd      string                   text                           3                $3.00 -------- PROC SQL; create table template ( ccy_ccd char(3) format=?? );   quit; ... View more

proc sql; create table tablelist as select MEMNAME as table_list from dictionary.tables where libname="S_ICE"; quit; I have got a note that " 10 tables are not returned as name is too long ". How can I overcome this problem.I understand that sas datasets have naming constraints and this note is because of that. I cannot pass through sql as dictionary.tables will not be available as shown in example code   proc sql; connect using mylib; create table t as select * from connection to mylib (select * from my_table_with_a_name_so_long_that_it_is_longer_than_any_single_line_of_a_program_should_be ); quit; ... View more

libname s_ice hadoop server='gb234" schema="rst_s_ice__production"; proc sql; create table tablelist as select MEMNAME as table_list from dictionary.tables where libname="S_ICE"; quit; %let folder=/sas/output/ filename outf "&folder.tablelist.xlsx"; proc export data=tablelist outfile=outf dbms=xlsx replace; sheet='rst_s_ice__production'; run; I have to get list of table names in differnrt schemas in hadoop.I need help in modifying the given code with the help of macro to get the list of table names in different schemas such as rst_hvgrp_prod, rst_pfm_mrt_prod,rst_rpt_sum_prod and export it to one excel with each sheet for one schema.sheet name must be same as schema_name ... View more

%let YYMMM=202303; Proc sql; create table table_list as  select memname from dictionary.tables where libname='HVGRP' and memname like "T_cdr_&yyyymm_%" order by input(substr(memname,length("T_CDR_&YYYYMM._")+1),8.); quit;   I want memname to adhere to below specifications: To correctly match values like "T_CDR_202303_1", "T_CDR_202303_2" and so on  "T_CDR_202303_n", ( where n is not a fixed integer   and it starts from 1 )   It should not match patterns other than above .It should exclude patterns for eg: "T_CDR_202303_SVB_0712" , "T_CDR_202303_1_BKP"       ... View more