f



Re: old SAS guy with new SAS question #3

On Sun, 16 Nov 2008 20:33:21 -0800, Daniel Nordlund
<djnordlund@VERIZON.NET> wrote:

>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
>> Behalf Of John F. Regus
>> Sent: Sunday, November 16, 2008 7:19 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: old SAS guy with new SAS question
>>
>> You three were of the most help to an old man in simplifying
>> how to get output from my PC file into a SAS dataset.
>> However, when I did use the INPUT statement I coded INPUT  $.
>>  thinking this would put everything into its natural place in
>> the output SAS table.  Wrong.  It only got the first variable
>> of 5 characters.
>>
>> I went through my "Little SAS Book" trying to find the answer
>> to this but the "Little SAS Book" has an appropriate
>> title...it is little and does not cover a lot of things.
>> SAS help and documentation takes you over the hills and
>> through the woods without getting to the point or even a
>> concise answer.
>>
>> Here is my problem.
>>
>> I am reading a .csv PC flat file (I conquered the problem of
>> reading the PC file into a SAS dataset by adding the INPUT
>> statement...only not all the data goes through because I need
>> to use columnar input instead of list input).
>>
>> The layout of the .csv PC flat file is somewhat like this,
>> with the variable lengths inside each table entry looks
>> something like this:
>>
>>                VAR1    VAR2     VAR3    VAR4    VAR5 etc.,etc.
>>
>> Row1      5$           1$         1$          8$          6$
>>
>> Row2      5$           2$         1$        18$          6$
>>
>> Row3      5$           4$         1$         10$         6$
>>
>> Row4      5$           4$         1$           6$         6$
>>
>> Row5      5$           3$         1$           9$         6$
>>
>> Row6      5$           1$         1$          12$        6$
>>  ...and so on.
>>
>> Obviously, it is impossible to count each row of the .csv
>> file and find the variables with varying lengths and then
>> code an INPUT statement at exactly the number of rows the
>> variables with the varying lengths were found in the PC file.
>>  In my PC file, their are 72000+ lines of data (one month's
>> worth of Demantech's NTSMF performance data).  So how do I
>> code a DATA step that figures out there are variable length
>> variables scattered throughout the PC flat file so that I can
>> come back and code another DATA step  with names for the
>> COLUMNS where all of the data resides?
>>
>> Any and all help would be appreciated, and I will try
>> everything you say.

<snipped>

>data want;
>  length row var1-var5 $20;
>  infile "c:\temp\variable_length_data.txt" ;
>  input ROW VAR1  VAR2  VAR3 VAR4 VAR5;
>run;

Hmm,

  I am not quite following, but have a suggestion anyway :)

infile "c:\temp\variable_length_data.txt" DSD Delimiter = "2c"x LRECL =
2000 ;

  The changes are DSD (delimiter-separated data?), specification of the
delimiter (comma), and increasing the default logical record length.  I
assume that records that have incomplete data at their terminus still have
commas.  Otherwise, you may need to look at other options (truncover,
missover, etcera).

HTH,

Kevin
0
citam.sasl (448)
11/17/2008 8:57:59 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
867 Views

Similar Articles

[PageSpeed] 37

Reply:

Similar Artilces:

Re: old SAS guy with new SAS question
> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of John F. Regus > Sent: Sunday, November 16, 2008 7:19 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: old SAS guy with new SAS question > > You three were of the most help to an old man in simplifying > how to get output from my PC file into a SAS dataset. > However, when I did use the INPUT statement I coded INPUT $. > thinking this would put everything into its natural place in > the output SAS table. Wrong. It only got the first variable > of 5 characters. > > I went through my "Little SAS Book" trying to find the answer > to this but the "Little SAS Book" has an appropriate > title...it is little and does not cover a lot of things. > SAS help and documentation takes you over the hills and > through the woods without getting to the point or even a > concise answer. > > Here is my problem. > > I am reading a .csv PC flat file (I conquered the problem of > reading the PC file into a SAS dataset by adding the INPUT > statement...only not all the data goes through because I need > to use columnar input instead of list input). > > The layout of the .csv PC flat file is somewhat like this, > with the variable lengths inside each table entry looks > something like this: > > VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. > > Row1 5$ ...

