Prev: SASMSG FUNCTION
Next: Macro Program to mimic "lines"
From: FrankB on 24 Feb 2010 08:57
Hi there,

I'm using a Sharepoint site for storing documents etc and I am
wondering if I can access Sharepoint from SAS/Base 9.1 to store
datasets etc. I can access the shared documents on the site using a
web folder, so I can move files to and from the Sharepoint site using
drag and drop.

I found a nice example on http://support.sas.com/resources/papers/proceedings09/390-2009.pdf

data sampledata;
do n=1 to 1000;
x=int(ranuni(77777)*7);
y=int(ranuni(77777)*5);
output;
end;
run;
filename out '\\mySharePointServer\Shared Documents
\ProcFreqExample.html';
ODS HTML encoding=UTF8 body=out dev=gif;
proc freq data=sampledata;
tables height*weight / chisq;
run;
ODS HTML close;

When I try this code with my https:\\ URL it won't work. It's
something like this:
filename out 'https:\\www.mysharepointsite.nl\sites\docs\Shared
Documents\ProcFreqExample.html';

My sharepoint site is only accessible from the internet so I guess I
have to supply my username and password somewhere.

Any ideas?
From: Alan Churchill on 24 Feb 2010 11:36
Frank,

Take a look here and see if it does what you need:

http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a00022
3242.htm

Alan

Alan Churchill
Savian
www.savian.net

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of FrankB
Sent: Wednesday, February 24, 2010 6:57 AM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: access Sharepoint from SAS/Base 9.1

Hi there,

I'm using a Sharepoint site for storing documents etc and I am wondering if
I can access Sharepoint from SAS/Base 9.1 to store datasets etc. I can
access the shared documents on the site using a web folder, so I can move
files to and from the Sharepoint site using drag and drop.

I found a nice example on
http://support.sas.com/resources/papers/proceedings09/390-2009.pdf

data sampledata;
do n=1 to 1000;
x=int(ranuni(77777)*7);
y=int(ranuni(77777)*5);
output;
end;
run;
filename out '\\mySharePointServer\Shared Documents \ProcFreqExample.html';
ODS HTML encoding=UTF8 body=out dev=gif; proc freq data=sampledata;
tables height*weight / chisq;
run;
ODS HTML close;

When I try this code with my https:\\ URL it won't work. It's something like
this:
filename out 'https:\\www.mysharepointsite.nl\sites\docs\Shared
Documents\ProcFreqExample.html';

My sharepoint site is only accessible from the internet so I guess I have to
supply my username and password somewhere.

Any ideas?
From: FrankB on 25 Feb 2010 03:07
On 24 feb, 17:36, alan.church...(a)SAVIAN.NET (Alan Churchill) wrote:
> Frank,
>
> Take a look here and see if it does what you need:
>
> http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default...
> 3242.htm
>
> Alan
>
> Alan Churchill
> Savianwww.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...(a)LISTSERV.UGA.EDU] On Behalf Of FrankB
> Sent: Wednesday, February 24, 2010 6:57 AM
> To: SA...(a)LISTSERV.UGA.EDU
> Subject: accessSharepointfrom SAS/Base 9.1
>
> Hi there,
>
> I'm using aSharepointsite for storing documents etc and I am wondering if
> I can accessSharepointfrom SAS/Base 9.1 to store datasets etc. I can
> access the shared documents on the site using a web folder, so I can move
> files to and from theSharepointsite using drag and drop.
>
> I found a nice example onhttp://support.sas.com/resources/papers/proceedings09/390-2009.pdf
>
> data sampledata;
>   do n=1 to 1000;
>   x=int(ranuni(77777)*7);
>   y=int(ranuni(77777)*5);
>   output;
> end;
> run;
> filename out '\\mySharePointServer\Shared Documents \ProcFreqExample.html';
> ODS HTML encoding=UTF8 body=out dev=gif; proc freq data=sampledata;
>   tables height*weight / chisq;
> run;
> ODS HTML close;
>
> When I try this code with my https:\\ URL it won't work. It's something like
> this:
> filename out 'https:\\www.mysharepointsite.nl\sites\docs\Shared
> Documents\ProcFreqExample.html';
>
> Mysharepointsite is only accessible from the internet so I guess I have to
> supply my username and password somewhere.
>
> Any ideas?- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Hi Alan,

When I use the url option in the filename statement, I get following
errors:

