data import for Mixed Model Task help

lshortna — Mon, 20 Sep 2021 19:31:09 GMT

Hi there. I am trying to run a Mixed Model using the Tasks pane in SAS Studio. I have my xlsx file imported in my Server Files and Folders, but I can't seem to select or drag the specific file into the DATA drop down when trying the run the mixed model. My data file doesn't show up as an option to select. How do I get my data in to the Tasks tab?

Re: data import for Mixed Model Task help

Reeza — Mon, 20 Sep 2021 19:36:35 GMT

@lshortna wrote:

I have my xlsx file imported in my Server Files and Folders,

That means your file is uploaded but it does not mean it's ready for analysis.

You first need to import the XLSX file to convert it to a SAS file ideally - use an IMPORT task and note where you're saving the file. You should probably create a permanent library to save the file.

Then you can use the data tab shown in your screenshot to navigate to the file you've imported.

Note that while you import the file you need to ensure your variables are imported correctly. This means that no values are truncated, that numeric variables have the type numeric and categorical variables can be either numeric or character.

Import

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio?autoStart=true&q=xlsx

Mixed Modelling tips

https://video.sas.com/detail/video/4604338315001/tips-and-strategies-for-improving-mixed-models-performance?autoStart=true&q=mixed%20models

@lshortna wrote:

Hi there. I am trying to run a Mixed Model using the Tasks pane in SAS Studio. I have my xlsx file imported in my Server Files and Folders, but I can't seem to select or drag the specific file into the DATA drop down when trying the run the mixed model. My data file doesn't show up as an option to select. How do I get my data in to the Tasks tab?

topic Re: data import for Mixed Model Task help in SAS Software for Learning Community

data import for Mixed Model Task help

Re: data import for Mixed Model Task help