The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » Opening dataset in SAS studio
Opening dataset in SAS studio [message #12528] Wed, 07 June 2017 21:28 Go to next message
sanash is currently offline  sanash
Messages: 3
Registered: June 2017
Member
HI,

I need some guidance for opening the unzipped sas datasets in SAS studio. The guide videos do not apply to the SAS studio. When I upload the dataset in SAS studio and use LIBNAME statement along with providing the path for the studio interface, I am still unable to open them. Using the DATA step, when I try to open the dataset, the output data shows no rows and states its got 1000 columns for all the 1000 variables but no observations. Your help will be much appreciated.
Re: Opening dataset in SAS studio [message #12547 is a reply to message #12528] Mon, 12 June 2017 17:35 Go to previous messageGo to next message
sanash is currently offline  sanash
Messages: 3
Registered: June 2017
Member
Hi,
I'm still looking for some guidance regarding opening the dataset in SAS studio. Here's my question:
"I need some guidance for opening the unzipped sas datasets in SAS studio. The guide videos do not apply to the SAS studio. When I upload the dataset in SAS studio and use LIBNAME statement along with providing the path for the studio interface, I am still unable to open them. Using the DATA step, when I try to open the dataset, the output data shows no rows and states its got 1000 columns for all the 1000 variables but no observations. Your help will be much appreciated."
Any help in this regard will be much appreciated.

Thanks.
Re: Opening dataset in SAS studio [message #12565 is a reply to message #12547] Thu, 15 June 2017 15:06 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User, You may want to unzip the files with the program which comes with your operating system before trying to use them in SAS. Please let us know if that works. If you don't have a program like that on your computer, you can download a trial version of WinZip at http:// www.winzip.com/landing/download-winzip-v1.html?target=br& ;gclid=CN2b2tbFwNQCFQqIaQodqnIA7g
Re: Opening dataset in SAS studio [message #12580 is a reply to message #12565] Fri, 16 June 2017 17:35 Go to previous messageGo to next message
sanash is currently offline  sanash
Messages: 3
Registered: June 2017
Member
Hi,

Thanks for the reply. Can I clarify that I don't have any issues unzipping the SAS data. The problem lies with opening it in 'SAS studio'. The guide video doesn't provide any hint about opening it in SAS studio which is different to SAS installed on the computer. The usual method of opening a SAS7BDAT format in sas studio is somehow not working. The usual process in sas studio involves uploading the file in a sas studio file folder and from there onwards I use the data step and using set statement, I provide the path of the file within the sas studio. Its somehow not working for DHS sas data and I don't have a clue. The output data that I get, shows 1000 columns (which is correct) but no rows.
Any further help will be hugely appreciated.
Re: Opening dataset in SAS studio [message #12591 is a reply to message #12528] Mon, 19 June 2017 11:08 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
I suspect that the problem is that the dataset you are trying to upload has more than 1000 variables, and I'm guessing that perhaps SAS Studio has a limit of 1000 variables. Perhaps try testing this with a dataset with less than 1000 variables. Try going to http://dhsprogram.com/data/Download-Model-Datasets.cfm and download zzpr62sd.zip, unzip this file and try to import it into SAS Studio. This file has less than 1000 variables, so it will give a clue if this is the issue.
Re: Opening dataset in SAS studio [message #16197 is a reply to message #12591] Tue, 20 November 2018 16:01 Go to previous message
ebphd is currently offline  ebphd
Messages: 1
Registered: November 2018
Member
Hello,
I am having the same issue. I successfully uploaded the sas code and sas7bdat to my folders in sas studio. I can also open both files when I click on them, but have no success with libname that shows the observations.

My data set has 309 observations and 26 variable names. The suggestions by sas community does not work.

Please advise.

Thanks,
ebphd
Previous Topic: label of variables in DTA file
Next Topic: Potential bias of DHS data set
Goto Forum:
  


Current Time: Thu Mar 28 10:05:19 Coordinated Universal Time 2024