f



Re: Need help with SAS Data step #4

Thank you all for being so nice and helpful. Have a good one. -Mehdi

On Mon, Jun 23, 2008 at 9:29 AM, Gerhard Hellriegel <
gerhard.hellriegel@t-online.de> wrote:

> in SAS you can get all which has a structure, following certain rules. A
> simple rule is: all data-fields are seperated by a delimiter.
> That seems to be not the case at your data. Ok, also that data must have a
> certain structure, if you are able to read it and understand it. So the
> easiest way might be to ask, "how do I understand that data?" "Which rules
> do I follow?".
> Ok, one of that rules might be: I know that the country is the first word.
> That after the country up to the first number is the capital. That are
> rules you could implement in SAS.
> If it is more complicated, e.g. there are also countries like 'Sri Lanca'
> you might have a list with all that countries (like that in your head -
> something in your brain must tell you, that the country is not Sri and the
> capital is not Lanca) to get them.
> Gerhard
>
>
>
>
> On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote:
>
> >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote:
> >> Hello,
> >>
> >> I'm a new SAS learner. I become interested in SAS when I took a
> >> Biostatistics class. Then I took a SAS/Stat class and learned how to
> SAS for
> >> statistical data analyses. Basically I'm a spinal cord injured graduate
> >> student in computer science. After taking that SAS class I started
> learning
> >> SAS and planning to develop my career in SAS programming. Because other
> >> computer programming languages involve writing many many lines of
> codes. For
> >> my physical limitation I find SAS needs only few lines of codes and
> makes my
> >> life little easier.
> >>
> >> Anyway, I'm always having trouble reading data at SAS data step using
> >> 'INPUT' statement. I fail to read character variables with embedded
> spaces.
> >> Here is a part of a data set I was using to practice SAS;
> >>
> >> *data* country;
> >>
> >>           input Name : $19. Capital $ Population Area Continent $
> UNDate;
> >>
> >>           datalines;
> >>
> >>           Afghanistan Kabul 17070323 251825 Asia 1946
> >>
> >>           Albania Tirane 3407400 11100 Europe 1955
> >>
> >>           Algeria Algiers 28171132 919595 Africa 1962
> >>
> >>           Andorra Andorra la Vell 64634 200 Europe 1993
> >>
> >>           Angola Luanda 9901050 481300 Africa 1976
> >>
> >>           Antigua and Barbuda St. John's 65644 171 Central America 1981
> >>
> >>           Argentina Buenos Aires 34248705 1073518 South America 1945
> >>
> >>           Armenia Yerevan 3556864 11500 Asia 1992
> >>
> >>           Australia Canberra 18255944 2966200 Australia 1945
> >>
> >>           Austria Vienna 8033746 32400 Europe 1955
> >>
> >>           Azerbaijan Baku 7760064 33400 Asia 1992
> >>
> >>           Bahamas Nassau 275703 5400 Central America 1973
> >>
> >>           Bahrain Manama 591800 300 Asia 1971
> >>
> >>           Bangladesh Dhaka 1.2639E8 57300 Asia 1974
> >>
> >>           Barbados Bridgetown 258534 200 Central America 1966
> >>
> >>           ;;;;
> >>
> >> Would anyone be kind enough to teach me how to write input statement for
> >> this kind of data set with embedded spaces and quotes. I would
> appreciate
> >> that.
> >
> >SAS supports several styles of input, but they all depend on the data
> >following one or another set of rules.  What you're asking for doesn't
> >look possible to me - as someone else noted, if you can't change the
> >data lines to agree with something SAS supports, it would seem your
> >only choice is to read in the whole line and use logic to tease out
> >the values of your variables.
> >
> >However, looking beyond this particular case - if you're looking
> >forward to a career that involves heavy involvement with SAS
> >programming, there's no substitute for learning SAS.  People here are
> >often glad to help with suggestions and code snippets, but the
> >majority of the effort has to come from you.  I STRONGLY suggest that
> >as a minimum you read the documentation for SAS/BASE more or less
> >start to finish, besides using it to look up answers to questions such
> >as you pose above.  Don't stress about the sheer volume of material -
> >if you spend even half and hour a day (over lunch maybe) it will pay
> >you back manyfold for decades.  If your place of work doesn't have
> >paper copies of the documentation, you can access it online at
> >http://support.sas.com/onlinedoc/913/docMainpage.jsp
>
0
6/23/2008 7:42:46 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
411 Views

