About sas_lak

sas_lak · ‎07-22-2014

Thank u all, I got it.

sas_lak · ‎07-18-2014

This is my Daily Activity i need to finalize the Macro automation in Base sas. 1. Every day i received txt files (filename ending with yesterdays date - Ex:- xxxxxx_17jun2014.txt) 2 I dont know how many file are client given but file name should be same and yesterdays date and number of the file ( Ex:- xxxxxx_17jun2014_1.txt , xxxxxx_17jun2014_2.txt ...... xxxxxx_17jun2014_n.txt ) 3. I need to import all available files at a time run some Analysis. 4. Important thing is "Want to schedule the project and that is running for each and every 10 mints" A. I dont know when they will upload, My code need to check the files are available. B. If Files are available and file names matching with yesterdays date then start the process. C. Once output file is stored into same folder need to stop the activity. Note:- I already developed the entire code in SAS EG4.0 and Schedule the projects, but now Iam working on SAS9.3. Could you please help me out how to schedule the projects in base sas. Thanks in Advance.

sas_lak · ‎07-17-2014

/* Try this, to get first record and 5th record from last */ proc sql; create table first_1_last5_record (drop=SL_NO) as select monotonic() as SL_NO,* from HAVE having monotonic()=min(monotonic(SL_NO)) or monotonic()=MAX(monotonic(SL_NO))-4 ; quit;

sas_lak · ‎07-17-2014

Thank u RW9, But small correction from your code I dont want remove any numbers from the data, which is, data ending with numbers like 3 AAAAAA BBBBB CCCCCCCC segment Required0048158 need to remove 0048158 only.(not any numbers from middle of the data) Could you please help me to get it.

sas_lak · ‎07-17-2014

Hi All, And Thank you for quick Response. data have; input error $200.; cards; 1 LLLL MMMMM NNNN Missing0048165 2 LLLL MMMMM NNNN Missing 3 AAAAAA BBBBB CCCCCCCC segment Required0048158 4 AAAAAA BBBBB CCCCCCCC segment Required 5 XXXX YYYYYY ZZZZZZ (Required) Missing0000047 6 XXXX YYYYYY ZZZZZZ (Required) Missing ; run; From here - if data is ending with number need to remove the number (if number is available on end of the data its not same and having differnt length) output like 1 LLLL MMMMM NNNN Missing 2 LLLL MMMMM NNNN Missing 3 AAAAAA BBBBB CCCCCCCC segment Required 4 AAAAAA BBBBB CCCCCCCC segment Required 5 XXXX YYYYYY ZZZZZZ (Required) Missing 6 XXXX YYYYYY ZZZZZZ (Required) Missing

sas_lak · ‎07-17-2014

Hi All, Please help me with Syntax /* How to take last 5 characters from a string */ Ex:- Number in Text Number 1234567890 123456 987654321 8888888 999999999 4242424 Output should be like Number 67890 23456 54321 88888 99999 42424 Appriciate in advance

sas_lak · ‎07-15-2014

Thnank you for your valuable information I Think we can use SOUNDEX Function to get exact Duplicates values. proc sql; create table dups as select distinct a.*, b.* from have as a,have as b where soundex(a.name) eq soundex(b.name) and a.phone ne b.phone order by a.name ; quit;

sas_lak · ‎07-15-2014

Hi I am Sorry for small correction in data. looking the duplicate data within the same dataset by the different fields Ex:- data have; input name $5.+1 phone $5.; cards; AAAAA 12345 AAAAC 12345 AAAAA 09876 BBBBB 12345 CCCCC 99999 DDDDE 88888 DDDDD 88888 DDDDD 55555 EEEEE 44444 FFFFF 11111 ; RUN; Am looking duplicate phone numbers by Name.(Same name having different Phone numbers) Ex:- Name Phone AAAAA 12345 AAAAA 09876 DDDDE 88888 DDDDD 55555 I think we can use Soundex function to get exact duplicate values by proc sql; plz any one help me with syntax. Would Appreciate in Advance.

sas_lak · ‎07-15-2014

Hi, I am not sure it may be happen some times, If we are using the procedure like Proc Printto log="xxxxxxx\log.txt"; run; automatically log information stored into output file not in log window. better to stop log into outfiles.

sas_lak · ‎07-15-2014

