[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: SAS enterprise and SAS 9.4 formats
From: "data _null_;" <datanull () GMAIL ! COM>
Date: 2015-09-28 13:57:55
Message-ID: CA+WFKKtLE9yMpmjipE6hkCRAcLRXpEd++Ga2XJH8nXv3eEVy1A () mail ! gmail ! com
[Download RAW message or body]
I would use CNTLOUT then you can see what you have (if you want to look at
it) and it seems the SAS data set is safer. You should be able to read
that with any version of SAS..
If your formats have descriptions then you might consider that you want to
keep them and use CPORT. I can't remember every using CPORT for formats but
then I don't do a lot of this sort of thing. ("we" usually just run the
source)
On Mon, Sep 28, 2015 at 8:47 AM, Stanford Ernest Mwasongwe <
smwasongwe@gmail.com> wrote:
> Hi guys to clarify what I posted over the wkend, I am a little lost on the
> best approach to handle the formats, is CNTLOUT the way to go or proc
> cport? I have a number of formats in different directories that I would
> like to create an autoexec but I first need to have these formats in the
> system that can be read by the EG
>
> thanks
> Stanford
>
> *Stanford*
>
> *__________________________________________________________________________________*
>
> *Stanford Mwasongwe, MPH*
> Epidemiologist
> Jackson Heart Study- Field Center
> Office of Surveillance & Epidemiology
> 350 West Woodrow Wilson Ave., Suite 701
> Jackson, Mississippi 39213-4505
> Email: smwasongwe@gmail.com
> LinkedIn Page:
> http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/
>
> On Sat, Sep 26, 2015 at 6:28 PM, Stanford Ernest Mwasongwe <
> smwasongwe@gmail.com> wrote:
>
> > So I am a little list, Is CNTLOUT better to deal with meta data or cport,
> > I've never used CNTLOUT before, and I have a number of formats in different
> > directories that I need to access, thanks for suggestions
> >
> > --
> > Typed with thumbs and sent with love from Boomerang
> > <http://boomerangandroid.com/?utm_source=b4a_signature&utm_medium=b4a_email_sig&utm_campaign=play_promote>
> >
> >
> > -----Original Message-----
> > Re: SAS enterprise and SAS 9.4 formats
> > From: data _null_; <datanull@GMAIL.COM>
> > To: <SAS-L@LISTSERV.UGA.EDU>
> > Saturday, September 26, 2015 at 11:56 AM
> >
> > Another good point.
> >
> > I do likes me some metadata.
> >
> > On Sat, Sep 26, 2015 at 7:12 AM, <rogerjdeangelis@gmail.com> wrote:
> >
> > > I think programmers overlook the value of good meta data. Meta data is
> > > more valuable than the data.
> > >
> > > You can put a lot in 255 bytes
> > > Sent from my iPhone
> > >
> > > On Sep 26, 2015, at 7:55 AM, data _null_; <datanull@GMAIL.COM> wrote:
> > >
> > > The advantage in my opinion of using CNTLOUT= is that once you have the
> > > SAS data set(s) your formats are much safer and easier to use with regards
> > > to platforms and/or bit-ness.
> > >
> > > On Fri, Sep 25, 2015 at 10:06 PM, Jack Hamilton <jfh@alumni.stanford.edu
> > > > wrote:
> > >
> > > > I would create a SAS data set containing the formats with PROC FORMAT
> > > > using the CNTLOUT= option, transfer it to the other system, and recreate
> > > > the formats with PROC FORMAT using the CNTLIN= option.
> > > >
> > > >
> > > > On Sep 25, 2015, at 7:53 PM, Stanford Ernest Mwasongwe <
> > > > smwasongwe@gmail.com> wrote:
> > > >
> > > > Thanks Joe, Jack et., I am still figuring EG, our 9.4 is expiring in
> > > > couple days. Anyway, a follow-up question regarding formats, I was finally
> > > > able to run the code to access all my data but for formats I am getting an
> > > > error that the formats were created in a different system. I know this may
> > > > be trivial to many of you, but your help will be appreciated.
> > > >
> > > > *Stanford*
> > > >
> > > > *__________________________________________________________________________________*
> > > >
> > > > *Stanford Mwasongwe, MPH*
> > > > Epidemiologist
> > > > Jackson Heart Study- Field Center
> > > > Office of Surveillance & Epidemiology
> > > > 350 West Woodrow Wilson Ave., Suite 701
> > > > Jackson, Mississippi 39213-4505
> > > > Email: smwasongwe@gmail.com
> > > > LinkedIn Page:
> > > > http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/
> > > >
> > > > On Fri, Sep 25, 2015 at 4:51 PM, Jack Hamilton <jfh@alumni.stanford.edu
> > > > > wrote:
> > > >
> > > > > Joe has already given you a solution, but to look at the cause, what
> > > > > happens if you do a LIBNAME TE1 LIST statement after the failed assignment?
> > > > >
> > > > > =====
> > > > > 3324 libname abc 'xyz';
> > > > > NOTE: Library ABC does not exist.
> > > > > 3325 libname abc list;
> > > > > NOTE: Libref= ABC
> > > > > Scope= DMS Process
> > > > > Engine= V9
> > > > > Physical Name= C:\Temp\xyz
> > > > > Filename= C:\Temp\xyz
> > > > > =====
> > > > >
> > > > > If you haven't set certain abend-related system options, SAS will tell
> > > > > you where it tried to assign the lib name.
> > > > >
> > > > >
> > > > > On Sep 25, 2015, at 1:12 PM, Stanford Ernest Mwasongwe <
> > > > > smwasongwe@GMAIL.COM> wrote:
> > > > >
> > > > > Hi all,
> > > > >
> > > > > At my office we're migrating to SAS enterprise, I run the following
> > > > > line code I used to SAS 9.4 but it does not give me access to the file
> > > > >
> > > > > X 'cd
> > > > > \\ntummc\datashares\dept\SC\Working\Stanford\Datareq\Jh1477\Robert
> > > > > Olivo\P0616\3-final deliverables';
> > > > > the above line works ok, however, if I use the following code
> > > > >
> > > > > *Assign project directory;
> > > > >
> > > > > X 'cd
> > > > > \\ntummc\datashares\dept\SC\Working\Stanford\Datareq\Jh1477\Robert
> > > > > Olivo\P0616';
> > > > >
> > > > > libname te1 '3-final deliverables';
> > > > > I am getting a message on log that library te1 does not exist, any
> > > > > idea why, thanks
> > > > >
> > > > > *Stanford*
> > > > >
> > > > > *__________________________________________________________________________________*
> > > > >
> > > > > *Stanford Mwasongwe, MPH*
> > > > > Epidemiologist
> > > > > Jackson Heart Study- Field Center
> > > > > Office of Surveillance & Epidemiology
> > > > > 350 West Woodrow Wilson Ave., Suite 701
> > > > > Jackson, Mississippi 39213-4505
> > > > > Email: smwasongwe@gmail.com
> > > > > LinkedIn Page:
> > > > > http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
>
[Attachment #3 (text/html)]
<div dir="ltr">I would use CNTLOUT then you can see what you have (if you want to \
look at it) and it seems the SAS data set is safer. You should be able to read that \
with any version of SAS.. <div><br></div><div>If your formats have descriptions \
then you might consider that you want to keep them and use CPORT. I can't \
remember every using CPORT for formats but then I don't do a lot of this sort of \
thing. ("we" usually just run the source) </div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 28, 2015 at 8:47 AM, \
Stanford Ernest Mwasongwe <span dir="ltr"><<a href="mailto:smwasongwe@gmail.com" \
target="_blank">smwasongwe@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" \
style="font-family:georgia,serif">Hi guys to clarify what I posted over the wkend, I \
am a little lost on the best approach to handle the formats, is CNTLOUT the way to go \
or proc cport? I have a number of formats in different directories that I would like \
to create an autoexec but I first need to have these formats in the system that can \
be read by the EG</div><div class="gmail_default" \
style="font-family:georgia,serif"><br></div><div class="gmail_default" \
style="font-family:georgia,serif">thanks</div><span class="HOEnZb"><font \
color="#888888"><div class="gmail_default" \
style="font-family:georgia,serif">Stanford</div></font></span></div><div \
class="gmail_extra"><span class=""><br clear="all"><div><div><div \
dir="ltr"><div><span style="font-size:x-small"><font size="2"><font><span \
style="font-size:10pt"><font face="bookman old style, new york, times, serif" \
color="#444444"><b>Stanford</b></font></span></font></font></span></div><div><font \
face="bookman old style, new york, times, serif" color="#000000" \
style="font-size:10pt"><b>__________________________________________________________________________________</b> \
</font><font color="#0000ff" face="bookman old style, new york, times, serif" \
style="font-size:10pt"> </font></div><font><font><div style="font-size:10pt"><font \
face="verdana, sans-serif" color="#000000"><b>Stanford Mwasongwe, \
MPH</b></font></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font \
color="#000000">Epidemiologist</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font color="#000000">Jackson \
Heart Study- Field Center</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font color="#000000">Office of \
Surveillance & Epidemiology</font></span></div><div style="font-size:10pt"><span \
style="font-size:10pt;font-family:verdana,sans-serif"><font color="#000000">350 West \
Woodrow Wilson Ave., Suite 701</font></span></div><div style="font-size:10pt">
<span style="font-size:10pt"><font face="verdana, sans-serif" \
color="#000000">Jackson, Mississippi 39213-4505</font></span><br></div><div \
style="font-size:10pt"><font size="1" face="verdana, sans-serif"><span \
style="font-size:7.5pt"><span style="font-size:x-small"><font \
color="#000000">Email</font><font color="#0000ff">: </font><a \
href="mailto:smwasongwe@gmail.com" style="color:blue" \
target="_blank">smwasongwe@gmail.com</a></span></span></font></div><div \
style="font-size:10pt;color:blue"><font face="verdana, sans-serif" size="1" \
color="#000000">LinkedIn Page:</font><font face="verdana, sans-serif" size="1"> \
</font><font color="#0000ff" face="verdana, sans-serif" size="1"><a \
href="http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/" \
target="_blank">http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/</a></font><br></div></font></font></div></div></div>
<br></span><div><div class="h5"><div class="gmail_quote">On Sat, Sep 26, 2015 at \
6:28 PM, Stanford Ernest Mwasongwe <span dir="ltr"><<a \
href="mailto:smwasongwe@gmail.com" \
target="_blank">smwasongwe@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">So I am a little list, Is CNTLOUT better to deal with meta \
data or cport, I've never used CNTLOUT before, and I have a number of formats in \
different directories that I need to access, thanks for suggestions<span><font \
color="#888888"><br><br>-- <br>Typed with thumbs and sent with love from <a \
href="http://boomerangandroid.com/?utm_source=b4a_signature&utm_medium=b4a_email_sig&utm_campaign=play_promote" \
target="_blank">Boomerang</a></font></span><div><div><br><br>-----Original \
Message-----<br>Re: SAS enterprise and SAS 9.4 formats<br>From: data _null_; <<a \
href="mailto:datanull@GMAIL.COM" target="_blank">datanull@GMAIL.COM</a>><br>To: \
<<a href="mailto:SAS-L@LISTSERV.UGA.EDU" \
target="_blank">SAS-L@LISTSERV.UGA.EDU</a>><br>Saturday, September 26, 2015 at \
11:56 AM<br><br><div><div dir="ltr">Another good point.<div><br></div><div>I do likes \
me some metadata. </div></div><div class="gmail_extra"><br><div \
class="gmail_quote">On Sat, Sep 26, 2015 at 7:12 AM, <span dir="ltr"><<a \
href="mailto:rogerjdeangelis@gmail.com" \
target="_blank">rogerjdeangelis@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div \
dir="auto"><div>I think programmers overlook the value of good meta data. Meta data \
is more valuable than the data.<br><br>You can put a lot in 255 bytes<br>Sent from my \
iPhone</div><div><div><div><br>On Sep 26, 2015, at 7:55 AM, data _null_; <<a \
href="mailto:datanull@GMAIL.COM" target="_blank">datanull@GMAIL.COM</a>> \
wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">The advantage in my \
opinion of using CNTLOUT= is that once you have the SAS data set(s) your formats are \
much safer and easier to use with regards to platforms and/or bit-ness. </div><div \
class="gmail_extra"><br><div class="gmail_quote">On Fri, Sep 25, 2015 at 10:06 PM, \
Jack Hamilton <span dir="ltr"><<a href="mailto:jfh@alumni.stanford.edu" \
target="_blank">jfh@alumni.stanford.edu</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div>I \
would create a SAS data set containing the formats with PROC FORMAT using the \
CNTLOUT= option, transfer it to the other system, and recreate the formats with PROC \
FORMAT using the CNTLIN= option.<div><div><div><br></div><div><br><div><blockquote \
type="cite"><div>On Sep 25, 2015, at 7:53 PM, Stanford Ernest Mwasongwe <<a \
href="mailto:smwasongwe@gmail.com" target="_blank">smwasongwe@gmail.com</a>> \
wrote:</div><br><div><div dir="ltr"><div class="gmail_default" \
style="font-family:georgia,serif">Thanks Joe, Jack et., I am still figuring EG, our \
9.4 is expiring in couple days. Anyway, a follow-up question regarding formats, I was \
finally able to run the code to access all my data but for formats I am getting an \
error that the formats were created in a different system. I know this may be trivial \
to many of you, but your help will be appreciated.</div><div \
class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div><span \
style="font-size:x-small"><font size="2"><font><span style="font-size:10pt"><font \
color="#444444"><b>Stanford</b></font></span></font></font></span></div><div><font \
style="font-size:10pt"><b>__________________________________________________________________________________</b> \
</font><font color="#0000ff" style="font-size:10pt"> </font></div><font><font><div \
style="font-size:10pt"><font><b>Stanford Mwasongwe, MPH</b></font></div><div \
style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Epidemiologist</font></span></div><div \
style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Jackson Heart Study- \
Field Center</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Office of Surveillance \
& Epidemiology</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>350 West Woodrow Wilson \
Ave., Suite 701</font></span></div><div style="font-size:10pt">
<span style="font-size:10pt"><font>Jackson, Mississippi \
39213-4505</font></span><br></div><div style="font-size:10pt"><font size="1"><span \
style="font-size:7.5pt"><span style="font-size:x-small"><font>Email</font><font \
color="#0000ff">: </font><a style="color:blue" href="mailto:smwasongwe@gmail.com" \
target="_blank">smwasongwe@gmail.com</a></span></span></font></div><div \
style="color:blue;font-size:10pt"><font size="1">LinkedIn Page:</font><font size="1"> \
</font><font color="#0000ff" size="1"><a \
href="http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/" \
target="_blank">http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/</a></font><br></div></font></font></div></div></div>
<br><div class="gmail_quote">On Fri, Sep 25, 2015 at 4:51 PM, Jack Hamilton <span \
dir="ltr"><<a href="mailto:jfh@alumni.stanford.edu" \
target="_blank">jfh@alumni.stanford.edu</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div>Joe \
has already given you a solution, but to look at the cause, what happens if you do a \
LIBNAME TE1 LIST statement after the failed \
assignment?<div><br></div><div>=====</div><div><div \
style="margin:0px;font-family:"Courier New";font-size:10px">3324 libname \
abc 'xyz';</div><div style="margin:0px;font-family:"Courier \
New";font-size:10px">NOTE: Library ABC does not exist.</div><div \
style="margin:0px;font-family:"Courier New";font-size:10px">3325 libname \
abc list;</div><div style="margin:0px;font-family:"Courier \
New";font-size:10px">NOTE: Libref= ABC</div><div \
style="margin:0px;font-family:"Courier New";font-size:10px"> Scope= \
DMS Process</div><div style="margin:0px;font-family:"Courier \
New";font-size:10px"> Engine= V9</div><div \
style="margin:0px;font-family:"Courier New";font-size:10px"> \
Physical Name= C:\Temp\xyz</div><div style="margin:0px;font-family:"Courier \
New";font-size:10px"> Filename= C:\Temp\xyz</div></div><div \
style="margin:0px;font-family:"Courier New";font-size:10px">=====</div><div \
style="margin:0px;font-family:"Courier New";font-size:10px"><br></div><div \
style="margin:0px">If you haven't set certain abend-related system options, SAS will \
tell you where it tried to assign the lib name.</div><div><div><div \
style="margin:0px"><br></div><div style="margin:0px"><br></div><div><div><blockquote \
type="cite"><div>On Sep 25, 2015, at 1:12 PM, Stanford Ernest Mwasongwe <<a \
href="mailto:smwasongwe@GMAIL.COM" target="_blank">smwasongwe@GMAIL.COM</a>> \
wrote:</div><br><div><div dir="ltr"><div style="font-family:georgia,serif">Hi \
all,</div><div style="font-family:georgia,serif"><br></div><div \
style="font-family:georgia,serif">At my office we're migrating to SAS enterprise, \
I run the following line code I used to SAS 9.4 but it does not give me access to the \
file</div><p class="gmail_default" style="font-family:georgia,serif"><font \
color="#0000ff" size="3">X</font><font size="3"><font size="3"> </font></font><font \
color="#800080" size="3">'cd \
<a>\\ntummc\datashares\dept\SC\Working\Stanford\Datareq\Jh1477\Robert</a> \
Olivo\P0616\3-final deliverables'</font><font size="3">;</font></p><div \
style="font-family:georgia,serif">the above line works ok, however, if I use the \
following code</div><font color="#008000" size="3"><font color="#008000" \
size="3"><font color="#008000" size="3"><p class="gmail_default" \
style="font-family:georgia,serif">*Assign project \
directory;</p></font></font></font><div style="font-family:georgia,serif"><font \
color="#008000" size="3"> </font><font color="#0000ff" size="3"><font color="#0000ff" \
size="3"></font></font></div><p class="gmail_default" \
style="font-family:georgia,serif"><font color="#0000ff" size="3">X</font><font \
size="3"><font size="3"> </font></font><font color="#800080" size="3">'cd \
<a>\\ntummc\datashares\dept\SC\Working\Stanford\Datareq\Jh1477\Robert</a> \
Olivo\P0616'</font><font size="3">;</font></p><div \
style="font-family:georgia,serif"><font size="3"> </font></div><p \
class="gmail_default" style="font-family:georgia,serif"><font size="3"> </font><font \
color="#0000ff" size="3">libname</font><font size="3"> te1 </font><font \
color="#800080" size="3">'3-final deliverables'</font><font \
size="3">;</font></p><div style="font-family:georgia,serif">I am getting a message on \
log that library te1 does not exist, any idea why, thanks</div><div \
style="font-family:georgia,serif"><br clear="all"></div><div><div><div \
dir="ltr"><div><span style="font-size:x-small"><font size="2"><font><span \
style="font-size:10pt"><font \
color="#444444"><b>Stanford</b></font></span></font></font></span></div><div><font \
style="font-size:10pt"><b>__________________________________________________________________________________</b> \
</font><font color="#0000ff" style="font-size:10pt"> </font></div><font><font><div \
style="font-size:10pt"><font><b>Stanford Mwasongwe, MPH</b></font></div><div \
style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Epidemiologist</font></span></div><div \
style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Jackson Heart Study- \
Field Center</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>Office of Surveillance \
& Epidemiology</font></span></div><div style="font-size:10pt"><span \
style="font-family:verdana,sans-serif;font-size:10pt"><font>350 West Woodrow Wilson \
Ave., Suite 701</font></span></div><div style="font-size:10pt">
<span style="font-size:10pt"><font>Jackson, Mississippi \
39213-4505</font></span><br></div><div style="font-size:10pt"><font size="1"><span \
style="font-size:7.5pt"><span style="font-size:x-small"><font>Email</font><font \
color="#0000ff">: </font><a style="color:blue" href="mailto:smwasongwe@gmail.com" \
target="_blank">smwasongwe@gmail.com</a></span></span></font></div><div \
style="color:blue;font-size:10pt"><font size="1">LinkedIn Page:</font><font size="1"> \
</font><font color="#0000ff" size="1"><a \
href="http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/" \
target="_blank">http://www.linkedin.com/pub/stanford-ernest-mwasongwe/27/2a0/861/</a></font><br></div></font></font></div></div></div>
</div>
</div></blockquote></div><br></div></div></div></div></blockquote></div><br></div></div>
</div></blockquote></div><br></div></div></div></div></blockquote></div><br></div>
</div></blockquote></div></div></div></blockquote></div><br></div></div></div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic