About noobs

noobs · ‎01-22-2014

I am using this code in Program node in SAS Enterprise Guide to export output dataset into Microsoft Excel worksheet. ods tagsets.excelxp file=_webout options(embedded_titles="yes" print_header='AC_SP_C2_C5_C6_T2_Classes' sheet_name='C2 C5 C6 and T2 Classes'); proc print data=work.Filter_C2_C5_C6_T2 noobs; run; ods tagsets.excelxp close; Is it possible to control range of cells where this data gets pasted in worksheet C2 C5 C6 and T2 Classes so that every time the project runs and new data is generated, it gets appended at bottom. I looked into options for PROC EXPORT but it does not support RANGE option; like PROC IMPORT that allows you to import data from specific range of cells using option similar to RANGE="C2 C5 C6 and T2 Classes$B4:D10"; I am open to other solutions that may allow me to achieve this task of exporting dataset at end of existing data in worksheet and not totally replacing it. Thanks, Dhanashree

noobs · ‎11-05-2013

Yes, that is what I am looking for. Although .dat extension. So after I have created that file, I am having following script to access its contents and generate data set: filename testref "/home/dhanashree.gadka/user/DUG/test.dat"; data work.vegd; infile testref; input vname $ vfreq $; run; I see this error in Log: ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Physical file does not exist, /sso/biconfig/930/Lev1/SASApp/TESTREF. Am I missing something? And in theory, what is the best way to peek at raw data files for data examination purposes so that one can figure out what is the data structure and how to write the input statements. Thanks so much.

noobs · ‎11-05-2013

How do I go about creating raw data file in SAS Enterprise Guide? Later I intend to use INFILE statement and INPUT to access this file and its contents. Is it even possible to do so? Regards, Dhanashreeata

noobs · ‎11-05-2013

Ok, using FORMAT statement is good practice and I will use it, however will it resolve issue of reading State variable correctly because it is preceded by Supplier variable which is not fixed length, hence one cannot use column pointer @? format Supplier $25. Rate 3.1 State $2. VName $15. Frequency $10.; input #2 Supplier #3 Rate #2 State #1 VName #3 @6 Frequency; Reading Frequency with @6 is possible as Rate will always be fixed width 3 with n.n format. However in INPUT statement, when using #2 State will it not create problem as pointer may not be placed at right column always for every record? Is there any other solution?

noobs · ‎11-04-2013

Hello, I am using non-sequential #n line pointer control to read following data, where one observation needs to be created out of three records: ROMA TOMATO FRESHPOINT CA 1.80 DAILY GREEN BEANS ORGANICS NC 1.20 WEEKLY Sequence of variables stored in data set has to be as follows: Supplier (FRESHPOINT) State (CA) Rate (1.8) Frequency (DAILY) VName (ROMA TOMATO) data produce.vegetables; infile vegdata; input #2 Supplier $ State $ #3 Rate 4. Frequency $ #1 VName; run; However, how do I change sequence of variables to Supplier Rate State VName Frequency Thanks much, Dhanashree

noobs · ‎10-31-2013

Hello, I am trying to figure out if there is way to get same results as operating inner join on three tables in SQL by means of match-merge in DATA step? As long as data set is sorted on BY variable, and subsetting IF condition in used on correct variable, it is straightforward to operate inner join for two data sets in DATA step. However is it possible to add third data set as well? What effect will it have to introduce two variables in BY statement of MERGE? Thanks.

noobs · ‎10-30-2013

This is theoretical situation where array is already loaded. There are multiple ways to input data into array like initialization using parentheses or simply direct addressing: array book{*, 50, 25} $ 25 ('The' 'brown' 'fox' 'is' 'jumping' ...); * ... represents more words ; It is lot of typing just like datalines statement.

noobs · ‎10-30-2013

So will it be ok to use * for unspecified dimension array book{*, 50, 25} $ 25 ; do i=1 to dim{book}/1250; wordfirst=book{i,1,1}; output; end; This snippet represents book{page, row, column} where each word is 25 character long at the most. It is reading first word on every page, where number of pages in undetermined and writes it to output data set.

noobs · ‎10-30-2013

Thanks. Is there any limit in theory memorywise how many dimensions can be allocated?

noobs · ‎10-30-2013

Hello SAS Community, Is it possible to create more than two dimensional arrays? Something like array book{100, 50, 25} p1-p125000; where each element represents location on page of a book that can be accessed by {page, row, column} terminology. For eg: p100 will point to location on page 2 row 5 column 10.

noobs · ‎07-14-2013

Hello SAS EG Community, Sharing an article about kinds of charts used to read financial numbers, developed exclusively in SAS Enterprise Guide. Thank you, Dhanashree Gadkari

noobs · ‎07-12-2013

Michael Raithel, Those reads provided answers to my attempt of bridging between SAS and SQL. Very well then! Your wishes are much needed this moment. Dhanashree

noobs · ‎07-11-2013

Hello MO/OR community, I intend to compress data set and while examining PROC CONTENTS, I found following additional information: Protection Data Set Type Indexes 0 Compressed NO Sorted NO If I were to modify Compressed to YES, how should I proceed? In general, what are options for Protection, Data Set Type, Indexes, Sorted and how to modify these? Are there some macros to address this? Is it user-level grant Thankfully, Dhanashree Gadkari

noobs · ‎07-08-2013

Got it, well explained. Do fixed length records get assigned F for RECFM?

noobs · ‎07-07-2013

Good Read

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: Scheduled Jobs

Re: Output of scheduled job not same as manually run job

Re: Output of scheduled job not same as manually run job

Re: Output of scheduled job not same as manually run job

Re: Output of scheduled job not same as manually run job

Output of scheduled job not same as manually run job

Output of scheduled SAS DI Job is different from manually run DI job

Count number of observations

Re: Scheduled Jobs

Scheduled Jobs

Re: Check for existing column

Re: Print data to excel

Re: Inner Join Equivalent for three variables

Re: Sounds Like operator

RECFM LRECL

Re: RECFM LRECL

Re: SAS® Enterprise Miner™ can build credit scorecards

How to write and read charts

Re: SAS® Enterprise Miner™ can build credit scorecards

Print data to excel

Re: Raw Data File

Raw Data File

Re: #n Line Pointer Control

#n Line Pointer Control

Inner Join Equivalent for three variables

Re: Multidimensional Array

Re: Multidimensional Array

Re: Multidimensional Array

Multidimensional Array

How to write and read charts

Re: How to index datasets

How to index datasets

Re: RECFM LRECL

Re: SAS® Enterprise Miner™ can build credit scorecards