About nbonda

nbonda · ‎10-30-2015

Hi jakarman, How can I do indexing on master table. Thank you

nbonda · ‎10-30-2015

Tom, Thank you for your reply. I will test update statement also. I checked the article update and modify are doing same function. so is there any advantage using modify statement over update statement? I am using Unix platform forgot to mentionin original question:

nbonda · ‎10-30-2015

Hi have a master dataset, to update this master dataset with transaction dataset I am using following code. creating empty dataset (one time): proc sql; create table ma.master ( ID num informat=8. format=8. label="Iabel_invoiceid", Created_DT num informat=mdyampm. format=datetime20. label="create_dt", COMMENTS char(100) informat=100. format=100. label="comments" );quit; Now I want to update this master dataset with transaction dataset every day, I using following code data ma.master; modify ma.master tr.tras_data by id; IF _iorc_ eq 1230013 then OUTPUT; else do; REPLACE; end; run; I have 85000 records first time and every day i will have 30000 records in transaction dataset. Its taking more than 2 hours to complete. Why its running slow Please suggest me if anything I need to modify my cody. Thank you in advance

nbonda · ‎10-24-2015

Thank you for suggesting me PICTURE statement. Can we store customized date format in dataset?, I applied user defined format in PUT statement, PROC PRINT its working perfectly fine. I have a dataset named Inventory as below: Inv_no Record_dt 102 10Oct2015:14:00:00 103 12Oct2015:09:00:30 I tried with following code: proc format; picture limdate other='%0m/%0d/%0Y %0H:%0M:%0S' (datatype=datetime); run; data new_inv; retain inv_no record_dt; set inventory ; format record_dt limdate.; run; but I am not successful. so proc format Picture statement is only to display or presentation.??? Please suggest me if there is any way I can accomplish. Thank you

nbonda · ‎10-23-2015

Hi I have following csv data sample data&colon; id,created_date,modified_date 1021,12/23/2014 12:12:37 AM,9/21/2015 09:56:02 AM 1024,09/12/2015 04:24:00 PM,10/21/2015 11:44:03 AM I have code: DATA sample; INFILE '/path/file' dsd dlm=',' firstobs=2 ; ATTRIB id informat = $5. format=$5.; created_date informat=mdyampm. format=mdyampm. modified_date informat=mdyampm. format=mdyampm. ; INPUT id $ created_date Modified_date; ;run; in My out put I am getting values for date variables like 9/21/2015 09:56:02 AM. How Can I get dates like 9/21/2015 21:56:02 or datestamp (24 hours format without AM, PM). What is the right format I need to use for dates. Thank you

nbonda · ‎10-23-2015

Hi I have following csv data sample data&colon; id,created_date,modified_date 1021,12/23/2014 12:12:37 AM,9/21/2015 09:56:02 AM 1024,09/12/2015 04:24:00 PM,10/21/2015 11:44:03 AM I have code: DATA sample; INFILE '/path/file' dsd dlm=',' firstobs=2 ; ATTRIB id informat = $5. format=$5.; created_date informat=mdyampm. format=mdyampm. modified_date informat=mdyampm. format=mdyampm. ; INPUT id $ created_date Modified_date; ;run; in My out put I am getting values for date variables like 9/21/2015 09:56:02 AM. How Can I get dates like 9/21/2015 21:56:02 or datestamp (24 hours format without AM, PM). What is the right format I need to use for dates. Thank you

nbonda · ‎10-23-2015

Thank you. In some of my files date variable name may be like created_date, Modified_date, date_lastupdated like that. It may not be suffixed with consecutive numbers.

nbonda · ‎10-23-2015

How Can I use same conditon for multiple variable? lets say data test; infile cards delimiter=',' dsd; input inv $ Date1 mdyampm. Date2 mdyampm. Date3 mdyampm. Date4 mdyampm.; cards ; 101,09/11/2014 10:22:00 AM,02/02/1900 10:22:00 PM,10/1/2014 11:22:00 AM,9/11/2014 02:22:50 AM 102,09/01/2014 10:21:00 AM,02/02/1900 10:22:00 PM,10/1/1900 12:19:00 AM,9/11/1900 12:22:50 AM 103,10/11/1900 10:02:00 AM,12/02/1900 10:29:09 PM,10/1/2014 11:22:00 AM,9/11/2014 02:23:10 AM ;run; data test2; set test; if date1 <= '1/1/1900'd then date2=.; if date2 <= '1/1/1900'd then date2=.; if date3 <= '1/1/1900'd then date2=.; if date4 <= '1/1/1900'd then date2=.; ; is there any way I can write same codition to multiple datetime variable in single line, actually I have more date variables in my task ; Any suggestionon FORMAT to get values like ,2/09/2015 20:22:00 Thank you in advance