Similar Articles

[PageSpeed] 40

Reply:

Similar Artilces:

Re: Need help with SAS Data step
Mehdi, There is no way for SAS to know when the variables begin and end if the data is both free-form and lacks a delimiter. Prior to reading the file into SAS, is it possible to save the file in some type of delimited format, e.g. comma or tab, or fixed form? What is the original source / file type of your data? If you have no way of changing your data prior to reading it into SAS, it seems you would have to read the entire observation into a single variable and then use logic to parse the data. Regards, Scott -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mehdi Satter Sent: Saturday, June 21, 2008 5:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Need help with SAS Data step Hello, I'm a new SAS learner. I become interested in SAS when I took a Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for statistical data analyses. Basically I'm a spinal cord injured graduate student in computer science. After taking that SAS class I started learning SAS and planning to develop my career in SAS programming. Because other computer programming languages involve writing many many lines of codes. For my physical limitation I find SAS needs only few lines of codes and makes my life little easier. Anyway, I'm always having trouble reading data at SAS data step using 'INPUT' statement. I fail to read character variables with embedded spaces. Here is a part of a data set I was using to practice SA...

Re: Need help with SAS Data step #5
Summary: Make guesses and add information to check work. #iw-value=1 Mehdi, As a computer science student you must be aware that any field has to be defined in some way if one is to have an automated way to read the fields. Let's look at your worst case. > Antigua and Barbuda St. John's 65644 171 Central America 1981 Where does country end and capital begin? An English speaking human might say, "Well, the word 'and' cannot begin a capital name." You could of course build this feature into your program, but then there are probably some other examples with other words. As a computer science student you are probably aware of regular expressions, so you might take a look at the PRX functions and try to parse each line into separate fields. This probably would have the biggest payoff in your career, but since you are a beginning SAS student I have chosen to show you some of the more traditional SAS tricks. First we observe that it is easy to recognize the three number fields. The rest follows by assuming that a country name is usually one word. You will have to look up features in on line documentation or the help facility. Hopefully the comments are enough to follow the code below. You might copy it and then try executing it. data country ( drop = rest x ) check ; /* assumptions name - first word captal - everthing up to numbers population - first number area - second number ...

Re: Need help with SAS Data step #2
On Sat, 21 Jun 2008 16:23:07 -0500, Mehdi Satter <mehdisatter@GMAIL.COM> wrote: >Hello, > >I'm a new SAS learner. I become interested in SAS when I took a >Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for >statistical data analyses. Basically I'm a spinal cord injured graduate >student in computer science. After taking that SAS class I started learning >SAS and planning to develop my career in SAS programming. Because other >computer programming languages involve writing many many lines of codes. For >my physical limitation I find SAS needs only few lines of codes and makes my >life little easier. > >Anyway, I'm always having trouble reading data at SAS data step using >'INPUT' statement. I fail to read character variables with embedded spaces. >Here is a part of a data set I was using to practice SAS; > >*data* country; > > input Name : $19. Capital $ Population Area Continent $ UNDate; > > datalines; > > Afghanistan Kabul 17070323 251825 Asia 1946 > > Albania Tirane 3407400 11100 Europe 1955 > > Algeria Algiers 28171132 919595 Africa 1962 > > Andorra Andorra la Vell 64634 200 Europe 1993 > > Angola Luanda 9901050 481300 Africa 1976 > > Antigua and Barbuda St. John's 65644 171 Central America 1981 > > Argentina Buenos Aires 34248705 1073...

