BookmarkSubscribeRSS Feed
ankit___gupta
Quartz | Level 8

Hi,

 

I am trying to do the following.

                                --> Create a SPDE library in Hadoop.

                                --> Send data to this library.

                                --> to create index on the dataset.

                                --> And be able to modify the dataset.

 

I don't know how to create SPDE library in SAS.

 

for the rest i have excuted the following.

 

 

LIBNAME STAGING SASHDAT  PATH="/staging"  SERVER=SASSERVERNODE  INSTALL="/Hadoop/TKGrid" ;
LIBNAME webma ODBC  DATAsrc=DSNAME USER=username  PASSWORD="{SAS002}4B4F181326F9896F4177761F1B986997140F7C995AE23782" ;

PROC SQL INOBS=10;
	create table STAGING.Big as
		Select * from webma.tblmaclaim;
quit;


proc sql;
    create index inde on STAGING.Big(ClmID, Clmtypeid);
quit;

DATA STAGING.Big;
	modify STAGING.Big;
	if ClmID=100008 then
		ClmEPD = 100;
run;

 

 

It gives the folllowing logs.

22         
23         GOPTIONS ACCESSIBLE;
24         proc sql;
25             create index inde on STAGING.Big(ClmID, Clmtypeid);
ERROR: Update access is not supported for file STAGING.BIG.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
26         quit;

 

 

 

 

I think the problem might be the SASHDAT engine.

 

 

Please help.

 

-Thanks in advance.

4 REPLIES 4
ankit___gupta
Quartz | Level 8

Hi LinusH,

 

I do not have SPDE, as it is not there in our license. I'm stuck.

 

Is it possblie to do it with SASHDAT itself ?

 

maggiem_sas
SAS Employee

What SAS version and product? You might have SPD Engine.

 

Have you tried submitting a LIBNAME with SPDE? See the examples here:

http://support.sas.com/documentation/cdl/en/engspdehdfsug/69725/HTML/default/viewer.htm#titlepage.ht...

in the chapter "How to Use Hadoop Data Storage."

BrunoMueller
SAS Super FREQ

Hi

 

You can make use of the SPDE engine but store the data in HDFS.

 

An example LIBNAME would look like this

 

libname spd_hdfs spde '/user/yourUser' hdfshost=default ;

Check the doc for more options.

 

Bruno

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1572 views
  • 0 likes
  • 4 in conversation