ERROR: URL/HTTP Access Method does not support Random mode
ERROR: Invalid open mode.

My code looks like:

filename out url 'https://www.mysit.nl/sites/docs/Shared Documents/
test.html' user='myusername' prompt;
ODS HTML encoding=UTF8 body=out dev=gif;
proc print data=sashelp.revhub2;
run;
ODS HTML close;
From: Alan Churchill on 25 Feb 2010 09:41
Frank,

I don't have SharePoint running so I cannot do testing. It has been awhile
since I did SAS/SharePoint work.

Here is also a paper and threads that might help:

http://support.sas.com/resources/papers/proceedings09/390-2009.pdf

http://support.sas.com/forums/thread.jspa?messageID=25665&#25665

http://blogs.sas.com/sasdummy/index.php?/archives/103-SAS-Web-Parts-for-Micr
osoft-Sharepoint.html



Alan

Alan Churchill
Savian
www.savian.net
Office: (719) 687-5954
Cell: (719) 310-4870


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of FrankB
Sent: Thursday, February 25, 2010 1:08 AM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: access Sharepoint from SAS/Base 9.1

On 24 feb, 17:36, alan.church...(a)SAVIAN.NET (Alan Churchill) wrote:
> Frank,
>
> Take a look here and see if it does what you need:
>
> http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default...
> 3242.htm
>
> Alan
>
> Alan Churchill
> Savianwww.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...(a)LISTSERV.UGA.EDU] On Behalf Of
FrankB
> Sent: Wednesday, February 24, 2010 6:57 AM
> To: SA...(a)LISTSERV.UGA.EDU
> Subject: accessSharepointfrom SAS/Base 9.1
>
> Hi there,
>
> I'm using aSharepointsite for storing documents etc and I am wondering if
> I can accessSharepointfrom SAS/Base 9.1 to store datasets etc. I can
> access the shared documents on the site using a web folder, so I can move
> files to and from theSharepointsite using drag and drop.
>
> I found a nice example
onhttp://support.sas.com/resources/papers/proceedings09/390-2009.pdf
>
> data sampledata;
> do n=1 to 1000;
> x=int(ranuni(77777)*7);
> y=int(ranuni(77777)*5);
> output;
> end;
> run;
> filename out '\\mySharePointServer\Shared Documents
\ProcFreqExample.html';
> ODS HTML encoding=UTF8 body=out dev=gif; proc freq data=sampledata;
> tables height*weight / chisq;
> run;
> ODS HTML close;
>
> When I try this code with my https:\\ URL it won't work. It's something
like
> this:
> filename out 'https:\\www.mysharepointsite.nl\sites\docs\Shared
> Documents\ProcFreqExample.html';
>
> Mysharepointsite is only accessible from the internet so I guess I have to
> supply my username and password somewhere.
>
> Any ideas?- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Hi Alan,

When I use the url option in the filename statement, I get following
errors:

ERROR: URL/HTTP Access Method does not support Random mode
ERROR: Invalid open mode.

My code looks like:

filename out url 'https://www.mysit.nl/sites/docs/Shared Documents/
test.html' user='myusername' prompt;
ODS HTML encoding=UTF8 body=out dev=gif;
proc print data=sashelp.revhub2;
run;
ODS HTML close;
From: Alan Churchill on 25 Feb 2010 13:22
Birdie says that he thinks the URL access method is read-only. Try FTP,
SFTP, or WebDAV instead.

http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a00017
8980.htm

http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a00304
1481.htm

http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a00233
2686.htm


Alan Churchill
Savian
www.savian.net
Office: (719) 687-5954
Cell: (719) 310-4870


-----Original Message-----
From: Boekamp, E.F. [mailto:E.F.Boekamp(a)umcutrecht.nl]
Sent: Thursday, February 25, 2010 9:00 AM
To: Alan Churchill
Subject: RE: access Sharepoint from SAS/Base 9.1

Hi Alan,

Thanks for your help!

I will look into these documents.

Cheers,

Frank Boekamp

Senior Datamanager| Julius Centrum | Universitair Medisch Centrum Utrecht |
Bezoekadres: Heidelberglaan 100, 3584 CX Utrecht, Stratenum kamer 4.121 |
Postadres: Postbus 85500, 3508 GA Utrecht, Huispostnummer Str. 6.131 | T.
088 756 8207 | www.juliuscentrum.nl