/* Using the PutName=No output file doesnot have any kind of headers */ proc export data=Out outfile="C:\Users\lakshman\Desktop\New Folder\Out.txt" dbms=dlm replace; delimiter="|" ; putname=no; run;

sas_lak · ‎07-14-2014

data date_formats; input date $50.; cards; 28-05-2014:10:21:20 27-05-2014:14:22:26 27-05-2014:11:36:33 27-05-2014:17:14:55 27-05-2014:10:34:56 27-05-2014:19:03:48 27-05-2014:14:30:56 ; run; data out; set date_formats; new_date=input(date,anydtdtm.); /*converting character to date format */ format new_date datetime18.; /* Printing the data into wanted format */ run;

sas_lak · ‎07-14-2014

/* when the data having multiple delemiters and different length we should give the proper position or length for the data */ DATA OUT_PUT; INFILE DATALINES DLM='|/-\*,'; INPUT ID @+0 NAME $ @+0 VALUE @+0; /* DEFINE THE LENGTH AND POSITION */ DATALINES; 101|JASMINE/3000 102-ROY\5000 103*DAVID,7000 ; run;

sas_lak · ‎07-14-2014

Hi All, Can any one help me to re correct the below data into proper format Ex:- XXX@GMMIL.COM ---------------------- @GMAIL.COM YYY@GMIL.COM ZZZ@GMAILL.COM XXX@YAHOOO.COM ---------------------- @YAHOO.COM YYY@YHOO.COM ZZZ@YAHOHO.COM XXX@HOOTMAIL.COM ---------------------- @ HOTMAIL.COM YYY@HAATMAIL.COM ZZZ@HITMAIL.COM I tried to convert into proper format using SPEDIS Function but am not able to get it.

sas_lak · ‎06-27-2014

Hi from sas we can COPY, PASTE, CUT and DELETE the raw datafiles using X - Statement Ex:- X 'COPY "Path exist folder\test.txt" "Defined folder\out.txt"'; X MOVE "Path exist folder\test.txt" "Defined folder\out.txt"';

sas_lak · ‎06-26-2014

U can import more than two raw data (TXT) files at a time. Usung File Name Ex:- u have 10 text files in the same folder but different file Names like 1.File_1,File_2, File_3, .................... filename any_name ("File_Path\File_*.txt"); data Final_Dataset; infile any_name dlimiter = '|' DSD missover lrecl=32767 firstobs=1; informat var_1 $10.; informat var_2 $10.; informat var_3 $10.; format var_1 $10.; format var_2 $10.; format var_3 $10.; input Var_1 $ Var_2 $ Var_3 $ ; run;

Online Status	Offline
Date Last Visited	‎01-14-2016 05:20 AM

Re: URGENT - Need to split and arrenge in required format - in SAS

URGENT - Need to split and arrenge in required format - in SAS

Re: ODS HTML - Multiple Excel Sheets

ODS HTML - Multiple Excel Sheets

Re: Find list of words from Table

Re: Find list of words from Table

Re: Find list of words from Table

Find list of words from Table

Re: NAME SALUTATIONS.....! (Cleaning)

Re: NAME SALUTATIONS.....! (Cleaning)

Re: ODS HTML - Multiple Excel Sheets

Re: ods excel tagsets - center horizontal

Re: Find list of words from Table

Re: Find list of words from Table

Re: Find list of words from Table

Re: Proc SQL - to get first row and last 5 rows

Last 5 characters from string (irrespective of the length)

Re: How to copy a .txt file from one host to another host through sas ...

Re: How to convert character datetime to numeric datetime?

Re: Miss Match data from same dataset (get duplicates)

Re: /* How can i schedule the projects in base SAS 9.3 */

/* How can i schedule the projects in base SAS 9.3 */

Re: Proc SQL - to get first row and last 5 rows

Re: Irrespective of Length, remove numarics on end of the data

Irrespective of Length, remove numarics on end of the data

Last 5 characters from string (irrespective of the length)

Re: Miss Match data from same dataset (get duplicates)

Miss Match data from same dataset (get duplicates)

Re: Display log or dataset programmatically

Re: put text file without header

Re: How to convert character datetime to numeric datetime?

Re: How to convert character datetime to numeric datetime?

data correction (mail id conversion using SAS)

Re: How to copy a .txt file from one host to another host through sas ...

Re: Import Files in Sequence Based on File Name