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)?
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.