-----Oorspronkelijk bericht-----
Van: Alan Churchill [mailto:alan.churchill(a)savian.net]
Verzonden: donderdag 25 februari 2010 15:41
Aan: Boekamp, E.F.; SAS-L(a)LISTSERV.UGA.EDU
Onderwerp: RE: access Sharepoint from SAS/Base 9.1

Frank,

I don't have SharePoint running so I cannot do testing. It has been awhile
since I did SAS/SharePoint work.

Here is also a paper and threads that might help:

http://support.sas.com/resources/papers/proceedings09/390-2009.pdf

http://support.sas.com/forums/thread.jspa?messageID=25665&#25665

http://blogs.sas.com/sasdummy/index.php?/archives/103-SAS-Web-Parts-for-Micr
osoft-Sharepoint.html



Alan

Alan Churchill
Savian
www.savian.net
Office: (719) 687-5954
Cell: (719) 310-4870


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of FrankB
Sent: Thursday, February 25, 2010 1:08 AM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: access Sharepoint from SAS/Base 9.1

On 24 feb, 17:36, alan.church...(a)SAVIAN.NET (Alan Churchill) wrote:
> Frank,
>
> Take a look here and see if it does what you need:
>
> http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default...
> 3242.htm
>
> Alan
>
> Alan Churchill
> Savianwww.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SA...(a)LISTSERV.UGA.EDU] On Behalf Of
FrankB
> Sent: Wednesday, February 24, 2010 6:57 AM
> To: SA...(a)LISTSERV.UGA.EDU
> Subject: accessSharepointfrom SAS/Base 9.1
>
> Hi there,
>
> I'm using aSharepointsite for storing documents etc and I am wondering
> if I can accessSharepointfrom SAS/Base 9.1 to store datasets etc. I
> can access the shared documents on the site using a web folder, so I
> can move files to and from theSharepointsite using drag and drop.
>
> I found a nice example
onhttp://support.sas.com/resources/papers/proceedings09/390-2009.pdf
>
> data sampledata;
> do n=1 to 1000;
> x=int(ranuni(77777)*7);
> y=int(ranuni(77777)*5);
> output;
> end;
> run;
> filename out '\\mySharePointServer\Shared Documents
\ProcFreqExample.html';
> ODS HTML encoding=UTF8 body=out dev=gif; proc freq data=sampledata;
> tables height*weight / chisq;
> run;
> ODS HTML close;
>
> When I try this code with my https:\\ URL it won't work. It's
> something
like
> this:
> filename out 'https:\\www.mysharepointsite.nl\sites\docs\Shared
> Documents\ProcFreqExample.html';
>
> Mysharepointsite is only accessible from the internet so I guess I
> have to supply my username and password somewhere.
>
> Any ideas?- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Hi Alan,

When I use the url option in the filename statement, I get following
errors:

ERROR: URL/HTTP Access Method does not support Random mode
ERROR: Invalid open mode.

My code looks like:

filename out url 'https://www.mysit.nl/sites/docs/Shared Documents/
test.html' user='myusername' prompt; ODS HTML encoding=UTF8 body=out
dev=gif; proc print data=sashelp.revhub2; run; ODS HTML close;


----------------------------------------------------------------------------
--

De informatie opgenomen in dit bericht kan vertrouwelijk zijn en is
uitsluitend bestemd voor de geadresseerde. Indien u dit bericht onterecht
ontvangt, wordt u verzocht de inhoud niet te gebruiken en de afzender direct
te informeren door het bericht te retourneren. Het Universitair Medisch
Centrum Utrecht is een publiekrechtelijke rechtspersoon in de zin van de
W.H.W.
(Wet Hoger Onderwijs en Wetenschappelijk Onderzoek) en staat geregistreerd
bij de Kamer van Koophandel voor Midden-Nederland onder nr. 30244197.

Denk s.v.p aan het milieu voor u deze e-mail afdrukt.

----------------------------------------------------------------------------
--

This message may contain confidential information and is intended
exclusively for the addressee. If you receive this message unintentionally,
please do not use the contents but notify the sender immediately by return
e-mail. University Medical Center Utrecht is a legal person by public law
and is registered at the Chamber of Commerce for Midden-Nederland under no.
30244197.

Please consider the environment before printing this e-mail.
 | 
Pages: 1
Prev: SASMSG FUNCTION
Next: Macro Program to mimic "lines"