topic Re: Call sas table in SAS Programming

Call sas table

harshpatel — Thu, 09 Jun 2022 14:55:10 GMT

Hello folks, I have a sas data set name as a test If I have a test data set available then it should be call same table If table doesn't exist then I want to create the blank table with some columns
Thanks

Call Sas table if it is available or not

harshpatel — Thu, 09 Jun 2022 14:36:08 GMT

Hello folks,
I have a sas data set name as a test
If I have a test data set available then it should be call same table
If table doesn't exist then also I want to call the blank table like test
Thanks

Re: Call sas table

ballardw — Thu, 09 Jun 2022 15:22:50 GMT

Details when programming are important. Such as are the variables to be create the same every time that Test does not exist has to be used? Do they have the same properties of type(numeric or character), length (especially for character variables)?

Re: Call sas table

harshpatel — Thu, 09 Jun 2022 15:25:05 GMT

It could be any numeric or character
Basically I need to create blank table with some columns if table doesn't exist

Re: Call sas table

Reeza — Thu, 09 Jun 2022 15:32:04 GMT

This macro prints a table if the table is empty.

You can modify the code, to remove the proc print and put your create table statements there instead.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p011imau3tm4jen1us2a45cyenz9.htm

data one;
x=1;
run;
data two;
stop;
run;

%macro drive(dsn);
%let dsid=%sysfunc(open(&dsn));
    
 %if &dsid ne 0 %then %do;
  %let cnt=%sysfunc(attrn(&dsid,nlobs));
  %let rc=%sysfunc(close(&dsid));
   %if &cnt ne 0 %then %do;

/*What to do if data set exists*/
    proc print data=&dsn;
     title "This is data from data set &dsn"; 
    run;
   %end;
   %else %do;
/*What to do if data set does not exist*/
    data _null_;
     title;
     file print;
     put _page_;
     put "Data set &dsn is empty.";
    run;
   %end;
 %end;
 %else %put &dsn cannot be open.;
   
%mend drive;
%drive(one)
%drive(two)

@harshpatel wrote:
Hello folks, I have a sas data set name as a test If I have a test data set available then it should be call same table If table doesn't exist then I want to create the blank table with some columns
Thanks

Re: Call sas table

Tom — Thu, 09 Jun 2022 15:39:49 GMT

This macro prints a table if the table is empty.

Huh? You appear to using table in two different meanings in the same sentence.

Are you saying it makes a report if the dataset is empty?

Re: Call Sas table if it is available or not

Tom — Thu, 09 Jun 2022 15:49:47 GMT

@harshpatel wrote:
Hello folks,
I have a sas data set name as a test
If I have a test data set available then it should be call same table
If table doesn't exist then also I want to call the blank table like test
Thanks

It is not clear what you mean by "call". Or for that matter "table".

Are you saying that if a dataset does not exist you want to create an empty one with that name?
Do you know the structure it should have?

For example do you an existing dataset that you know will always exist that has the right structure?

If you have the name of the dataset in a macro variable, say DSNAME, and you have the template dataset available as TEMPLATE then do something like:

%let dsname=MYDS;
%if not %sysfunc(exist(&dsname)) %then %do;
data &dsname;
   stop;
   set template ;
run;
%end;

to create a new dataset with zero observations.

Re: Call sas table

JOL — Thu, 09 Jun 2022 16:14:56 GMT

Slightly different approach

/* create sample test */
data test;
set sashelp.class;
run;

%macro createtable(tab);
%if %sysfunc(exist(&tab))=1 %then /* check if table exists */
%do;

data &tab;
set &tab;
run;

%end;
%else
%do; /*if table does not exist create a generic table, adjust to your needs*/

data new;
length var1 - var5 $ 10;
length var6 - var10 8;
do i = 1 to 5;
output;
end;
drop i;
run;

%end;
%mend createtable;

options mprint;

%createtable(test)
%createtable(test2)

Re: Call sas table

harshpatel — Thu, 09 Jun 2022 16:28:16 GMT

Thanks, got the solution