BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
gahlot1999
Fluorite | Level 6

Data Set - 

gahlot1999_0-1651441578452.png

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.)

1 ACCEPTED SOLUTION

Accepted Solutions
sbxkoenk
SAS Super FREQ

Use a different variable name on the left hand side of assignment statement :

 

RFICDATnum = input(RFICDAT, 10.);

 

Koen

View solution in original post

5 REPLIES 5
sbxkoenk
SAS Super FREQ

Use a different variable name on the left hand side of assignment statement :

 

RFICDATnum = input(RFICDAT, 10.);

 

Koen

andreas_lds
Jade | Level 19

You can't change the type of a variable, you have to create a new one, as shown by @sbxkoenk 

Kurt_Bremser
Super User

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.

gahlot1999
Fluorite | Level 6

Hi, here is the screenshot for excel spreadsheet. Could you please let me know how to handle this in proc import directly.

 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 427 views
  • 2 likes
  • 4 in conversation