About KinjalPatel

KinjalPatel · ‎08-12-2019

Thank you Tom! You are genius!

KinjalPatel · ‎08-11-2019

Hello, I have multiple text files in zipped format in a folder. I want to get all filenames in one SAS dataset. For example: H:\SAS\Project\ABC_20190811.txt.gz H:\SAS\Project\PQR_20190811.txt.gz H:\SAS\Project\XYZ_20190811.txt.gz H:\SAS\Project\JKL_20190811.txt.gz Output: ABC_20190811 PQR_20190811 XYZ_20190811 JKL_20190811 Thanks, Kinjal

KinjalPatel · ‎08-11-2019

Thanks a lot for quick reply!

KinjalPatel · ‎08-11-2019

I have bunch of huge text files in zipped format (.txt.gz). Is it possible to read only column names in SAS from those files. Please guide me if you have any solution. Thanks, Kinjal

KinjalPatel · ‎09-19-2018

Dear, We have SAS dataset like below - ID NOTE 1 [18/07/2018] Hello [19/07/2018] Hello world 2 [20/07/2018] Hello [29/07/2018] Hello world We need to prepare dataset like below - ID DATE NAME 1 18/07/2018 Hello 1 19/07/2018 Hello world 2 20/07/2018 Hello 2 29/07/2018 Hello world Please provide me solution using DATA step as well PROC SQL. Thanks! Kinjal

Online Status	Offline
Date Last Visited	‎09-27-2021 12:50 PM

Re: How to read all .txt.gz filenames from a folder

How to read all .txt.gz filenames from a folder

Re: Want to Read ONLY column names from a huge text file

Want to Read ONLY column names from a huge text file

split one string into multiple row

Re: How to read all .txt.gz filenames from a folder

Re: Want to Read ONLY column names from a huge text file

Re: How to read all .txt.gz filenames from a folder

How to read all .txt.gz filenames from a folder

Re: Want to Read ONLY column names from a huge text file

Want to Read ONLY column names from a huge text file

split one string into multiple row