Re: old SAS guy with new SAS question #2
On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need to use columnar input instead of list input). > >The layout of the .csv PC flat file is somewhat like this, with the variable lengths inside each table entry looks something like this: > > VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. > >Row1 5$ 1$ 1$ 8$ 6$ > >Row2 5$ 2$ 1$ 18$ 6$ > >Row3 5$ 4$ 1$ 10$ 6$ > >Row4 5$ 4$ 1$ 6$ ...

Re: old SAS guy with new SAS question #4
John, I think Ron Fehd was working on recreating MXG on the PC, though I'm not sure what he's using for input (I'm guessing they're all OS and monitoring tool specific). You might want to email him off-list to see what he's doing. But I think the couple of responses you've gotten so far should get you over the initial hump of reading in varying length variables. Let us know where we can help next--there are several of us on the listserv that either do MXG or lived and breathed MXG in the past. HTH, CH On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need...

Re: old SAS guy with new SAS question #5
On Sun, 16 Nov 2008 21:18:36 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >You three were of the most help to an old man in simplifying how to get output from my PC file into a SAS dataset. However, when I did use the INPUT statement I coded INPUT $. thinking this would put everything into its natural place in the output SAS table. Wrong. It only got the first variable of 5 characters. > >I went through my "Little SAS Book" trying to find the answer to this but the "Little SAS Book" has an appropriate title...it is little and does not cover a lot of things. SAS help and documentation takes you over the hills and through the woods without getting to the point or even a concise answer. > >Here is my problem. > >I am reading a .csv PC flat file (I conquered the problem of reading the PC file into a SAS dataset by adding the INPUT statement...only not all the data goes through because I need to use columnar input instead of list input). > >The layout of the .csv PC flat file is somewhat like this, with the variable lengths inside each table entry looks something like this: > > VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. > >Row1 5$ 1$ 1$ 8$ 6$ > >Row2 5$ 2$ 1$ 18$ 6$ > >Row3 5$ 4$ 1$ 10$ 6$ > >Row4 5$ 4$ 1$ 6$ ...

old SAS guy with new SAS question
You three were of the most help to an old man in simplifying how to get = output from my PC file into a SAS dataset. However, when I did use the = INPUT statement I coded INPUT $. thinking this would put everything = into its natural place in the output SAS table. Wrong. It only got the = first variable of 5 characters. I went through my "Little SAS Book" trying to find the answer to this = but the "Little SAS Book" has an appropriate title...it is little and = does not cover a lot of things. SAS help and documentation takes you = over the hills and through the woods without getting to the point or = even a concise answer. Here is my problem. I am reading a .csv PC flat file (I conquered the problem of reading the = PC file into a SAS dataset by adding the INPUT statement...only not all = the data goes through because I need to use columnar input instead of = list input). The layout of the .csv PC flat file is somewhat like this, with the = variable lengths inside each table entry looks something like this: VAR1 VAR2 VAR3 VAR4 VAR5 etc.,etc. Row1 5$ 1$ 1$ 8$ 6$ =20 Row2 5$ 2$ 1$ 18$ 6$ Row3 5$ 4$ 1$ 10$ 6$ Row4 5$ 4$ 1$ 6$ 6$ Row5 5$ 3$ 1$ 9$ 6$ Row6 5$ 1$ 1$ 12$ 6$ ...a...

