I want to insert new rows below each record, where the text in one column (in my example Text2) is not null.  If it is null, then no inserting of a row.  In the inserted row, I want to copy the values of the first 2 grouping variables from the record, insert the text of "Text2" in the field of "Text1", and set the last 2 columns as null and .  (null numeric) respectively.    Sorry for the dummy data, but here is what I have: Group Class Text1 Text2 other1 count 1 A Text for Record 1 text1 AAAA 1 1 A Text for Record 2   CCCC 2 1 B Text for Record 3 text3 EEEE 3 1 C Text for Record 4 text4 GGGG 4   Here is what I want (inserted records in bold): Group Class Text1 other1 count 1 A Text for Record 1 AAAA 1 1 A text1   . 1 A Text for Record 2 CCCC 2 1 B Text for Record 3 EEEE 3 1 B text3   . 1 C Text for Record 4 GGGG 4 1 C text4   . ... View more

 I have a raw data file which is importing some text columns with tags on either side of the data.  The tags are not exactly the same on the left side for each case, and include no space.  An example would be this: <a href="a213w9245992999Vrh" target="_blank">PROPER DATA</a> I want to extract from that PROPER DATA. The alphanumeric portion after href= on the left side can vary from row to row.  I've tried this, but it does nothing. pos1=findc(StringVar, '>'); pos2=findc(StringVar, '</a>'); NewVar = substr(StringVar, nos1+1, nos2-1-nos2); I've tried this and had some result.  No change. pos1=findc(StringVar, '_blank">'); pos2=findc(StringVar, '</a>'); NewVar = substr(StringVar, nos1+1, nos2-1-nos2); How can I extract that text? ... View more

I have imported a data set which has warnings regarding some observations identified by row number.  I need to see what those are.  How do I run PROC PRINT with a WHERE condition to identify specific rows in the data set?  Where _n_ = 2385445 does not seem to work.  Thanks. ... View more

I have a CSV file that I am importing, and would prefer to have the import statement saved so that it can run regularly to import updates to the CSV file.  The file has a date variable stored as text in the format dd/mm/yyyy hh:mm (using 24 hr time).  I would prefer to see the imported date as DDMMYYYY HH:MM AM/PM.   I am importing on a data step using the infile statement.  Here is the gist of what I am running.   I get a blank column for date with the error: "Invalid argument to function INPUT".   Data Want; infile "C:\My File.csv"; length code $12 date $19 input code $ date $ ; date1 = input(date, Datetime19.); drop date; rename date1 = date; run; :      ... View more