nbonda · ‎10-09-2015

Thank you for you suggesion. It's very big file, has few millions of rows, we get these files everyday. we are bugging data management to change it :), they are asking us to read some for now.

nbonda · ‎10-09-2015

Hello SAS users, I have a csv file on Linux box. I am trying to read this file using SAS EG. But some of the value are wrapped text (I found it when I moved this file to windows and opened in Excel, The data values I have issues are wrapped text). I am not able to read this csv file into sas dataset without out errors. sample of csv file as follows: 101,"Laptop","This device is in good condition, store it in the shelf" 102,"Monitors","we have 100 monitors, about 80 are in good condition. and 20 need to be fixed" 103,"Mice","we have 250 mice most of them in good conditon." I am using following code to read above csv file: data inven, infile "infile_path" delimiter=',' DSD lrecl=32000 termstr=LF ; attrib item_no length=8 format=11. input item_id @; attrib Item_name length=$8. format=$8. input Item_name $ @; attrib comment length=$80. format=$80. input comment $ @; run; in second row comments variable value is wrapped text ,it has multiple end of line. how to read this kind of CSV files? Thanks in advance.

nbonda · ‎08-16-2015

Than you for reply. I modified the code and ran the batch job. The sas session not terminating, still continue to process further sas steps. am I missing to add anything? endsas is not terminating session here.

nbonda · ‎08-15-2015

Hi My SAS code has mutliple data step and proc steps. I want end the sas session when certain condition met. I am running my sas code on UNIX in batch mode. When certain dataset has 0 observations, I want to end session. I used following is example code, it's not working as I expected. ..multiple sas data, proc steps data _null_; set old_dataset nobs=_nobs; if _nobs=0 then call system('endsas'); run; ..multiple data steps. Thank you

nbonda · ‎07-01-2015

I have a multiple macros those select record conditionally from database tables and insert output records into a sas datasets. some times these macros run parallel and insert resulting records into a same dataset. I am using proc sql to insert records, but I am losing some of the records. is there other way we can insert processed records into a dataset.

nbonda · ‎06-25-2015

Is there any other option without changing my entire code . Because I have 30 similar code with lot of variables in input statement.

nbonda · ‎06-24-2015

I have a code that read a text file, with delimiter pipe (|) data sample; Infile 'C:\mydata\test.txt' DSD DLM='|' LRECL=1024 MISSOVER FIRSTOBS=1 TERMSTR=LF; Input fname :$CHAR20. lname :$CHAR30. city :$CHAR40. run; sample text file: Jen|Turner|'Chicago' David||'New York' Michael|ybarra|Detroit If I use DSD option ,SAS not reading single quotes and consecutive delimiters reading as missing value...., Without DSD option SAS reads single quotes, but consecutive delimiters are not reading as missed value. Is there any infile options or a statement that reads single quotations in data and consider missing value for consecutive delimiter.? Thank you

Online Status	Offline
Date Last Visited	‎10-11-2020 03:39 AM

Alerts are not in TDC_CONTRIBUTING_OBJECT table

sas trial - could not access SAS visual investigator

Testing teradata connection or any server connection

Re: %local question in my code

Re: %local question in my code

Re: %local question in my code

Re: Compatibility with Teradata 16.10

%local question in my code

Re: Compatibility with Teradata 16.10

Re: Compatibility with Teradata 16.10

Re: Proc compare ignore case specificity

Re: how to read a dot (or fullstop) in text file

Re: Where clause datetime format in Proc SQL SAS

Re: How SAS read two digit year in Oracle

Re: proc append- stop appending duplicate observation in Base table

Re: why my code is running very slow (Modify statement to update maste...

Re: why my code is running very slow (Modify statement to update maste...

why my code is running very slow (Modify statement to update master da...

Re: how to read mdyampm. dates (09/22/2015 20:15:32 AM)

how to read mdyampm. dates (09/22/2015 20:15:32 AM)

how to read mdyampm. dates (09/22/2015 20:15:32 AM)

Re: Can we use a condition for multiple variables

Can we use a condition for multiple variables

Re: how to read CSV file if some of values are in wrapped text when it...

how to read CSV file if some of values are in wrapped text when its cr...

Re: How to end sas session conditionally in Batch mode (UNIX)

How to end sas session conditionally in Batch mode (UNIX)

Can we insert observations from multiple sources into a sas dataset sa...

Re: how to read character data that has quotation.

how to read character data that has quotation.