cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
imvenky
‎07-07-2017
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Extract Information from variable

by Calcite | Level 5 in SAS Programming
‎06-30-2017 09:54 AM
‎06-30-2017 09:54 AM
Hi @RW9   the input file that i have is a csv and it doesn't have a variable name over there I imported it to sas dataset and it just cameup like that what i have in csv is name=sammy id=123456 size=213456 type=txt name=dummy id=34256 size= 2314 type=xlsx name=sample id=12456 size=1111111111 type=doc   what i want in new dataset is name     id           size              type sammy  123456  213456           txt dummy  34256    2314               xlsx sample  12456     1111111111     doc   thanks venky     ... View more

Extract Information from variable

by Calcite | Level 5 in SAS Programming
‎06-30-2017 09:37 AM
‎06-30-2017 09:37 AM
Hi Guys i have a single variable with all the data in that i need to create multiple variables out of it i have been trying it with substring function but no luck can you please help me out with this thanks   what i have: sample  name=sammy id=123456 size=213456 type=txt name=dummy id=34256 size= 2314 type=xlsx name=sample id=12456 size=1111111111 type=doc   what i want in new dataset is name     id           size              type sammy  123456  213456           txt dummy  34256    2314               xlsx sample  12456     1111111111     doc   thanks again   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-07-2017 10:19 AM
Quick links