Re: Need help with SAS Data step #3
in SAS you can get all which has a structure, following certain rules. A simple rule is: all data-fields are seperated by a delimiter. That seems to be not the case at your data. Ok, also that data must have a certain structure, if you are able to read it and understand it. So the easiest way might be to ask, "how do I understand that data?" "Which rules do I follow?". Ok, one of that rules might be: I know that the country is the first word. That after the country up to the first number is the capital. That are rules you could implement in SAS. If it is more complicated, e.g. there are also countries like 'Sri Lanca' you might have a list with all that countries (like that in your head - something in your brain must tell you, that the country is not Sri and the capital is not Lanca) to get them. Gerhard On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote: >> Hello, >> >> I'm a new SAS learner. I become interested in SAS when I took a >> Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for >> statistical data analyses. Basically I'm a spinal cord injured graduate >> student in computer science. After taking that SAS class I started learning >> SAS and planning to develop my career in SAS programming. Because other >> computer programming languages involve writing many many lin...

Re: How to filter sas data sets into separate sas data sets #4
Something like this is the old way. You could use a proc sql if you have a new enough version. Increase your buffersize and if you have enough memory you may get it into a hash routine. DATA WORK.NEW; MERGE small (IN=A OBS=500) big ; BY ID_FIELD; IF A=1; RUN; QUIT; RICH -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@listserv.vt.edu] On Behalf Of Lizette Koehler Sent: Monday, April 02, 2007 10:53 AM To: SAS-L@LISTSERV.VT.EDU Subject: How to filter sas data sets into separate sas data sets Listers, This is my failing point in coding SAS. T...

Re: Deleting SAS Data from a SAS DATASET #4
Summary: PROC DATASETS; AGE statement. + VIEWs This won't help you delete data from your very big data set, but you may find this example interesting. You say you append data monthly to a big data set then when big gets too big you need to clean out the old. And that takes a very long time. However if you don't physically append but use a view to append/combine you may find it easier to get rid of the unwanted old data. Consider this code. it pushes MonthlyUpdate onto the stack of 24 data sets and the 24th data set is deleted. Then all the data sets get renamed to produce a new group of 24. You can see from the notes how the operation works. The data sets don't have to use a numbered range M01-M24 I did that for my convenience. proc datasets library=work; age MonthlyUpdate m01-m24; run; quit; NOTE: Deleting WORK.M24 (memtype=DATA). NOTE: Aging the name WORK.M23 to WORK.M24 (memtype=DATA). NOTE: Aging the name WORK.M22 to WORK.M23 (memtype=DATA). NOTE: Aging the name WORK.M21 to WORK.M22 (memtype=DATA). NOTE: Aging the name WORK.M20 to WORK.M21 (memtype=DATA). NOTE: Aging the name WORK.M19 to WORK.M20 (memtype=DATA). NOTE: Aging the name WORK.M18 to WORK.M19 (memtype=DATA). NOTE: Aging the name WORK.M17 to WORK.M18 (memtype=DATA). NOTE: Aging the name WORK.M16 to WORK.M17 (memtype=DATA). NOTE: Aging the name WORK.M15 to WORK.M16 (memtype=DATA). NOTE: Aging the name WORK.M14 to WORK.M15 (memtype=DATA). NOTE: Aging the name WORK.M13 to WORK.M14 (me...

Need help with SAS Data step
Hello, I'm a new SAS learner. I become interested in SAS when I took a Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for statistical data analyses. Basically I'm a spinal cord injured graduate student in computer science. After taking that SAS class I started learning SAS and planning to develop my career in SAS programming. Because other computer programming languages involve writing many many lines of codes. For my physical limitation I find SAS needs only few lines of codes and makes my life little easier. Anyway, I'm always having trouble reading data at SAS data step using 'INPUT' statement. I fail to read character variables with embedded spaces. Here is a part of a data set I was using to practice SAS; *data* country; input Name : $19. Capital $ Population Area Continent $ UNDate; datalines; Afghanistan Kabul 17070323 251825 Asia 1946 Albania Tirane 3407400 11100 Europe 1955 Algeria Algiers 28171132 919595 Africa 1962 Andorra Andorra la Vell 64634 200 Europe 1993 Angola Luanda 9901050 481300 Africa 1976 Antigua and Barbuda St. John's 65644 171 Central America 1981 Argentina Buenos Aires 34248705 1073518 South America 1945 Armenia Yerevan 3556864 11500 Asia 1992 Australia Canberra 18255944 2966200 Australia 1945 Austria Vienna 8033746 32400 Europe 1955 Azerbaijan Baku 7760064 ...

