Help using Base SAS procedures

Variables in Excel and Data in Text File

Reply
Regular Contributor
Posts: 229

Variables in Excel and Data in Text File

Hi

I am having variables in Excel sheet and the dataset was created and i have the data in txt file now i want to create the dataset with variables in excel and data in csv.

Excel Variable:
name age


Data in Text.
sas,23
bi,45
Nani,90
kool,89

output should be

name age
sas 23
bi 45
Nani 90
kool 89
Super Contributor
Posts: 474

Re: Variables in Excel and Data in Text File

No need to replicate your questions through multiple sections.

You've got your answer here:
http://support.sas.com/forums/thread.jspa?threadID=8322&tstart=0

Cheers from Portugal.

Daniel Santos @ www.cgd.pt
Ask a Question
Discussion stats
  • 1 reply
  • 101 views
  • 0 likes
  • 2 in conversation