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.)
Use a different variable name on the left hand side of assignment statement :
RFICDATnum = input(RFICDAT, 10.);
Koen
Use a different variable name on the left hand side of assignment statement :
RFICDATnum = input(RFICDAT, 10.);
Koen
You can't change the type of a variable, you have to create a new one, as shown by @sbxkoenk
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.
Hi, here is the screenshot for excel spreadsheet. Could you please let me know how to handle this in proc import directly.
This looks straight forward. How did you import this spreadsheet (please post the complete code)?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.