Re: SAS DATA STEP #4 1551678
Pavlo, Data Wanted ( drop = Count ) ; set Have ; by Id Period ; If first.Id then Count = 0 ; if ( Response ne 0 ) then do ; Count + 1; Flag = Compress('Event' || Count ) ; end ; else do ; Flag = 'NonEvent' ; end ; run ; Toby Dunn From: Pavlo Row <pavlo@INORBIT.COM> Reply-To: Pavlo Row <pavlo@INORBIT.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: SAS DATA STEP Date: Tue, 14 Feb 2006 15:06:26 -0500 Hello, I have bank-related campaigns we executed in year 2005: JAN05, APR05, JUN05, SEP05, and OCT05. A person may (RESPONSE=0) or may not respond (RESPON...

Re: I need help with SAS Macro #4
On Fri, 6 Jun 2008 10:07:47 -0700, Brian <brian8202@GMAIL.COM> wrote: >Hello, > >%Let Start_Month = 200510; >%Let End_Month = 200601; > >I would like to have a macro that I specify the the start month and >end month then it loops through to generate the number of > datasets as specified below. > >LIBNAME D200510 "EEAR.AAA.BBB.XXX.MB200510" DISP=SHR; >LIBNAME D200511 "EEAR.AAA.BBB.XXX.MB200511" DISP=SHR; >LIBNAME D200512 "EEAR.AAA.BBB.XXX.MB200512" DISP=SHR; >LIBNAME D200601 "EEAR.AAA.BBB.XXX.MB200601" DISP=SHR; > > >I tried so many different ways but without any luck. > > >Thanks, > >Brian I believe this meets the specs: %macro wouldlike(Start_Month=, End_Month =); %let lo = %sysfunc(inputn(&Start_Month,yymmn6.)); %let hi = %sysfunc(inputn( &End_Month,yymmn6.)); %let diff = %sysfunc(intck(month,&lo,&hi)); %do i = 0 %to &diff; %let The_Month = %sysfunc(intnx(month,&lo,&i),yymmn6.); LIBNAME D&The_Month "EEAR.AAA.BBB.XXX.MB&The_Month" DISP=SHR; %end; %mend wouldlike; %wouldlike(Start_Month=200510, End_Month =200601) ...

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&...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

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...

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: Optimization/Allocation with SAS Data step #4
sachinjadhav@GMAIL.COM wrote: >Hello All, >I am currently involved in doing an allocation problem and I want to solve >this problem using sas data step instead of using any proc optimisation >step as I don't have SAS/OR software. > >Here is my problem: > >I want to allocate the customers to different locations. >Constraints are 1) Minimum distance > 2) If locations is within close radius then direct the >customer based on profitability of location, so In other words if there are >2 locations within a radius of 5 miles and if location "2" is more >profitable than first "1" , then customer should be directed to the >location "2". >The complication is that for every location there is a threshold level and >the total allocation should fall within threshold level. > >Sample data >ID Location Ditance to Location Location $ >XXX LOC1 2 100 > LOC2 3 50 > LOC3 3.5 120 >YYY LOC1 1.8 30 > LOC2 2.4 100 > LOC3 3.5 300 > LOC4 4.5 3 >and so on... > >I can explain the problem in detail if anyone is interested or have already >solved this kind of problem. >Thanks It look like you have *alrea...

Re: help with reading ASCII data into SAS #4
its not much information about your problem. Did you try it with something like: data a; infile "c:\daten\test.dat" dlm="," truncover; if _n_=1 then do input; delete; end; else input site : 8. id : 8. pid : 8. it : $5. dd : ANYDTDTM20. itd : 8. rtd : 8. linkid : 8. sp : 8. fc : 8. dtc : ANYDTDTM20. dtm : ANYDTDTM20. u : $5. ; u = compress(u,'""'); it = compress(it,'""'); format dtm dtc dd datetime20.; run; That seems to work for your example. Gerhard On Wed, 5 Nov 2008 07:45:07 -0800, olivesecret@GMAIL.COM wrote: >I will appreciate for any suggestions. The data is a txt file. The >first two observations of the data is: > >"=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM"," U" >1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 >=13:10:20,"obd" > >Thanks a lot! ...

Re: NEED HELP
JFCB is not an option in the SET statement. Perhaps, something like this will work... //MYJOB JOB XXXXX,&SYSUID,CLASS=S //STEP00 EXEC SASPROC //IN01 DD DISP=SHR,DSN=AA.BB.CC.FEB04 //IN02 DD DISP=SHR,DSN=AB.BC.DD.FEB04 //IN03 DD DISP=SHR,DSN=CC.CD.AA.FEB04 //IN04 DD DISP=SHR,DSN=AA.BB.CC.MAR04 //IN05 DD DISP=SHR,DSN=CB.BC.DD.MAR04 //SYSIN DD * OPTIONS YEARCUTOFF=1920; DATA SEG1 /VIEW=SEG1; SET IN01.AAA; FILEDATE=INPUT(SUBSTR(PATHNAME('IN01'),10),MONYY5.); RUN; DATA SEG2 /VIEW=SEG2; SET IN02.AAA; FILEDATE=INPUT(SUBSTR(PATHNAME('IN02'...

Re: SAS data step processing question #4
I would couch this answer a little differently and I am focusing on the statement "but unfortunately first.id is created in the by statement" and what this implies. When SAS parses the data step, it creates the Program Data Vector using any variables brought in from data sets mentioned in a set statement and then any variables read in by an input statement or that were created in the data set. If it sees a By statement, it adds the First dot and Last dot variables. Now, as it reads in the lines from sets specified in a SET statement, if assigns values to the First and Last dot variables based on the values of the by variables. If a statement deletes the first observation of a by value BEFORE there is a statement that refers to First dot, then the programmer has shot him or herself in the proverbial foot. You always have to be careful about the order of actions in the data step when doing first and last testing if you have other statements which select or delete obs. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Joe Matise <snoopy369@GMAIL. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> ...

Re: Help needed with some SAS interview questions! #4
Hi,=0A=0AI would really like to know the answers to these questions....=0A1= ) Under what circumstances would you code a SELECT construct instead of IF = statements?=0A=0A2) What is the one statement to set the criteria of data t= hat can be=0Acoded in any step?=0A=0A3)Name statements that function at bot= h compile and execution time.=0A=0A4)How would you combine 3 or more tables= with different structures?=0A=0AThanks,=0ASa Polo=0AOn Sat, 01 Apr 2006 Pa= rdee,Roy wrote :=0A>Number 10 made me laugh. Is the answer "so that I don'= t have to=0A>document my sas programs"?=0...

