- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Data Set -
How to convert this character dataset to variable. So that I can fetch data out of it....Having issue due to missing value...
Tried - RFICDAT = input(RFICDAT, 10.), RFICDAT = input(RFICDAT, 10.)
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Use a different variable name on the left hand side of assignment statement :
RFICDATnum = input(RFICDAT, 10.);
Koen
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Use a different variable name on the left hand side of assignment statement :
RFICDATnum = input(RFICDAT, 10.);
Koen
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You can't change the type of a variable, you have to create a new one, as shown by @sbxkoenk
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You are importing an Excel spreadsheet where the "header row" seems to be in a non-standard location. PROC IMPORT provides options to deal with this. Please show us a screenshot of the original spreadsheet.
The numbers you see are the raw values of Excel dates.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi, here is the screenshot for excel spreadsheet. Could you please let me know how to handle this in proc import directly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This looks straight forward. How did you import this spreadsheet (please post the complete code)?