04-18-2019
sas_9
Obsidian | Level 7
Member since
10-30-2011
- 231 Posts
- 3 Likes Given
- 0 Solutions
- 15 Likes Received
-
Latest posts by sas_9
Subject Views Posted 436 04-17-2019 02:50 PM 9214 04-17-2019 02:21 PM 9259 04-16-2019 01:06 PM 9273 04-16-2019 12:05 PM 9283 04-16-2019 11:31 AM 9303 04-16-2019 10:37 AM 2366 02-18-2018 05:55 PM 2397 02-17-2018 11:30 AM 2428 02-16-2018 10:28 PM 2453 02-16-2018 06:36 PM -
Activity Feed for sas_9
- Posted Re: How do I read multiple space delimited file? on SAS Programming. 04-17-2019 02:50 PM
- Posted Re: How do I read multiple space delimited file? on SAS Programming. 04-17-2019 02:21 PM
- Posted Re: How do I read multiple space delimited file? on SAS Programming. 04-16-2019 01:06 PM
- Posted Re: How do I read multiple space delimited file? on SAS Programming. 04-16-2019 12:05 PM
- Posted Re: How do I read multiple space delimited file? on SAS Programming. 04-16-2019 11:31 AM
- Posted How do I read multiple space delimited file? on SAS Programming. 04-16-2019 10:37 AM
- Posted Re: long var with multiple delimiter on SAS Enterprise Guide. 02-18-2018 05:55 PM
- Posted Re: long var with multiple delimiter on SAS Enterprise Guide. 02-17-2018 11:30 AM
- Posted Re: long var with multiple delimiter on SAS Enterprise Guide. 02-16-2018 10:28 PM
- Posted Re: long var with multiple delimiter on SAS Enterprise Guide. 02-16-2018 06:36 PM
- Posted long var with multiple delimiter on SAS Enterprise Guide. 02-16-2018 05:35 PM
- Got a Like for Re: "An error occurred executing the workspace job". 10-11-2017 11:01 AM
- Got a Like for Re: How to Write a SAS Dataset to a Pipe Delimited Text File (Not Using PROC EXPORT). 06-21-2017 03:58 PM
- Liked Re: starting/stopping services on grid for JuanS_OCS. 11-02-2016 09:02 AM
- Posted Re: SAS email help on Administration and Deployment. 03-15-2016 11:23 AM
- Posted Re: SAS email help on Administration and Deployment. 03-14-2016 07:28 PM
- Posted SAS email help on Administration and Deployment. 03-14-2016 04:21 PM
- Got a Like for Re: How to ODBC SQL Server with multiple database?. 02-12-2016 11:32 AM
- Got a Like for Re: If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide. 09-01-2015 04:24 AM
- Got a Like for Re: How to ODBC SQL Server with multiple database?. 09-01-2015 04:24 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 2 1 -
My Liked Posts
Subject Likes Posted 1 06-10-2013 07:39 PM 1 07-11-2014 05:16 PM 1 01-09-2013 03:21 PM 3 12-18-2012 05:08 PM 3 01-09-2013 10:07 AM
09-20-2012
11:10 PM
I am really seeking answer for this question because the big question is i am not sure even question is appropriate? I am wondering if we can create library in SAS EG/MINER itself. Is that possible to create same with management console or not? I don't have access to SAS EG/MINER. Other team member has it so i cannot even check same. Please reply.
... View more
09-20-2012
07:06 PM
Hello All, Our team is new in SAS and i have joined new in team too as a SAS Admin role. I am also new at this role. We are using SAS EG and SAS Enterprise Miner currently. My team is telling me to create SAS Library in sas management console so that they can write the code and store the dataset in that particular library through SAS Enterprise guide and AS Enterprise miner. Basically they want to store the data set that will be created by SAS EG/EM. Can you please tell me how i can do that? Any std procedure to do that? Please let me know if i didn't explain this question correctly? I also need to get this done ASAP. I would really appreciate help. Thanks All.
... View more
09-19-2012
01:18 PM
Hello all, i am new at sas admin and i am trying to install sas 9.3 under my machine from company's share file folders. Folder name, SAS Binaries, contains sas enterprise guide, JMP, MEDIA_DATE, ORDER_DATE,SID_FILES and all others sub folder along with setup.exe with SAS logo. So my question is if i am going to execute that .exe file, everything will install itself? I also wants to know if there is any prerequisit for SAS 9.3 and needed space for same. I really appreciate help in this case. Thanks. Sam.
... View more
04-16-2012
11:06 AM
anyone can hele me on this please? what is the meaning of white space in following code log. Not getting error but kind of SAS version warning. is that i need put one space after '0000'and code line? data discount_sysprinserv(drop = agent nature_of_service); 282 length discount_code $2 ; 283 set sasds.csg_discount_&date1; 284 where principal ne '0000' and agent = '0000'and restrict_discount in ('S','X') ; ______ 49 NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 285 run; NOTE: There were 0 observations read from the data set SASDS.CSG_DISCOUNT_120414. WHERE (principal not = '0000') and (agent='0000') and restrict_discount in ('S', 'X'); NOTE: The data set WORK.DISCOUNT_SYSPRINSERV has 0 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 6.52 seconds cpu time 6.47 seconds
... View more
04-13-2012
04:04 PM
is that because of i commented out following code part too? 185 proc sql; 186 select serv into :service1 from temp1; 187 quit;
... View more
04-13-2012
03:48 PM
i am using 1st reply answer and getting following error: data sasds.INTL_csg_&day; set customer_&day; run; NOTE: There were 50402 observations read from the data set WORK.CUSTOMER_13APR12. NOTE: The data set SASDS.INTL_CSG_13APR12 has 50402 observations and 3 variables. NOTE: Compressing data set SASDS.INTL_CSG_13APR12 decreased size by 43.39 percent. Compressed is 381 pages; un-compressed would require 673 pages. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.11 seconds proc sql; 145 create table dst_codes as 146 select '123' as account,code from sasds.intl_codes where plan = 'INTL' and biller = 'DST'; NOTE: Compression was disabled for data set WORK.DST_CODES because compression overhead would increase the size of the data set. NOTE: Table WORK.DST_CODES created, with 13 rows and 2 columns. 147 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 148 149 150 proc sort data = dst_codes; 151 by account; 152 run; NOTE: There were 13 observations read from the data set WORK.DST_CODES. NOTE: The data set WORK.DST_CODES has 13 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 9 The SAS System 05:00 Friday, April 13, 2012 153 154 155 data temp1; 156 set dst_codes; 157 by account; 158 format serv $300.; 159 retain serv; 160 if first.account then serv = QUOTE(code); 161 else serv = trim(serv) || ',' || QUOTE(code); 162 if last.account then 163 output; 164 drop code; 165 run; NOTE: There were 13 observations read from the data set WORK.DST_CODES. NOTE: The data set WORK.TEMP1 has 1 observations and 2 variables. NOTE: Compressing data set WORK.TEMP1 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 166 167 *********This code commented out becasue its getting error*********; 168 169 /* 170 data temp1; 171 set dst_codes; 172 by account; 173 format serv $300.; 174 retain serv; 175 if first.account then 176 serv = "'"||code||"'" ; 177 else do; 178 serv = compress(serv||",'"||code||"'", ' '); 179 end; 180 if last.account then 181 output; 182 drop code; 183 run; 184 185 proc sql; 186 select serv into :service1 from temp1; 187 quit; 188 189 */ 190 191 192 193 194 libname idst oracle user=BA01NPTNE password=XXXXXXXXX path=iddp2 schema=ggs readbuff = 250000; NOTE: Libref IDST was successfully assigned as follows: Engine: ORACLE Physical Name: iddp2 195 196 proc sql; 197 create table sasds.intl_dst_&day as 10 The SAS System 05:00 Friday, April 13, 2012 198 select compress(put(a.acctcorp,z5.)||'/'||put(a.house,6.)||'/'||put(a.cust,2.), ' ') as acctnum, 199 serv as bill_code, 200 put(a.acctcorp,Z5.)as acctcorp 201 from idst.idst_cust_rate as a, 202 idst.idst_customer as b 203 where a.acctcorp = b.acctcorp 204 and a.house = b.house 205 and a.cust = b.cust 206 and b.stat in ('3','4','5') 207 and serv in ( &service1) _ 22 WARNING: Apparent symbolic reference SERVICE1 not resolved. 207 and serv in ( &service1) ________ 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, (, -, SELECT. ERROR 202-322: The option or parameter is not recognized and will be ignored. 208 and put(a.acctcorp,z5.) ne '05645'; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 209 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds
... View more
04-12-2012
02:39 PM
I am running following code and getting error. I am assuming i need to change code value from single quote to double quote but not sure how and where. Please help. data temp1; set dst_codes; by account; format serv $300.; retain serv; if first.account then serv = "'"||code||"'" ; else do; serv = compress(serv||",'"||code||"'", ' '); end; if last.account then output; drop code; run; NOTE: There were 13 observations read from the data set WORK.DST_CODES. NOTE: The data set WORK.TEMP1 has 1 observations and 2 variables. NOTE: Compressing data set WORK.TEMP1 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds proc sql; select serv into :service1 from temp1; quit; NOTE: The PROCEDURE SQL printed page 2. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds libname idst oracle user=BA01NPTNE password=XXXXXXXXX path=iddp2 schema=ggs readbuff = 250000; NOTE: Libref IDST was successfully assigned as follows: Engine: ORACLE Physical Name: iddp2 proc sql; create table sasds.intl_dst_&day as select compress(put(a.acctcorp,z5.)||'/'||put(a.house,6.)||'/'||put(a.cust,2.), ' ') as acctnum, serv as bill_code, put(a.acctcorp,Z5.)as acctcorp from idst.idst_cust_rate as a, idst.idst_customer as b where a.acctcorp = b.acctcorp and a.house = b.house and a.cust = b.cust and b.stat in ('3','4','5') and serv in ( &service1) NOTE: Line generated by the macro variable "SERVICE1". 10 The SAS System 05:00 Thursday, April 12, 2012 190 '*V','*X','*Y','>G','B:','E$','E+','.(','.)','.+','_8','!'7','!'8' ___ 49 _ 22 76 NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ), ','. ERROR 76-322: Syntax error, statement will be ignored. 191 and put(a.acctcorp,z5.) ne '05645'; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
... View more
01-05-2012
04:33 PM
This is a part of code from sceduled job on taro. This code is created by another person and i am trying to figure out where exactly i need to put double quatation mark. Becasue code_ref table is in oracle and i think i cannot put double quatation in oracle. Please guide me. I have atatched code. Thanks.
... View more
12-20-2011
03:56 PM
how to quote these two code in unix in WHERE statement? !'7 AND !'8
... View more
11-10-2011
02:43 PM
Hello SAS experts, in attched dataset i have added some new codes under xfinity package code and i want to test out XFINITY part only, so i am wondering what syntax would be and how much i need to add on it? ********just want to test out ***************** XFINITY PART*****************before i go ahead and change original dataset.... Thanks.
... View more
10-30-2011
09:43 PM
OK. sir. this is my weekly bundle process but it was failed to run last week so i just want to pullup data for date 15th oct -22nd oct, so if i change date( ) to '22oct11' d for both date1 and date2, dataset will pullup data for same date that i want but i am not sure what date logic should be for second data _null_ statement. Is there anything need to be change in that or not? Thanks, Sandip.
... View more
10-30-2011
08:20 PM
Here i want to generate report from date 15thoct to 22oct. i am wondering what logic should be for second data _null_ statement to generate data for same date. Infirst data _null_ statement, i have changed date to '22oct11'd for same date 1 and date2. i am not sure about what date logic for second data _null_statement. Please guide.... Thanks.
... View more
- « Previous
- Next »