Re: how to read quarterly data in SAS? #2

On Sat, 3 Nov 2007 22:26:04 -0000, Richard <hujian@GMAIL.COM> wrote:

>I got the error message when I was using informat yyq. The original
>data set is in .txt and delimited by space.
>data sen.sensitive;
>infile 'sensitive.txt';
>input time $ yyq6. growth sensitive insensitive differnce recession;
>ERROR 48-59: The informat $YYQ was not found or could not be loaded.
>any thought?

It's numeric. Remove the dollar sign ($).
nospam1405 (4666)
11/3/2007 11:27:28 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

1 Replies

Similar Articles

[PageSpeed] 21

Thanks a lot! It works.

On Nov 3, 6:27 pm, nos...@HOWLES.COM ("Howard Schreier <hs AT dc-sug
DOT org>") wrote:
> On Sat, 3 Nov 2007 22:26:04 -0000, Richard <huj...@GMAIL.COM> wrote:
> >I got the error message when I was using informat yyq. The original
> >data set is in .txt and delimited by space.
> >data sen.sensitive;
> >infile 'sensitive.txt';
> >input time $ yyq6. growth sensitive insensitive differnce recession;
> >rat=sen/in;
> >run;
> >ERROR 48-59: The informat $YYQ was not found or could not be loaded.
> >any thought?
> It's numeric. Remove the dollar sign ($).

hujian (23)
11/4/2007 1:10:33 AM

Similar Artilces:

Re: Reading SAS data sets on UNIX by non-SAS apps #2
John: Following on Richard's thoughtful suggestions, the Affinium system would likely capture data from csv files. SAS PROC EXPORT produces them quickly, and loading them into external systems works faster for relatively basic data structures and data formats, in my experience, than xml parsing. Sig -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John Bentley Sent: Monday, October 18, 2004 10:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading SAS data sets on UNIX by non-SAS apps I have SAS data sets on AIX that we need to read with Unica's Affinium campaign management software, also on a UNIX box. (Let's not get into why we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC driver for the UNIX environment, and the Affinium implementors don't want to use the SAS SQL Library for C and or deal with APIs. Other that dumping the SAS data sets as flat files, can anyone suggest a solution? Thanks in advance for the help. ...

Re: Deleting SAS Data from a SAS DATASET #2
Chandra - this isn't my expertise area - I'm sure others may have better ideas but I'll make three comments. If your datasets have a large number of variables, in your datastep method a WHERE clause will be more efficient - the IF statement causes each record to be fully read before it can be selected for deletion. A WHERE clause would only read the single variable in the case of records that meet the criteria for deletion. Data prod.Master_date; set prod.master_date; where snap_dt ne "&end_dt"d; run; You probably would be better off changing your data model though - my first thought would to be to store your data as separate yearly or monthly files and then access them with a view of the past two years or 24 months. With each month or year you would delete the oldest file and change the view one time period forward. *set up the data; data time1 time2 time3 time4; do i = 1 to 100; do t = 1 to 4; if t=1 then output time1; if t=2 then output time2; if t=3 then output time3; if t=4 then output time4; end; end; run; *three successive example views; data filet1 / view=filet1; set time1 time2; run; data filet2 / view=filet2; set time2 time3; run; data filet3 / view=filet3; set time3 time4; run; One more thought - since the data are appended - if the file is not reordered and you have the record counts from each append - then you can use firsto...

Re: how to read quarterly data in SAS?
Richard, You are looking for the YYQ informat. 27?? data _null_ ; 28??? qob='1947Q1' ; 29??? qob_d=input( qob, yyq6. ) ; 30??? put qob= qob_d=date9. ; 31??? run ; qob=1947Q1 qob_d=01JAN1947 HTH, Ken -----Original Message----- From: Richard <hujian@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Sent: Sat, 3 Nov 2007 5:52 pm Subject: how to read quarterly data in SAS? Hi Guys: how to read time variable like 1947q1 from excel file? any informat? Thanks! Richard ________________________________________________________________________ Email and AIM finally together. You've gotta check out free AOL Mail! - http://mail.aol.com ...

Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS. Gerhard On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM> wrote: >Is it possible to read a sas dataset NOT using sas and have >observations and variables etc. rather than having meaningless chunks >of text? ...

Re: search SAS data set from SAS code #2
Rose, The answer to your question depends on your operating system. In Windows, there's the Search tool. In Unix/Linux, you can use grep Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com Rose <myr_rose@YAHOO.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 04/19/2005 11:13 AM Please respond to myr_rose To: SAS-L@LISTSERV.UGA.EDU cc: Subject: search SAS data set from SAS code Hi All, Suppose I have a sas permanent data set which was created early, I know the library path but I couldn't remember in which s...

Re: read Access data in SAS #2
On Thu, 11 Oct 2007 08:46:26 -0500, Bruce J <chimanbj@GMAIL.COM> wrote: >If you have Access to PC File Formats, you can use the syntax: for SAS V. 9+ clarification: "Access" above refers to SAS/Access;"access" below refers to MS Access > >Libname mdb access "PATH\file.mdb"; > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Little >T >Sent: Thursday, October 11, 2007 8:14 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: read Access data in SAS > >Guys, I was given a Access data file to do some analysis. Can anyone share >your idea or code of how to read Access data in SAS. Do I have to go into >Access and export or do Import in SAS? > >Thanks. ...

Re: SAS Reading Cognos Data #2
I have worked at two sites that used both SAS and Cognos, at both we dumped data from Cognos PowerPlay (an OLAP / multidimensional tool) into CSV (comma separated value) text files, if we wanted to analyse it in SAS. If we wanted to go the other way we did the same thing - dump it into a delimited text file. I doubt that you could use ODBC since it is tightly bound to SQL and relational-like structures. (I'm fairly sure there isn't an ODBC driver for Cognos PowerPlay.) SAS does provide the "SAS Access Interface to OLE DB" and both SAS and Cognos PowerPlay can be OLE DB co...

Re: Read SAS date from log/turning it into SAS datetime value #2
Hi Richard, Rich The datestyle Rich0850 finds, occurs in the log produced by a batch-sas session - and doesn't appear on an interactive-sas session log. Where you can anticipate the use for later parsing of the log, I would reccommend - as Richard (Richard A. DeVenezia <radevenz@IX.NETCOM.COM>) did - insert into the autoexec, a statement to generate a more-easily read datetime. In all my sessions, (keeping altlogs of all interactive sessions has proved very very useful, time and again) I have this statement at the end of the autoexec....... %put starting (contract/project/applicatio...

Re: Reading & Writing SAS data sets without SAS #3
Chang, You're correct in that a number of companies have done it. I believe SPSS can do it, WPS, Stat Transfer, dbmscopy, and perhaps others have also done it. But what I think is unique about this is that Alan is talking about offering plug-ins so you can roll-your-own so to speak. How cool would it be to have some type of driver/plugin for R? Phil Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress -----Original Message----- From: Chang Chung [mailto:chang_y_chung@HOTMAIL.COM] Sent: Monday...

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: help with reading ASCII data into SAS #2
> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of olivesecret@GMAIL.COM > Sent: Wednesday, November 05, 2008 8:50 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: help with reading ASCII data into SAS > > Yes, I did it with delimiter=',' dsd firstobs=2, but was told invalid > data for each variable. > Any more suggestions? Thanks a lot! > > You will need to show us the actual code you are using to read the file if you want more than just a guess as to what went wrong. Seeing the log file with actual error message would be helpful as well. Dan Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204 Here is my code: data data; infile 'data.txt' delimiter=',' dsd firstobs=2; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; run; Here is one more obs: 1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" Other obs are similar. Thank you very much! On Nov 5, 12:24 pm, Nord...@DSHS.WA.GOV ("Nordlund, Dan (DSHS/RDA)") wrote: > > -----Original Message----- > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On > > Behalf Of olivesec...@GMAIL.COM > > Sent: Wednesday, November 05, 2008 8:50 AM > > To: SA...@...

Re: Reading unstructured data using SAS #2
Dear SAS-L-ers, Ashok posted, in part, the following: <<Ashok's entire original posting can be found beneath the Sig line>> > I want to read an html file using sas. The content of the file is > pasted > below. The sample file is the single record copied from html. <<SNIP!>> > > Can we use SAS to read unstructured data ? I can't answer your exact question, but can point you to a resource that you can use to explore this issue further. Check out the SAS 9.2 Language Reference Dictionary http://support.sas.com/documentation/cdl/en/lrdict/61724...

Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2 #2
> From: A Little Birdie > > I just searched the SAS-L archives (should have done that > first) and found references to these two pages: > > http://www.sascommunity.org/wiki/Category:V9.2_Phase_2 > > http://www.sascommunity.org/wiki/V9.2_Phase_2_install_guide > > Have you seen this page? > ***************************************************** > http://support.sas.com/kb/35/631.html <---<<< NICE! ***************************************************** > It looks like it addresses your needs, and might be something > nice to add to the SASCo...

Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN #2
A: You may want to consider using nested queries to create the keys that you need to join the tables? That gives the SQL compiler a way to bound the search space. For example, proc sql; create table temp as select * from (select <key transformation>,* from small) as t1 left join (select <key transformation>,* from large) as t2 on t1.<transformed key> EQT t2.<transformed key> ; Now the SQL compiler has two keys from the same domain that it can index or use as sort keys. This method works with composite keys as well. Just make sure that the <transformed key> v...

Re: How to Read PDF/RTF data in to SAS datasets #2
On Tue, 28 Nov 2006 14:50:49 GMT, John I <not@HOTMAIL.COM> wrote: >Frank Poppe wrote: > >> John I schreef: >> >>> Richard A. DeVenezia wrote: >>> >>> > "Susiyanto, Dwi (GE Money)" wrote: >>> >> Hi SAS experts, >>> >> I have data of account list (that is like text file) in PDF/RTF >>> >> format. If i looked in RTF/PDF , it will show the column and account >>> >> list (including header of report), but when i do to copy paste to >>> >> text file (by using edi...

Re: read excel data cell and formula from SAS #2
On Thu, 27 Apr 2006 11:46:23 -0400, Joan Zhao <hongzl@OPTONLINE.NET> wrote: >Hi, everyone: > >Does anybody know that how can I read a specific data cell in a EXCEL file >from SAS through DDE? What's command or function can I use? Any reason you can't do it the usual way, by having the triplet point to just the one cell? >In addition, >how can I read a formula in EXCEL through DDE from SAS? I haven't tried this, but what happens if Excel is told to display the formula rather than the value in the cell being read? Tools:Options:View:Formulas > >I&#...

Re: Trying to read very dirty txt data into sas #2
David, If you read the data as a stream you can load what you want into a single variable and then parse that variable directly. DATA email; INFILE 'email.txt' recfm=n LRECL=32767; INPUT email $char32767.; RUN; data parse; set email; start=index(email,'<MESSAGE>')+9; end=index(email,'</MESSAGE>'); emailp1=substr(email,start,end-start); run; hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David Fickbohm Sent: Tuesday, August 1...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
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 and R; I"ve used SAS for 10 or 15 years, R for about 6 >months - 1 year. > >Each has strengths and weaknesses; I'd not like to give up either. > >Strengths of SAS (esp. compared to R) > >Tech support - I have SAS tech support's phone number and our license >number memorized. They're great. > >SAS-L - There's also an R-help list...

Re: Can SAS read XML data with special missing values? #2
If you use an XMLMAP you can apply an informat to the data read from the XML file. Here's a little example: XML File: ___________________________________________________ <?xml version="1.0" encoding="windows-1252" ?> <TABLE> <ROW> <COL var="x"> 1 </COL> <COL var="y"> 2 </COL> </ROW> <ROW> <COL var="x">Q</COL> <COL var="y"> 4 </COL> </ROW> <ROW> <COL var="x">D</COL> <...

Re: How to read data from stata file(.dta) in SAS 9.0 #2
by the way: if you still get errors, install a actual SAS version. The below is for 9.1.3 Gerhard On Mon, 28 Sep 2009 10:04:31 -0400, Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE> wrote: >try the following (adapt your dataset names): > >proc import out= hsb2 datafile = "c:\data\hsb2.dta"; >run; >proc contents data=hsb2; >run; > >Gerhard > > > > >On Mon, 28 Sep 2009 00:25:37 -0700, kondal <kondal717@GMAIL.COM> wrote: > >>Hi friends >> >>I used following code to read data from stata file ( SAS 9.0) bu...

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: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #2
Graham , I am not sure that the SI Tech Support examples should have all the error checking that Chang wanted to throw in the macro. The examples should be clear concise and easy to read and get going, as well as be illistrative. Too much error checking in an example well is just over kill and even detrimental to an example. However, any code solution on the SI Tech Support web sit should follow basic rules of good practices and sound advice. Such as with thier macros having atleast a somewhat good Macro design. Look at Example SAS Sample 1728: The first method well lets say is soooo bad...

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: 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: how to read quarterly data in SAS? #2 - comp.soft-sys.sas

Drawn and Quarterly - Wikipedia, the free encyclopedia
Drawn and Quarterly is a publishing company based in Montreal , Quebec , Canada , specializing in comics . It publishes primarily comic books ...

Quarterly Review - Wikipedia, the free encyclopedia
Initially, the Quarterly was set up primarily to counter the influence on public opinion of the Edinburgh Review . Its first editor, William ...

Facebook To Implement Breaking Changes For Developers On A Quarterly Basis
Facebook will attempt to quell confusion by developers over breaking changes to its policies by implementing those changes on a quarterly basis, ...

What Facebook’s quarterly earnings didn’t say about FBX
Facebook surprised Wall Street on July 24 with a quarterly earnings report that exceeded revenue and profit expectations by a wide margin, largely ...

Virginia Quarterly (@VQR) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

tour quarterly on the App Store on iTunes
Get tour quarterly on the App Store. See screenshots and ratings, and read customer reviews.

TEDxBoulder - Brad Feld - Quarterly Week Off the Grid - YouTube
Brad Feld discusses the importance of taking time off. About TEDx, x = independently organized event In the spirit of ideas worth spreading, ...

David Marr sets sights on Bill Shorten in another Quarterly Essay
He exposed Kevin Rudd's colourful use of language to describe the Chinese during climate negotiations and allegations of Tony Abbott's infamous ...

NDIS ACT rollout improves but numbers underestimated: quarterly report
The rollout of the National Disability Insurance Scheme in the ACT is on track with complaints slowing down, but the number of Canberrans deemed ...

Chipotle Sees First Quarterly Loss Amid Food-Safety Crisis
Chipotle Mexican Grill Inc.’s food-safety crisis has brought an unwanted milestone to the beleaguered restaurant chain: its first quarterly loss ...

Resources last updated: 3/17/2016 5:15:21 PM