Re: New old SAS guy needs help #4
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 rename the file and pull it locally if it's on a network drive, to see if that's the problem). -Joe On Fri, Nov 14, 2008 at 1:42 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > Joe thanks. I have two questions though. I did not include my SAS log > when I was trying to get the data from a PC file and kept getting the error > that the PC file could not be found, and yes, I MK-1 eyeballed that file > name backwards and forwards to make sure that it was right, yet I got the > message the PC file could not be found. > The second question is...this SAS program will be used over and over > (hopefully)...and some of the variables are variable length so putting an > INPUT statement in with var1 5 $ var2 4 etc. m...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspecti...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #4
No, sorry if I made it sound that way..... SAS and R are totally different in the way they work, how they are structured, what the statements look like, and so on. Not like French and Spanish, not even like English and Spanish. More like English and Swahilli. R has a lot in common with S Plus, both are based on the S language. But there is no hostility that I know of between S Plus and R (unlike the situation with Linux) Peter >>> <ben.powell@CLA.CO.UK> 2/5/2004 10:36:32 AM >>> wrote Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sort...

Re: New SAS User needs help with format on files and folders #4
Kristi: Not sure that proper quoting will be sufficient to solve your problem.... The 'X' statement executes a command on the OS shell. Is 'Scripts' a subdirectory? If so, you'll want to refer to a specific file name if you have an executable stored under ../Scripts/ Sig -----Original Message----- From: Kristi [mailto:kristith@AOL.COM] Sent: Friday, November 21, 2003 2:08 PM To: SAS-L@LISTSERV.UGA.EDU Subject: New SAS User needs help with format on files and folders Hello everyone .. I am a new user of SAS, and I am trying to execute a script from my hard drive and am h...