Re: Old SAS Guy needs help with some of these new fangled SAS
Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sleepless afternoons. > >I know that I can import just about any file imaginable into SAS using the import function using SAS Windows 9.1.3. >However, when trying to get comma seperated values moved all at once into the new SAS file, >I can (or only know how to get) the data for one variable moved at a time. I would like to do a mass >move of all the data from the input file into the new SAS file. Is there a way to do this? Because once > I have imported the file into a new SAS file, established variable names, established formats, informats, >variable lengths, etc. I would like to be able to save the settings for the next like file that I want to import into what I have >already slaved over doing, defining, etc., without repeating the process. > >Is there a way to do this? > >Waiting with bad breath on the sidelines. > >The Old SYS/390 guy >"SAS was originally invented for computer performance and capacity planning for the SYS/3x0 IBM machines... >they sure have taken it into new features that are amazing&...

Re: Old SAS Guy needs help with some of these new fangled SAS #2
It's been a while since I used the Import Wizard but as I recall, there is a window which asks for a file name where SAS can store the input statments for your future use. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Jim Groeneveld <jim.1stat@YAHOO. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Old SAS Guy needs help with some of these new fangled SAS 12/02/2008 04:49 9.1.3 gizmos for Windows AM Please respond to Jim Groeneveld <jim.1stat@YAHOO. COM> Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sl...

Old SAS Guy needs help with some of these new fangled SAS 9.1.3
Greetings all who have helped me in the past. Here is something that has been bothering me unending and is causing me = sleepless afternoons. =20 I know that I can import just about any file imaginable into SAS using = the import function using SAS Windows 9.1.3. =20 However, when trying to get comma seperated values moved all at once = into the new SAS file, I can (or only know how to get) the data for one variable moved at a = time. I would like to do a mass=20 move of all the data from the input file into the new SAS file. Is = there a way to do this? Because once I have imported the file into a new SAS file, established variable = names, established formats, informats, variable lengths, etc. I would like to be able to save the settings for = the next like file that I want to import into what I have already slaved over doing, defining, etc., without repeating the = process. Is there a way to do this? Waiting with bad breath on the sidelines. The Old SYS/390 guy "SAS was originally invented for computer performance and capacity = planning for the SYS/3x0 IBM machines... they sure have taken it into new features that are amazing" I'm not sure I understand your question but it sounds like you're importing data using an wizard and you want to do it using command syntax. See http://www.ats.ucla.edu/stat/sas/faq/default.htm, I think that can help you. (Maybe http://www.listerine.com/ could help as well?) Good luck, John Hendrickx Statistician Cl...

Re: New old SAS guy needs help #3
Indeed, an input statement is needed to define the variables: data smf1; INFILE datalines DLM=',' DSD truncover; input var1 var2 var3 var4 var5 ... etc. datalines; (your datalines) run; -Joe On Thu, Nov 13, 2008 at 9:18 PM, Howard Schreier <hs AT dc-sug DOT org> < schreier.junk.mail@gmail.com> wrote: > You created data sets, but with nothing in them. You need INPUT statements. > > On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> > wrote: > > >Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > > >I used to use SAS 20 years ago. I have apparently forgetten everything. > > > >This is the log. > >4066 data smf1; > >4067 INFILE datalines DLM=',' DSD truncover; > > > >4068 datalines; > > > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > > >NOTE: DATA statement used (Total process time): > > > >real time 0.03 seconds > > > >cpu time 0.00 seconds > > > >6097 run; > > > >This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > > >SAS LOG > > > >NOTE: SAS 9.1.3 Service Pack 4 >...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #3
Wow, that was a leap. Better not use Apache or PHP then. Andy >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On >Behalf Of ben.powell@CLA.CO.UK >Sent: Thursday, February 05, 2004 10:37 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) > >Sounds like R is the SAS equivalent of Linux .. who are >incidentally in all >sorts of a copy left/right mess at the moment. > >On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: > >>I use both SAS a...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54 ...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #3
First, let me admit/acknowledge that I have no knowledge of the history of this thread. Been tied up catching up post SAS Global Forum and post the announcement of sasCommunity.org. But I would like to offer some thoughts regarding Toby's comment: > No as for the sascommunity.org, do we really want a macro library. Well I > would say yes and no. I would like to have one and there are those who > have > paced some Macros on there already. I believe Don and Ron both have, > actually they were on there before the Wiki went public. However, since > people tend to get Ma...

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: SAS code beautifier or SAS Tidy #3
Yes indeed. I gave Alan the worst code (authors shall remain anonymous to protect the guilty, but the project involved Mortgage Banking services...) I have seen in over two decade of looking at SAS code, and his utility cleaned it right up. On Wed, Jun 10, 2009 at 4:30 PM, Richard Read Allen <peakstat@wispertel.net>wrote: > Try www.savian.net. I think Alan Churchill may have developed some > utilities > that may be able to help you. > > -Richard > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mary > Sent: ...

