Sorry I misunderstood your original question. There are two parts to this question.
First, the file from the NREL India Solar Resource Database, which is in the NREL TMY3 format, does not have values for the Station Name and Station State fields, so SAM displays "satellitedata" and "??" for those fields. You can change the values of those fields in the header as you attempted to do. For example:
Original header:
075052505," ""satellitedata""", ??, 5.5, 25.05, 75.05, 419.0
Modified header:
075052505,"City Name", State Name, 5.5, 25.05, 75.05, 419.0
That will result in more meaningful information being displayed on the Location and Resource page City and State fields, and in the PDF report. However, the Country and Data Source fields on the Location and Resource page will still be empty.
Second, the "Country" and "Data Source" fields are not part of the TMY3 file format. If you want those fields to appear on the Location and Resource page, you'll have to convert the file from the TMY3 format to the SAM CSV format, which you can do in these sixteen easy
steps:
Create a folder on your computer to store your custom weather files.
Make a copy of the original TMY3 format file in case you make a mistake and need to start over.
Use a text editor to open the copy of the TMY3 format file, and change the Station Name and Station State values as I describe above. Enclose the station name in quotes, but not the state name or abbreviation. Avoid using Microsoft Excel for this step because it adds quotes and changes number formatting in ways that can render the file unreadable.
Save the modified file to the folder you created in Step 1.
In SAM, create or open a .sam file with a PVWatts case (or any other solar performance model) and any financial model.
Click Macros at the bottom left of the window.
Click Weather File Converter, and read the instructions to understand what the macro will do when you run it.
Click Run macro near the top of the window.
Open the file from Step 3. If all goes well, you'll see a message that says "Weather file successfully converted. Open it?" You will also see that the macro named the file something like USA IN Station Name (TMY3).csv.
Click Yes to open the file in Excel. Alternatively, you can click No, and open it yourself with a text editor.
Edit the second row of the header so that it looks something like this:
Source,Location ID,City,State,Country,Latitude,Longitude,Time Zone,Elevation
NREL,75052505,City Name,State Name,India,25.05,75.05,5.5,419
Save and close the file. You can save it with a name like India Station Name (NREL).csv.
On the Location and Resource page, click Folder Settings, and add the folder you created in Step 1 to the Solar Data File Folders list.
Click Refresh library.
You should see the file listed in the library toward the bottom.
There, wasn't that easy?
Note that I recommend not using Excel to edit the TMY3 format file in Step 3, but say it's OK in Step 10. That is because the SAM CSV format is more flexible than the TMY3 format, and Excel's automatic number or date formatting is less likely to cause problems with the SAM CSV format.
Best regards,
Paul.