BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I am having daily sheets of 200 Excel sheets in a folder ,all are having same variaables .I want to create only one datset from all the 200 excel sheets
2 REPLIES 2
Peter_C
Rhodochrosite | Level 12
is this a random collection of excel worksheets?
do these excel sheet have the same layout? (column order, data types, string lengths)?
do they have column headers in the first row, which are sufficient to identify that column of data and are these column headers unique enough to join similar data from all these sheets?

of course you could hope that running 200 proc import will provide coinsistent result data, but an obvious string column in one won't join up adequately with the same named column in other sheets when the others are empty or numeric.

good luck
ArtC
Rhodochrosite | Level 12
A first pass would be to use PROC IMPORT for each sheet to create a work data set for that sheet followed by an APPEND (PROC DATASETS). It should be fairly easy to automate the process for all the sheets.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 2 replies
  • 589 views
  • 0 likes
  • 3 in conversation