Re: Deleting SAS Data from a SAS DATASET #3
The disadvantages of using SQL delete are (1) NOBS= is no longer accurate, and (2) POINT= may behave unexpectedly. If those are not issues, then the delete would be faster, with or without an index, than recreating the data set (especially if the data set has indexes that would need to be rebuilt). -- Jack Hamilton jfh@alumni.stanford.org On Aug 15, 2008, at 11:17 am, Mary wrote: > One thing you might do is to add an index on the snap_dt to the > dataset; if that's there then you should be able to delete the > records in place: > > proc sql; > delete from prod.master_date; > where snap_dt = "&end_dt"d; > quit; > run; > > In both the ways you are trying now you are creating new data sets > rather than deleting records from the current data set; it would > seem to me that a SQL delete statement would be faster than creating > new datasets even if there isn't an index on the date. > > -Mary > ----- Original Message ----- > From: SUBSCRIBE SAS-L Chandra Gadde > To: SAS-L@LISTSERV.UGA.EDU > Sent: Friday, August 15, 2008 12:14 PM > Subject: Deleting SAS Data from a SAS DATASET > > > Hi All > > I have several SAS datasets that are very very big. (50GB of size). > Every > month, the data is being appended to these datasets. I need to > deleted the > data which is greater than 24 months. What is the best method to do > this? > Please help me. > ...

Re: SAS vs. SPLUS vs. SAS #3
I don't know much about trials work, but it has been discussed on the r-help list, and there are definitely people who use R for this type of thing Peter -----Original Message----- >From: Paul Miller <pjmiller_57@YAHOO.COM> >Sent: Dec 11, 2009 4:09 PM >To: SAS-L@LISTSERV.UGA.EDU >Subject: SAS vs. SPLUS vs. SAS > >Hello Everyone, >� >I’ve recently become interested in sequential clinical trials designs. I’ve purchased a book that discusses the topic called “Analysis of Clinical Trials using SAS: A Practical Guide.” Upon trying to run some of the ...

Re: Invoking SAS from non SAS environment! #3
Ankit, If performance is an issue then definitely go with a web service based approach. Web services offer synchronous and asynchronous communication. Since web services communicate over port 80, they are secure and they are as fast as your internet connection. Using older stuff such as ftp and telnet are going to be slower not to mention a lot more cumbersome. Also, going down these older paths can work but it will be a hacked up solution and may not be supported by the IT dept over time? Why? Open ports outside of 80 are security issues. Hence, why web services are so important. However, i...

Re: New old SAS guy needs help
You created data sets, but with nothing in them. You need INPUT statements. On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. > >I used to use SAS 20 years ago. I have apparently forgetten everything. > >This is the log. >4066 data smf1; >4067 INFILE datalines DLM=',' DSD truncover; > >4068 datalines; > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.03 seconds > >cpu time 0.00 seconds > >6097 run; > >This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails > >SAS LOG > >NOTE: SAS 9.1.3 Service Pack 4 > >NOTE: SAS initialization used: > >real time 1.15 seconds > >cpu time 0.70 seconds > >1 Filename Smfdata 'c:\ntsmf24'; > >2 data 'smf1'; > >3 INFILE datalines DLM=',' DSD truncover; > >4 datalines; > >NOTE: The data set smf1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.01 seconds > >cpu time 0.01 seconds > >2033 run; > >2034 data &#...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the lan...

