DATA Step, Macro, Functions and more

loading dynamic SAS dataset to teradata table.

Reply
Contributor
Posts: 35

loading dynamic SAS dataset to teradata table.

Hi All,

 

I have a sas data set,which will update with different column names everymonth.I have to create teradata table from this dataset.How can i define the structure of the table based on SAS dataset(how to choose index variable etc) it is a huge dataset??

 

Ex: dataset april month:

 

PRSN_ID exp1 exp2 exp3

     .           1        0      1

    111       2        3       1

 

dataset May month

 

Name  exp2 db008 behaviour

rxt         1       2        good

tuv         0       1        notbad

PROC Star
Posts: 1,233

Re: loading dynamic SAS dataset to teradata table.

So is it the case that every month you are getting a new dataset that has no relationship to the previous month's dataset? 

 

Do you want to load the May data into Teradata and and replace the April table in Teradata?

 

If you get a new dataset every month, with different column names, you would probably need to ask the provider to also provide information on keys/indexes when they deliver the data. 

 

You can of course add your own GUID, or every month look through variables to see if you can find set of variables that would be reasonable candidates to use as an index, but that wouldn't seem very useful.

 

I'm perplexed by the big picture.  The idea of a "dynamic table" where columns change every month does not seem very useful to me. 

Contributor
Posts: 35

Re: loading dynamic SAS dataset to teradata table.

it is very huge data with 115 columns,finding solution how to load this data in the database automatically. this table is the input for 10 other processes.

PROC Star
Posts: 1,233

Re: loading dynamic SAS dataset to teradata table.

So could your question be simplified to "How do I load a SAS dataset into Teradata?"
Contributor
Posts: 35

Re: loading dynamic SAS dataset to teradata table.

yes,based on proc datasets output i want to read the column names and datatypes and pass it to create table statement.

PROC Star
Posts: 1,233

Re: loading dynamic SAS dataset to teradata table.

If you show some sample data and the create table statement that you would want to generate for that data, it might make it easier for folks to help you.
Ask a Question
Discussion stats
  • 5 replies
  • 312 views
  • 0 likes
  • 2 in conversation