topic Re: How to extract date from start date (description part) and create a variable in the dataset in SAS Programming

How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 16:06:12 GMT

Currently, i have dataset which is combination of multiple txt file. Now, i want to create a variable called Date (the value should be extracted from the description part called start date for each dataset) Can you please help? If you see the start date, it repeats every 133 rows from the first dataset. I want date to be displayed from the each start date.

I am attaching the dataset. [https://docs.google.com/spreadsheets/d/1fswojOKc0WtGh1hVJQfm39p6qf-eAojN/edit?rtpof=true#gid=592464518]

Re: How to extract date from start date (description part) and create a variable in the dataset

Doc_Duke — Sun, 15 Nov 2020 16:09:46 GMT

I get access denied on the google sheet.

Re: How to extract date from start date (description part) and create a variable in the dataset

Kurt_Bremser — Sun, 15 Nov 2020 16:12:41 GMT

Please post datasets as self-contained data steps with datalines.

Your google drive is not publicly accessible, BTW.

From your description, I guess you need to RETAIN date, and set it whenever start_date is not missing.

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 16:13:56 GMT

Oh sorry....this is imported dataset...so let me send you the dataset ..give me 2 mins

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 16:16:04 GMT

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 16:20:42 GMT

Hi, i have gave access to google sheet, please check ...Also, i have attached the dataset

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 16:25:54 GMT

@Kurt_Bremser, please check the dataset....It would be great help if you can help me ....I am struck here...Also, I want to extract siteID, station number similarly like date and create a variable separately

Re: How to extract date from start date (description part) and create a variable in the dataset

Kurt_Bremser — Sun, 15 Nov 2020 17:00:01 GMT

As already stated, the best way to post data is a data step with datalines. No virus scans, no blocking firewalls, and on top we get an exact picture of your dataset, which we NEVER gef from a spreadsheet.

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 17:18:35 GMT

@Kurt_Bremser actually its a big dataset...it takes time to provide the data step 😞 Hence, i sent u the dataset directly...i gave access to dataset in google sheet...plz try if it works

Re: How to extract date from start date (description part) and create a variable in the dataset

Kurt_Bremser — Sun, 15 Nov 2020 17:47:38 GMT

So you get that as text files. Please open such a text file with an editor (do NOT open it with Excel!) and copy/paste the header and the first few data lines into a window opened with the </> button. We can then provide you with code that reads the data correctly from the text files in the first place.

Re: How to extract date from start date (description part) and create a variable in the dataset

Jannet — Sun, 15 Nov 2020 18:14:04 GMT

Hello all, i have sorted it...:)