Re: New old SAS guy needs help #5
I typically use INFILE when I am reading from an external file. So, I would not have a datalines statement. What you need is an input line with the variables names. The datalines is a keyword to let SAS know that the data are to be read in the subsequent lines, but if you're reading from an input file, you won't be entering data from the editor window. Warren Schlechte -----Original Message----- From: John F. Regus [mailto:jfregus@IX.NETCOM.COM] Sent: Thursday, November 13, 2008 9:00 PM Subject: New old SAS guy needs help Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. I used to use SAS 20 years ago. I have apparently forgetten everything. This is the log. 4066 data smf1; 4067 INFILE datalines DLM=',' DSD truncover; 4068 datalines; NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 6097 run; This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails SAS LOG NOTE: SAS 9.1.3 Service Pack 4 NOTE: SAS initialization used: real time 1.15 seconds cpu time 0.70 seconds 1 Filename Smfdata 'c:\ntsmf24'; 2 data 'smf1'; 3 INFILE datalines DLM=',' DSD truncover; 4 datalines; NOTE: T...

Re: New old SAS guy needs help #2
John, I'm sure you have provided sufficient information so that you will get a solution from one or more of the sharper tacks on SAS-L. But what want to know is what happened in 1988 that made SAS drop out of sight? Joe On Thu, Nov 13, 2008 at 10:00 PM, John F. Regus <jfregus@ix.netcom.com>wrote: > Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > I used to use SAS 20 years ago. I have apparently forgetten everything. > > This is the log. > 4066 data smf1; > 4067 INFILE datalines DLM=',' DSD truncover; > > 4068 datalines; > > NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > NOTE: DATA statement used (Total process time): > > real time 0.03 seconds > > cpu time 0.00 seconds > > 6097 run; > > This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > SAS LOG > > NOTE: SAS 9.1.3 Service Pack 4 > > NOTE: SAS initialization used: > > real time 1.15 seconds > > cpu time 0.70 seconds > > 1 Filename Smfdata 'c:\ntsmf24'; > > 2 data 'smf1'; > > 3 INFILE datalines DLM=',' DSD truncover; > > 4 datalines; > > NOTE: The data set smf1 has 1 obser...

Re: SAS AF application is not supported in SAS EG? #3
Then you might not know what fun you're missing :)) On Wed, Oct 28, 2009 at 7:50 PM, Savian <savian.net@gmail.com> wrote: > On Oct 28, 11:41 am, UKR <nlk...@gmail.com> wrote: > > Thank you for your comments. > > I will investigate Silverlight and oleDB technologies as well as costs > > associated with keeping single SAS PC license. > > In any case how SAS Institute could abandon AF so easily, if favor to > > which kind of technology? What solutions does SAS Institute provide to > > support GUI programs on windows server? Does anybody ha...

