The DHS Program User Forum: Dataset use (other programs)

Home » Data » Dataset use (other programs) » Opening dataset in SAS studio

Show: Today's Messages :: Show Polls :: Message Navigator

Opening dataset in SAS studio [message #12528]

Wed, 07 June 2017 21:28

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.

Report message to a moderator

Re: Opening dataset in SAS studio [message #12547 is a reply to message #12528]

Mon, 12 June 2017 17:35

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.

Report message to a moderator

Re: Opening dataset in SAS studio [message #12565 is a reply to message #12547]

Thu, 15 June 2017 15:06

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

Report message to a moderator

Re: Opening dataset in SAS studio [message #12580 is a reply to message #12565]

Fri, 16 June 2017 17:35

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.

Report message to a moderator

Re: Opening dataset in SAS studio [message #12591 is a reply to message #12528]

Mon, 19 June 2017 11:08

Trevor-DHS
Messages: 803
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.

Report message to a moderator

Re: Opening dataset in SAS studio [message #16197 is a reply to message #12591]

Tue, 20 November 2018 16:01

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

Report message to a moderator

Previous Topic:	label of variables in DTA file
Next Topic:	Potential bias of DHS data set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 12:44:50 Coordinated Universal Time 2024