Proc DataSets on Server Data

Jsendzik — Wed, 14 May 2014 18:39:58 GMT

Hey,

I just learned about the power of proc datasets and was wondering what would happen if I used this procedure on data stored on a SQL server. Does it affect the way the data is stored there? Right now I'm dumping the data into a dummy data set before modifying it's attributes. I'm just concerned, that if I use this procedure on data without creating the dummy data set, I might have people screaming at me about making changes to the formats of their data.

Thanks

Re: Proc DataSets on Server Data

jakarman — Wed, 14 May 2014 19:13:10 GMT

The sas/access interface is attempting to make the behavior of an external dbms and sas datasets transparant. Yes the "proc datasets" will do some tricks like "delete a:" .

You must have del data definition language access.

Can you do all tricks of "proc datasets" NO.

That is because the proc datasets was designed for sas datasets and the audit trail gig concepts are not existent with an external dbms.

topic Proc DataSets on Server Data in SAS Procedures

Proc DataSets on Server Data

Re: Proc DataSets on Server Data