Re: SAS Intrnet question, passing macro variables to SAS.
Jia, You have to mask tokens that appear in pairs. In your example precede the single quote (') with a % sign. Try: &libdata=test&citystate=%str(%'Birmingham, AL%',%'Dothan, AL%',%'Huntsville,AL%') Nikhil Sardesai -----Original Message----- From: Michael L. Davis [mailto:michael@BASSETTCONSULTING.COM] Sent: Friday, January 28, 2005 5:13 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: [SAS-L] SAS Intrnet question, passing macro variables to SAS. Hello Jia and other SAS-L Friends, I'm not sure I know the answer but I have some ideas. However, first, I have a question. Are you building the URL outside of an HTML form? If you are, the following link on the SAS web site might interest you: http://support.sas.com/faq/039/FAQ03925.html You might also want to look at the following link: http://support.sas.com/rnd/web/intrnet/dispatch82/input.html Look at the section titled "Specifying Name/Value Pairs in a URL". Most likely, the ampersands might be playing a role. SAS/IntrNet strips off "unsafe characters" unless you tell it not to do so. Please see: http://support.sas.com/rnd/web/intrnet/dispatch82/srvusaf.html Part of that link states: The APPSRV_UNSAFE function returns the complete, original value of an input name/value pair. Normally unsafe characters (see the UNSAFE option) are stripped from input values before creating the input macro variables. This is done so that macro variables may be freely used in a a...

Re: New old SAS guy needs help #7
I doubt it, I use double quotes except when I need to prevent macro variable resolution but they are identical otherwise. -Joe On Fri, Nov 14, 2008 at 10:14 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > Thanks Joe...I noticed you put your PC file name in double quotes, I only > had mine in single quotes...was that the reason the file was not found? > ----- Original Message ----- From: "Joe Matise" <snoopy369@GMAIL.COM> > To: <SAS-L@LISTSERV.UGA.EDU> > Sent: Friday, November 14, 2008 9:07 AM > > Subject: Re: New old SAS guy needs help > > > You don't have to specify the length in the input statement; using DLM >> takes >> care of that. Just make sure they are defined as long enough ahead of >> time >> for the longest possible string. var1 $ var2 var3 var4 $ will read in >> four >> variables, first and last as strings, and with whatever length is >> appropriate up to the max length those variables are predefined as ($200. >> for characters, 8 bytes for numerics, by default I think). >> >> No idea why you would get a file not found error ... did you put the >> filename in quotes? >> >> infile "c:\testfile.dat" dlm=',' lrecl=800 pad; >> >> should be the statement... test it with a file on a local drive that has a >> simple name to make sure you have the syntax down, I'd say (and perhaps >&g...

Web resources about - Re: old SAS guy with new SAS question #3 - comp.soft-sys.sas

West Lothian question - Wikipedia, the free encyclopedia
He illustrated his point by pointing out the absurdity of a Member of Parliament for West Lothian being able to vote on matters affecting the ...

NDP MP Niki Ashton Gives Master Class In Dodging Questions About Mulcair 0
"We have a lot of work ahead of us, and the leadership review is part of that." The hardest-hitting questions for NDP MPs lately have nothing ...

Lawyers Question JWT Investigation, Seek to Submit Video Evidence
Lawyers for Erin Johnson, who filed a suit in New York last week against JWT and its Chairman-CEO Gustavo Martinez over alleged racist and sexist ...

Question of the Day: Greatest hood ornament of all time?
Filed under: Etc. , Automotive History From leaping carnivores to flying princesses, the automotive world has produced some great hood ornaments. ...

Alphabet: Morgan Stanley Has Five Questions for Their Cloud Conference
Morgan Stanley‘s Brian Nowak today reiterates an Overweight rating on shares of Alphabet (GOOGL), arguing the company’s cloud computing service ...

On "Face the Nation" today, John Dickerson asked Donald Trump a question about law that I — being in ...
From the transcript: DICKERSON: At the debate, you talked about H-1B visas. You said: "It's something I, frankly, use, and I shouldn't be allowed ...

What's the top Google search question about Donald Trump?
Google is tracking the top trending questions about the presidential candidates on the search engine in Florida and Ohio Tuesday

10 questions to ask analytics vendors (before you buy)
Analytics purchase decisions are littered with opportunities for missteps. These 10 questions will help ensure you get off on the right foot. ...

Activists question United CEO's role, pay
Two hedge funds that launched a boardroom fight with United oppose plans to give its CEO the role of chairman and have concerns about his pay. ...

Hearing on Visa Overstays Yields More Questions Than Answers
With 523,000 visa overstays a year, why can't the federal government do a better job of tracking people who don't leave the country when their ...

Resources last updated: 3/16/2016 4:12:15 PM