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

[Jannet]

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=5924645...]

[Doc_Duke]

I get access denied on the google sheet.

[Jannet]

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

[Kurt_Bremser]

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.

[Jannet]

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

[Jannet]

@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

[Kurt_Bremser]

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.

[Jannet]

@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

[Kurt_Bremser]

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.

[Jannet · Accepted solution]

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