Re: Ranges in sas? (was RE: Re: data step vs Proc sql) #2
Ooooh--interesting--thanks! I'll play with that... ________________________________ From: SAS(r) Discussion on behalf of Rickards, Clinton (GE Consumer Finance) Sent: Thu 4/20/2006 2:41 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Ranges in sas? (was RE: Re: data step vs Proc sql) Exactly. the only trick is that the range values must be integers. clint -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Pardee, Roy Sent: Thursday, April 20, 2006 3:57 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Ranges in sas? (was RE: Re: data step vs Proc sql) ...

Re: How to filter sas data sets into separate sas data s ets
I think that both Ron's (as he mentioned) and Richard solutions require that VAR1 is in both datasets. But from the original post, it seemed to me that VAR1 is only in data set 1, and it must be matched to 1 of 3 variables in data set 2 (NODE1, NODE2 or NODE3) to be output to the NEWLIST data set. For this reason, I think a format is one possible approach. Maybe the original poster can clarify this point. Thanks. Jack Clark Research Analyst Center for Health Program Development and Management University of Maryland, Baltimore County -----Original Message----- From: SAS(r) Discussio...

Web resources about - Re: Need help with SAS Data step #4 - comp.soft-sys.sas

North Carolina Deputies Suspended for ‘Failures to Act’ During Trump Rally Violence
A group of sheriff’s deputies in North Carolina have been suspended after a Donald Trump rally where a protester was punched after being escorted ...

Twitch users decided my fate in a VR game built on Amazon Lumberyard
Hidden away on the exhibition floor at the Game Developers Conference in San Francisco today, I found a short line next to the big booth for ...

Apple looks to Google’s Cloud Platform as it diversifies its infrastructure
Rumors are flying today that Apple is moving part of its cloud business from AWS to Google’s Cloud Platform. We did some asking around and yes, ...

Obama slaps new sanctions on North Korea after tests
By Joel Schectman and Yeganeh Torbati WASHINGTON (Reuters) - President Barack Obama imposed sweeping new sanctions on North Korea on Wednesday ...

Black Maryland Cop Killed By Fellow Officer Who Thought He Was Shootout Suspect
Jacai Colson, a Prince George’s County (Mary.) cop, was killed over the weekend by friendly fire during a shootout outside PGC police headquarters. ...

Universal Windows Apps coming to Xbox One this summer
One Windows Platform for every form factor. (credit: Microsoft ) Windows developers will be able to build Universal Windows Platform apps for ...

Hacker who stole celebrities' nude photos will plead guilty
CNET Hacker who stole celebrities' nude photos will plead guilty CNET A hacker who accessed accounts of actress Jennifer Lawrence, pictured ...

5 things we learned from Janet Yellen about Fed rate hikes and the U.S. economy
Federal Reserve policymakers said the U.S. economy is strong enough to handle increases in a key interest rate this year, but they have scaled ...

Driver Accused in Kalamazoo Shooting Spree Files $10 Million Civil Rights Lawsuit Against Uber
On Tuesday, Jason Brian Dalton, the 45-year-old man charged with murdering six people in a shooting spree last month, filed a $10 million federal ...

Amazon patents a technology that lets customers pay by taking a selfie
More so than most, Amazon has every reason to try and make the check out process as seamless as possible. After all, sometimes all a consumer ...

Resources last updated: 3/17/2016 12:48:29 AM